PROFESSIONAL SUMMARY:

• Professional with 12+ Years of Financial Services Experience with focus in Data Analysis, Modeling, Data Mapping, Data Warehousing, Business Intelligence
• Lean six sigma Greenbelt certified professional.
• Proficient in Requirement Management, including requirement gathering, analyzing, validating & documenting
• Ability to transform the needs of Business Users and Stakeholders into Functional/Technical Requirements
• Adept at preparing Business Requirements (BRD), Converting into data requirements and Functional Specification Document (FSD), Data Mapping Specifications, defining project plans
• Expert at data profiling, data analysis, designing & reengineering system application and business process
• Expert experience in creating visualizations, dashboards, reports and schedules using Tableau Desktop and Tableau Server. Extensive knowledge and experience in various reporting objects like facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters and Administration in Tableau.
• Expertise in working in Teradata SQL Assistant V9 and used utilities like MultiLoad, FastLoad, BTEQ, FastExport, Teradata SQL
• Expertise in working in AWS Cloud Redshift database used SQL and Workbench .
• Strong understanding of Data Warehouse concepts, OLAP, OLTP, Star Schema, Data modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Fact & Dimensions tables, Physical & Logical Data Modeling & ER diagrams
• Strong experience developing SAS procedures, macros, merges, data steps for data cleaning, formatting and reporting.
• Experience in Data Cleansing, Data Archival, Data Migration, reporting and coding utilizing SAS.
• Expertise in creating reports using reporting tools like Crystal Reports, SAP Business Objects WebI and Tableau 9.1 and 10.1 versions.
• Experienced in developing Web Services with Python programming language.
• Strong ETL development experience in sourcing data from several disparate data sources legacy Oracle databases, Flat files, XML, SQL/PLSQL, Responsible for all activities related to the development, implementation and support of extract transformation and load (ETL) processes for large - scale Data Warehouses and Data Marts.
• Good domain knowledge and working experience in Client Reporting, MIS Reporting, Regulatory Reporting, Investment Banking & Credit Risk Rating, Mortgage Private Banking, Wealth Management
• Excellent understanding of various Asset Class(e.g. Cash Equities, Payments, Derivative/Structured Products)
• Strong experience in Business Intelligence/Data warehouse implementation
• Well versed with Reference Data Management, Trade Life Cycle, Straight Through Processing
• Possess excellent hands on experience on Relational Databases, SQL Scripting, creating views reports
• Skilled in Gap analysis, Impact Assessment, Risk measurement with good understanding of process workflow
• Conducting defect triage, SIT & UAT coordination
• Good expertise in extracting data sources from excel spreadsheets and Oracle tables to SAS using SAS Data Integration Studio, SAS/ETL, SAS/ACCESS, SQL pass through facility. Experience in generating RTF, HTML and PDF formatted files using SAS/ODS.
• Strong experience in data verification, validations, regression testing and performing Reconciliations with Source and target Database data.
• Possess excellent hands on experience on Relational Databases, SQL Scripting, creating views reports.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin7/8, MS Visio 2007/2010, ER Studio, Oracle Designer.

Database Tools: Microsoft SQL Server 2008 Oracle 9g/10g/11g, PL/SQL, MS Access, Teradata, AWS Redshift, SQL Workbench, Tableau.

Reporting & Other Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP(Online Analytical Processing), Multi-dimensional Cubes and Business Intelligence & Development Studio, SQL BI

ETL Tools: SSRS, SSAS, SSIS (SQL Server Integration Services), Data Transformation Services (DTS), IDQ, Informatica .

Environment: Windows, IBM Mainframe, MVS, UNIX, Linux.

Languages: C, C++, Python, Py Pandas, Splunk, SQL, PL SQL, T SQL, XML,VB Script, Java Script.

Packages: Microsoft Office 2007/2010, Microsoft Project 2010, Microsoft Visio, Share point Portal Server 2003/2007.

Specialties: Business Analysis, Stakeholder Management, Team Management

Banking Processes: Reference & Client Data Management(RDM & CDM), Credit Processing & Credit Risk Management, Trade Life Cycle & Straight-through Processing (STP)

Application: Temeno’s T24, Quality Center, Traceability Matrix,Splunk

Functional Strengths: Wealth Management, Management Accounting, Business Analytics, Equities, Derivatives, Forex, Data Analysis & Reconciliation, Regulatory Reporting, Client Reporting

Technical Strengths: Business Intelligence, SQL Server (SSAS,SSRS,SSIS), DTS, ORACLE, QlikView, Hyperion, Business Objects,Tableau, Platinum Erwin, MS Visio, Informatica, Java, JDBC, J2EE,Java Script, DOORS, HP - ALM, XML, Advanced Excel Skill, SQL Scripting .

PROFESSIONAL WORK EXPERIENCE:

Confidential, McLean, VA

Senior Data Analyst

Responsibilities:

• Facilitated meetings with the business team, SME’s and partners to formulate business strategy and requirements and translate the customer needs /business requirements into specific system requirements
• Carry out detailed analysis for existing system in Teradata.
• Migrated the Teradata scripts into AWS Redshift database.
• Performed calculations with aggregate functions, dynamic charts and graphics, data sets, connected joins, combined data sources using Tableau
• Cleaned and formatted dirty data in redshift using SQL workbench and python queries .
• Analysed the source data performed ETL scripts to flow the data source databases and created target aggregated datasets in Redshift using SQL workbench,
• Sourced dimentional lookups and static flatfiles data from Teradata and postgre tables with python scripting .
• Analysed the target report requirements from the business and created and published the creditwise dashboard, upmarketing dashboards in tableau .
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created dynamic tableau dashboard reports
• Wrote python scripts to parse and load the data in database
• Created data trace map and data quality mapping documents.
• Performed data profiling and data quality in the source systems
• Prepared requirement traceability matrix to verify and validate the requirements.

Tools: AWS Cloud Redshift databse, UltraEdit SQL, S3, SQL Workbench, Teradata 14, postgre, Python, UNIX Shell, Windows XP, MS Excel,Splunk.

Confidential, New York, NY

Senior Data Analyst

Responsibilities:

• Carry out detailed analysis for existing system
• Performed calculations with aggregate functions, dynamic charts and graphics, data sets, connected joins, combined data sources using Tableau
• Cleaned and formatted dirty data using SAS Software to be presented in more readable format for my peers.
• Used SAS and SQL skills to perform ETL from Teradata databases and created SAS datasets, SAS macros, Proc/data steps and SAS formats as required.
• Developed reports through ETL Process,Tableau Software, SAS, MS Excel, Services and Analytics Services, Remedy and other typical reporting methods as requested/approved by Client’s management.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Business requirement gathering & analysis
• Business process and workflow analysis
• Stakeholder Management
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Facilitated meetings with the business unit team, SME’s and partners to formulate business strategy and requirements and translate the customer needs /business requirements into specific system requirements
• Translate business requirements into system requirements (functional and non-functional) detailed specification documents (functional and non-functional - SRS) and Technical design documents.
• Used the most efficient data management tools such as: SQL and TOAD to provide data, analyze data, identify and document gaps, and enable self- service.
• Providing the appropriate formats for reporting and/or automation solutions based on users requirement
• Document data flow diagrams; develops business requirements for data provisioning; writes run-books and scope documents.
• Wrote python scripts to parse XML documents and load the data in database
• Created data trace map and data quality mapping documents.
• Performed data profiling and data quality in the source systems
• Prepared requirement traceability matrix to verify and validate the requirements.
• Worked and Contributed closely with the testing team in reviewing the Test plans, test cases and test scripts in SIT and UAT phases and in sorting defects in defect triage calls.
• Involved in defect tracking and route the defects to appropriate team to fix the issue.
• Helped the Business team in preparing regression test cases and transition interim solutions for fixing the defects at UAT phase times.

Tools: Erwin r8.2, Oracle SQL Developer, Oracle Data Modeler, SAS, Teradata 14, SSIS, Business Objects, SQL Server 2005/2008,IBM Mainframe,MVS, Python,Py Pandas,UNIX Shell scripting, ER/Studio Windows XP, MS Excel.

Confidential, New York, NY

Senior Data Analyst

Responsibilities:

• Responsible for managing the BI projects involving Application Development, Business, and Enterprise Technology;
• Performed calculations with aggregate functions, dynamic charts and graphics, data sets, connected joins, combined data sources using Tableau
• Created Tableau workbooks, dashboards using stack bars, Pie charts, bar graphs, scatter plots, geographical maps, Gantt charts.
• Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance.
• Read data from Oracle, Excel and flat files into SAS software. Developed SAS code to clean the invalid data from the database.
• Communicate and lead with the business users and the stakeholders /customers in gathering the business requirements;
• Lead the project meetings and brainstorm sessions with business users to fulfill the communication gaps in the functional requirements;
• Facilitated meetings with the business SME’s and the end users to formulate business requirements and translate the client needs into specific system requirements;
• Wrote Business Requirements, analyzed them and tested them;
• Analyzed requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models);
• Developed detailed Functional specification requirement documents (FSD/SRS) and design documents;
• Reviewed the non-functional requirements and system configuration requirements that need to be documented;
• Communicated with Business Analysis team in designing functional mapping specifications;
• Designed and build ETL data mapping logics to source the target data into target data source database.
• Managed functional testing and facilitated meeting quality assurance standards for the core banking product - T24 GLOBUS;
• Reviewed the Test Cases/Test Scripts on Private Banking module covering Securities Administration and Securities Valuation;
• Prepared requirement traceability matrix to verify and validate the requirements;
• Worked closely in Assisting with the team in preparing the test strategy development plan, Test Cases and Test Scripts in SIT and UAT phases and in sorting defects in defect triage calls;
• Used Python and Django to interface with the jQuery UI and manage the storage and deletion of content.
• Involved in defect tracking and route the defects to appropriate team to fix the issue.
• Helped the Stakeholders and the Business UAT team in preparing the Regression test cases and interim solutions for the transition requirements for fixing the defects in production environments.
• Coordinated with the developer, on day-to-day basis, during the development process;
• Tracked the defects in legacy reports as per account managers and end users (Compared the results and tracked the differences in Excel);
• Reviewed SQL Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle);
• Conducted the training sessions in design, documentation and delivery efforts in concert with the delivery leads, to the management staff and the end user team;
• Participated with reporting team in generating different types of reports using Business Objects such as: Dash board reports, KPI reports to analyze Charts/Graphs, Master /Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.

Tools: Erwin r8.2, Oracle SQL Developer, Oracle Data Modeler, SAS, Teradata, Tableau,SSIS, Informatica IDQ, Business Objects, SQL Server 2005/2008,IBM Mainframe,MVS, Python, UNIX, ER/Studio Windows XP, MS Excel.

Confidential, New York, NY

Sr. Data Analyst

Responsibilities:

• Requirement analysis, Data analysis, Requirement Elicitation & Negotiation
• Uploaded cluttered data into SAS Software and exported data into other sources in a more manageable format with SAS SQL
• Worked on data pull and preparation of the customer list using SAS for marketing campaigns - Home Mortgage Non performing
• Developed analytical processes, statistical models and quantitative approaches, leveraging SAS ad hoc and automated reporting capabilities.
• Created SAS scripts and writing SQL queries based on input from analytics/development team.
• Designed and implemented Teradata physical, access, and semantic database layers for use in new Teradata Data Warehouse
• Developed entire frontend and backend modules using Python on Django Web Framework.
• Liaising with clients for the requirements & translate them into functional specifications
• Prepared Functional Specification Document (FSD), Mapping Specification
• Trade Capture & Reporting, Client Reporting, Portfolio performance and Position Management & reporting - Cash, Contract & Security positions
• Credit risk management & credit line facilities for clients & products - Limit & Collateral
• Worked on different risk management models - Dodd Frank, BCBS
• Management Accounting, Client MIS & Business Analytics calculation
• Order Management, Trade Lifecycle Events, Corporate actions & Premium payments
• Reporting of Net New Assets( Confidential ), Asset Under Management(AUM), Net Interest Income (NII), Trade dated & Value dated trade reconciliation
• Reconciliation of different financial instruments like Security Trades, Contracts etc.
• Implementation of Corporate actions, premium payments, securities & cash positions
• Functional Experience in - Market & Reference data of financial instruments (various asset classes), organization data, customer and counterparty reference information, transactional information (Security trade, position, loans and deposit information)

Tools: Erwin 8.0, SQL, SQL Server 2012, Python, UNIX, IBM Mainframe, Teradata, Tableau, SAS, SQL Assistant 12.0/13.11, Data stage 8.1, DB2.

Confidential

Senior System Analyst / Data warehouse Consultant

Responsibilities:

• Participated all reviews and meetings with internal users to gather the Global requirements;
• Analyzing and examining existing SAS procedures and SQL queries/scripts to improve upon.
• Built Fast Load and Fast Export scripts to load data into Teradata and extract data from Teradata.
• Built 5 dashboards on Tableau to show the summarized information as well as the drill down information on how to achieve the saving opportunity
• Developed and designed different SAS programs to analyze financial data.
• Developed Business requirement documents (BRD), Functional specification requirement documents (SRS) and Technical design documents;
• Facilitated meetings with the business SME’s and/or the end users to formulate business functionality and requirements and translate the client needs into the underlying specific system requirements;
• Designed Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies;
• Developed Object Fields, Attributes, Functions, Triggers Using Object Designer;
• Creation of reports like, Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports;
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies;
• Wrote PL/SQL procedures for processing business logic in the database and tuned SQL queries for better performance;
• Generated different types of reports using Business Objects such as: Dash board reports, KPI reports to analyze Charts/Graphs, Master /Detail, Cross Tab and Chart (for trend analysis) with use of filters, conditions, calculations, etc.;
• Used Analyzer to view reports from different prospect (Slice and Dice and Drill down);
• Created Use Cases, Test Plans, and Test Cases;
• Generated web reports using Business Objects Web Intelligence 6.5;
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily;
• Scheduled Daily /weekly/Monthly jobs and send auto emailing internal users for Daily / weekly / Monthly jobs run via auto scheduled jobs.

Tools: CA Erwin 8, Oracle10g, SQL server 2012, IBM DB2, Informatica Power Center 8.6, SQL BI 2008, Oracle BI, Visual Studio, SSIS&SSRS, UNIX,IBM Mainframe, MVS,SAS,Tableau,SQL server management studio 2012.

Confidential

Senior Data Analyst

Responsibilities:

• Conducted meetings and worked with the BU and SME’s to identify the technical requirements for implementation.
• Designed Logical Data Model (LDM), Physical Data Model (PDM) using Platinum Erwin;
• Designed Core Data Warehouse Model by creating Dimensions and Fact tables;
• Designed Data mart model by creating Measures and calculated measures and dimensions and Fact tables;
• Created PL/SQL queries and stored procedures and some VBScripts in DTS;
• Participated in Full Lifecycle Design and Development of Business Objects reporting Applications;
• Installed Business Objects and repository Creation;
• Installed Web Intelligence and Broadcast Agent server;
• Designed Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies;
• Developed Object Fields, Attributes, Functions, Triggers Using Object Designer;
• Created reports such as: Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports;
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies;
• Wrote PL/SQL procedures for processing business logic in the database and tuned SQL queries for better performance;
• Generated different types of reports using Business Objects such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations;
• Used of Analyzer to view reports from different prospect (Slice and Dice and Drill down);
• Generated web reports using Business Objects Web Intelligence 6.5;
• Presented of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily;
• Created Shipment Linearity reports for Daily run via Broadcast Agent Server;
• Elicited and documented the requirements of a Java related web based portal design project;
• Gained understanding of the Java code and JavaScript’s and tested the solution scope of the project compared with end result reporting requirements.

Tools: Platinum Erwin 4.x, SQL Server 2000, DTS, Business Objects Ver. 6.5, (Designer, Business Object, Java, JavaScript, Supervisor, Business miner, Web Intelligence Ver. 6.5.1 Broadcast Agent Server), Windows XP

Confidential

Data Analyst / Data Warehouse Consultant

Responsibilities:

• Participated in OLTP study, reporting requirement study, designing of Logical Data Model (LDM), Physical Data Model (PDM) using Platinum Erwin;
• Created, published and distributed reports, visualizations and dashboards in Tableau, SAS, Google Analytics and Excel to the executive management and various other stakeholders
• Conducted predictive analysis to obtain list of strong voters and recommended the candidate of the results using Tableau and Excel.
• Presented explanatory and predictive analyses using Tableau on a weekly basis.
• Presented analysis by story building in Tableau with interactive dashboards, and suggesting top underrated and promising rookie players.
• Perform ta data quality Analysis checks and verifications at all the stages throughout life cycle
• Convert the business users requirements into System requirements
• Prepared SQL Data mappings, functional System specification documentation and technical design documentations.
• Created reports (using OLAP tool QlikView) such as Drill down Reports, Cross Tab Reports using “Slice and Dice”, Grouped Cross Tab Reports, Free Style Reports, Drill Thru Reports, and Sub Reports for Client, Client Income and Insurer Income.

Tools: Erwin 7.2, SQL Server 2008, SQL Server Reporting Services (SSRS), Unix,IBM Mainframe, MVS,Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Tableau, TOAD.

Confidential

Senior Data warehouse Consultant

Responsibilities:

• Defined and designed an integrated corporate-wide Logical Multidimensional Model (OLTP to ROLAP) to analyze the aggregation level as well as qualification of data and allow users to perform analysis by dimension.
• Created Business Object’s Universe, queries and reports for Customer Service and Sales functions
• Used Oracle stored procedures extensively for data extraction process for loading the data in the data warehouse
• Created the Data Mart tables
• Involved in source data transformation to load the target tables using Transformation developer and mapping designer of Power mart Designer.
• Filtration, involved writing complex PL/SQL procedures for data filtration and extraction

Tools: Windows NT, Oracle9i Business Objects 5.x (Designer, Business Object, Supervisor, Business miner), Informatica Power mart 5.1 (Designer, Repository Manager, Server Manager), Quality Center, TOAD, QTP