Candidates About

 

Shahriar Mustafa

 

SUMMARY:

·         7+ years of extensive experience in Data Analysis, System Analysis, Data Extraction, Data Validation, Data Collection, Development and Testing support in Application and Data warehousing environments.

·         Good Data Analysis and Data validation background with the ability to support Business Reporting and Decision making capabilities.

·         Experienced in using Teradata load utilities, BTeq, SQL Assistant, Oracle Pl/SQL, UNIX Shell scripts, and MS Excel.

·         Worked extensively in a complex, high-volume environment dealing with terabytes of data.

·         Proficiency in building optimized queries in Teradata and Oracle.

·         Good experience in writing UNIX shell scripts utilizing BTEQ and Mload to interact with Teradata database.

·         Interacted with Business Analysts, Operation Analysts and Project Managers to gather business and database requirements, draft specifications and build scripts.

·         Validate data against business requirements for identifying outliers before providing to data requestors.

·         Experienced working with Excel Pivot and VBA macros for various business scenarios.

·         Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica PowerCenter Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.

·         Excellent experience in analysis huge volumes of data in industries such as Finance, Healthcare & Retail.

·         Excellent knowledge on creating reports on SAP Business Objects, Web reports for multiple data providers.

·         Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders

·         Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.

·         Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects  

·         Experience in developing batch programs by using SQL, SAS & shell scripts and scheduling the processes to run on a regular basis.

·         Expertise in creating reports using SAS by gathering data from several databases like Oracle, Teradata etc.

·         Created ad-hoc reports and provided data for monthly & weekly business review meetings using SQL, SAS, Ms Excel and UNIX.

·         Strong ability to perform root-cause analysis on data outliers found during data validation.

 

TECHNICAL SKILLS:

 

BI Reporting tools: Tableau, Crystal Reports, SQL Server Reports (SSRS), Cognos,

Operating systems: Windows, UNIX

Data warehousing Tools: Informatica, Business Objects, Erwin

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Databases: MS SQL Server, MS Access 2000, Oracle

RDBMS: Oracle, SQL Server, Teradata, MS Access

Computer Skills: MS Office - Excel (vlook up, hlook up, pivot tables), Word, Access, Outlook, Publisher, PowerPoint, SharePoint.

Languages: SQL, PL/SQL, HTML, C, JAVA, VBA

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

 

WORK EXPERIENCE:

Fidelity Investment, Covington, KY                                                                       Feb 2014 Present

Data Analyst

Fidelity Investments is a group of privately held companies in the financial services industry. Fidelity Investments includes a large family of mutual funds, their distributors and investment advisors, and a retail brokerage, as well as unrelated business. Fidelity Investments is the leader in the 401(K) business. The Small Business Sector (SBS) of Fidelity Investments wanted to start a new Competitive Intelligence (CI) unit to analyse and strategize the competitors by creating a knowledge base internally in a Microsoft Share Point Intranet My job was to help design the entire Competitive Intelligence Infrastructure for the SBS in Kentucky. The Project was involved in Data Warehousing which was developed to integrate operational systems into one central database structure. Informational queries can be obtained from the Data Warehouse that identifies customer behaviour patterns.

Responsibilities:

·         Interacted with business heads to finalize the Business Requirements for the application.

·         Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose

·         Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.

·         Utilized ODBC for connectivity to Teradata & MS Excel for automating reports and graphical representation of data to the Business and Operational Analysts.

·         Worked on loading data from flat files to Teradata tables using SAS Proc Import and Fast Load Techniques.

·         Documented Business Process Requirements with Use Cases and facilitated JAD sessions to define AS-IS and TO BE-IT processes.

·         Helped with Data Mapping between the data mart and the Source Systems.

·         Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.

·         Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.

·         Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment.

·         Performed trouble-shooting relating to client- queries relating to valuation of Interest rate, FX, Equity, derivatives (primarily for OTC instruments) done by Vendor system by performing these valuations on Bloomberg or alternative systems or in a spreadsheet.

·         Extensively used Teradata Advanced Techniques in writing the scripts.

·         Generated flat files using the Teradata Export for the Segmentation process.

·         Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency)

·         Used Data warehousing for Data Profiling to examine the data available in an existing database.

·         Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).

·         Created report specifications containing mapping to source data sources.

·         Created Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.

·         Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.

·         Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.

·         Worked on ETL design for various source systems.

·         Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.

·         Flat file conversion from the data warehouse scenario.

·         Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.

Environment: SDLC, SQL Erwin, Quest Central for DB2 v 4.8, PL/SQL, SQL Query, Business Intelligence, Business Objects, COBOL copybooks, SAS, OLTP, ERwin 7.2/4.x, ER Studio, Mainframe DB2, VLDB(>1TB), Mercury Quality Center 9, Informatica PowerCenter 8.1, Oracel 9i

 

 

 

Wells Fargo, Minneapolis, MN                                                                           May 2012- Jan 2014

Data Analyst

 

The purpose of this project involves population of the Enterprise Data Warehouse (EDW) which is used in critical reporting and analysis. Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system.

Responsibilities:

·         Created test scenarios, test data executed for test cases.

·         Performed multiple source data analysis for the input OLTP systems.

·         Coordinated multiple OLAP and ETL projects for various data lineage and reconciliation.

·         Debugging the SQL-Statements and stored procedures for business scenarios.

·         Performed extensive Data Validation, Data Verification against Data Warehouse.

·         Experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of data warehouse

·         Validating and profiling Flat File Data into Teradata tables using Unix Shell scripts.

·         As Data analyst responsible for the understanding the business data requirements, ETL and subsequently creating testing of data in reports.

·         Tested several BO Reports for completeness, quality for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI's, Grouped List, Cascade and Web Reports.

·         Analysed the bug reports in BO reports by running similar SQL queries against the source system(s) to perform root-cause analysis.

·         Created and Reviewed Informatica Mapping documents to with business and data governance rules.

·         Created SQL queries to generate ad-hoc reports for the business.

·         Translated cell formulas for business users in Excel into VBA code to design, analyse, and deploy programs for their ad-hoc needs.

·         Created and updated metadata repository in Oracle for End to end DW.

·         Designed and prepared scripts to monitor uptime/downtime of different system components.

·         Interacting with senior peers or subject matter experts to learn more about the data.

·         Extensively worked on data profiling and scanning to de-duplicate records in the staging area before data gets processed.

Environment: Informatica 8.6.1, Business Objects XIR3, WinSQL, QTP 9.2, Quality Center 9.2, TOAD, Oracle 9i/10g, SQL, PL/SQL, IBM DB2, VBA MS Excel.

 

Capital One, Richmond, VA                                                                                  Jun 2010- Apr 2012

Data Analyst

Data Conversion/Data remediation for C&CIP (Bank Data warehouse BDW): The primary focus is on data remediation/quality in the Legacy Sales/CIS/Loan and Deposit systems of the Bank Data warehouse before consolidating them as a part of the Bank integration project. For SRM, the SASI DA Remediation team is providing a link of legacy client / prospect to customer records and the initial input for the Coverage (Data Model) team.

Responsibilities:

·         Data Remediation to support Legacy systems conversions for C&CIP (Commercial and Credit Risk Infrastructure Program) as well as building out "future state" reporting to monitor data quality in these areas post C&CIP (Customer and Sales systems)

·         Involved in Account Level Monitoring (ALM), Customer Level Monitoring (CLM) and Relationship Level Monitoring (RLM).

·         Participated in Scope and Kick Off meetings for getting direction towards the scope of SRM (Sales Relationship Management) and WCIS (Wholesale Customer Information Systems) systems.

·         Writing SQL involving complex queries, joins, sub queries and creating temp tables, using Teradata SQL Assistant and SQL Developer for data requests.

·         Used SAS enterprise guide for loading data from excel, csv and text files into SAS data sets and then into Teradata tables.

·         Developed tables, views and temp tables for the Users of Bank DWH data.

·         Created Adhoc reports for business users.

·         Built Pivot tables in Excel and reporting using Excel for Bank users.

·         Created Data mapping documents for reference.

·         Analysed Source to target mapping documents and Metadata documents and Rochdale metadata repository to understand the business definitions and work flow of the data.

·         Writing SQL involving complex queries, joins, sub queries and creating temp tables, using Teradata SQL Assistant and TOAD for audit testing.

·         Performed Code reviews, Report reviews and Data Validations as part of Audits.

·         Provided final report with the Testing done and data results and a field work report.

·         Maintaining Audit department SQL Server databases, maintaining Tables, Views, DTS packages, Jobs.

·         Developed tables, views and temp tables for the DWH data of the Audit Department.

·         Maintaining and administering D3 Security System's DBs on the SQL Server.

·         Creating and maintaining DTS/SSIS packages, Full/Transactional Backups. Creating jobs for DB backups and DTS packages for other DWH data loads for the Audit team DBs’

·         Experience in DataMart/Database remodelling - using Visio identifying new relationships and creating Primary and Foreign keys; enhancing existing relationships, reducing number of tables, views, joins for renormalization. 

Environment: Teradata, Teradata SQL Assistant, Oracle, SQL Developer, TOAD, Excel, Win XP

 

Medco Health Solutions, Franklin Lakes, NJ                                              Jan 2009- May 2010

Data Analyst

Medco is a health care company offering pharmacy services to a wide variety of customers. Data Segmentation/Campaign Management team builds targeted campaigns by customer segmentation at various levels to market specialty class of drugs (Drugs designed to treat rare diseases). The main intent was to convert eligible members using a retail pharmacy to use mail pharmacy i.e. to order via the company's web portal and or use the phone ordering system. Campaigns were also developed to inform eligible members of alternate pricing options and efficient drug access locations for Specialty Drugs. Existing members are evaluated and those who qualify are segmented into different buckets. Campaigns are designed for each bucket for better reach and for winning new customers as well as maintain existing customer base.

Responsibilities:

·         Create scripts for applying member evaluation rules and loading the qualified members into the DataMart using Shell scripts and BTeq.

·         Analyse and ensure that the scripts follow campaign flowchart as per intent.

·         Create complex queries to apply segmentation rules from time to time as provided by the business analysts for building the target buckets.

·         Analyse data from time to time to identify anomalies in the qualified membership.

·         Analyse and evaluate source data for any members disqualified for targeting to ensure that the business rules have been applied properly.

·         Design, develop weekly, monthly reports related to the targeted segments and ensuing results by using Teradata SQL, UNIX and MS Excel.

·         Analyse data analysis requests obtained from management to determine operational problems.

·         Based on data analysis define data modeling requirements and validation of content.

·         Create business reports for exclusions/ segmentation scenarios.

·         Submit all vendor approvals, receivables to concerned Process manager for final approval before data handoff.

·         Handoff data for offer treatment via vendor specific formats.

·         Load all solicited account related info onto production table for future analysis by the analytical teams.

·         Discuss any campaign execution related issues during and after completion of a campaign to streamline the Business, Process and Intent execution teams

·         Assist business users identify opportunities to use data to develop new strategies.

·         Develop data structures to support generation of business insights and strategy.

·         Develop automation scripts for regular processing and maintain data infrastructure.

·         Inform all teams concerned Business, Execution, Process and Analytical about successful completion of a Campaign.

·         Facilitate identification of potential gaps in available data and collaborate with business users to identify the best way of acquiring the data needed.

·         Provide trouble resolution and serve as point of technical escalation on complex problems.

·         Develop root cause analysis activities that resolve significant data issues.

·         Develop test plans, test cases to ensure quality of Implementation.

·         Perform impact analysis on change requests and effectively communicate the same to the business user group.

·         Suggest performance enhancements to the existing queries after thorough regression testing.

Environment: Teradata V2R6/V2R5, SQL Assistant, Business Objects, IBM AIX, Windows NT/2003/XP, ClearCase.