SUMMARY

• Professional with 13 Years of Financial Services Experience with focus in Data Analysis, Modeling, Data Mapping, Data Warehousing, Business Intelligence.
• Having 10+ years of experience in Business Intelligence Project lead activities includes Delivery management of multiple projects, including financial and risk analyses. Overall responsibility for customer satisfaction of projects.
• 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 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.
• 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 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
• Expert in BI systems on large databases, proven project management capabilities in enterprise companies, strong requirements and business analysis skills, initiative, leadership, excellent verbal and written communications, cool under pressure, ability to interact with a wide range of different corporate personnel, perception from the highest business objectives down to fine technical details, the ability to see complex projects through to completion, confidence and the drive to go all out to implement the correct solutions
• Data Warehousing Architecture in data modeling, writing functional and design specifications, creating Meta data for the Enterprise, program design, performance tuning and implementing into production. Experience in holding the responsibility for the overall design of the application and mapping the business requirements to systems/technical requirements. Experience in Design Methodology (Relational and Dimensional Modeling) using tools such as Erwin 4.x. Experience includes architecting and developing databases and applications for OLTP, Data Warehouse, n - Tiered, client-server and host-based environments
• ETL development experience - 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.
• OLAP Experience - Developed different Reports such as Cross Tab Reports using “Slice and Dice”, Grouped Cross Tab Reports, Free Style Reports, Drill Thru Reports, and Sub Reports using tools COGNOS, Business objects (5/6.25/X1 Rel2/REl 3 ver), Hyperion 9.1, and QlikView6.7.

TECHNICAL SKILLS:

OLAP: Business Objects 5.1.4 (Designer, Business Object, Supervisor, Business miner, Web Intelligence), Business Objects X1 Rel2 (Desktop Intelligence, Admin, Designer), COGNOS PowerPlay Transformer Cognos Query, Brio 6.1.1 (Brio Query Explorer, Brio Designer, Brio Enterprise Server),QlikView6.7 /11, Hyperion 9 .

Tools: Computer Associate’s ERWIN 3.5.2/4.1, MS Excel, MS Word, MS PowerPoint, VISIO 5.X, JIRA, Quality Centre

ETL: Informatica Power Mart 4.7.1, Power Center 1.7.1/ 7.1 Oracle Discoverer, DTS

Languages: PL/SQL, SQL, C, C++, JAVA, HTML, VB

RDBMS: Oracle 7.0/8.0, 9i, MS Access, MS SQL Server 2000, SQL Server 2005/2008 (SSRS, SSAS, SSIS)

GUI Tools: Oracle Forms 4.5, Repots 2.5

Operating Systems: Windows NT, Windows 3.0/3.1/95/98 , XP Professional

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

AWS Business Data Management 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.
• Developed Business requirement documents (BRD) into detailed Functional specification requirement documents (FSD/SRS) and Technical design documents.
• Reviewed the non-functional requirements and system configuration requirements that needs to be documented
• Translated the Business requirements into technical requirements.
• 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 dimensional lookups and static flat files data from Teradata and postgre tables with python scripting.
• Analysed the target report requirements from the business and created and published the credit wise dashboard, up marketing 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.

Environment: AWS Cloud Redshift database, UltraEdit SQL, S3, SQL Workbench, Teradata 14, postgre, Python,Ruby R, UNIX, Windows XP, MS Excel, Splunk.

Confidential

Senior Business Systems Analyst

Responsibilities:

• Involved in Communicating with business users and stakeholders in gathering the business requirements. Attended brainstorm sessions with business users to fulfill the communication gaps in the functional requirements.
• Facilitated meetings with the business SME’s and the business customers and partners to formulate business strategy and requirements and translate the customer needs /business requirements into the underlying specific system requirements.
• Conducted JAD sessions to elicit requirements to analyze and translate business requirements into system requirements (functional and non-functional) detailed Functional specification requirement documents ((functional and non-functional - FSD, SRS) and Technical design documents.
• Used TortoiseSVN to do versioning and maintaining the metadata repository.
• Uses 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.
• Created data trace map and data quality mapping documents.
• Performed data profiling and data quality in the source systems
• Prepared requirement traceability matrix (RTM) to verify and validate the requirements.
• Worked 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.

Environment: Platinum Erwin 4.x, Sqlserver, Business Objects X1 Rel 3, Windows XP, T24,Tortoise SVN

Confidential

Senior Data warehouse Consultant/ Business Analyst

Responsibilities:

• Involved in Participating all reviews and meetings with internal users to gather the Global requirements.
• 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 strategy and requirements and translate the client needs into the underlying specific system requirements.
• Developed Business requirement documents (BRD) into detailed Functional specification requirement documents (FSD/SRS) and Technical design documents.
• Reviewed the non-functional requirements and system configuration requirements that needs to be documented.
• Worked closely with Solution Architect team to produce technical specifications for custom development and systems integration requirements and to get the sign-off approvals as needed by RRR document.
• Communicate with business Analysis team in designing functional mapping specifications managed functional testing and facilitated meeting quality assurance standards for the core banking product - T24 GLOBUS (Temenos).
• Reviewed the Test cases/Test Scripts on Private Banking module covering Securities Administration and Securities Valuation. Reviewed all aspects of IT testing, documentation, project coordination, and user validation.
• Prepared requirement traceability matrix to verify and validate the requirements.
• Worked 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 solving the complex risk defects in quality Centre that are raised by the business users as part of performance tuning.
• Conducted the sessions in design, documentation and delivery efforts in concert with the delivery leads, to the management staff and the end user team.
• Involved with testing and dev team in creating the CR’s (Change request) and new incident tickets. Also participate as an SME to make and to Influence the decision makers to stick to the correct decisions’.
• 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.

Environment: Platinum Erwin 4.x, ORACLE, Informatica (PowerCentre 11.4), SAP Business Objects X1 Rel 3, Windows XP, Temenos - T24,Clear Quest, Quality Centre (Defect tracker),JIRA

Confidential

Senior Data Warehouse Business Consultant

Responsibilities:

• Involved in Participating all reviews and meetings with internal users to gather the Global requirements.
• 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.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of 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). Use of filters, conditions, calculations, etc.
• Use of Analyzer to view reports from different prospect (Slice and Dice and Drill down).
• Involved in creating Use Cases, Test Plans, and Test Cases.
• Generated web reports using Business Objects Web Intelligence 6.5.
• Presentation of 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.

Environment: ORACLE 9.X, Business Objects 6.5 SP2 (BO Reports/Designer/Admin), Windows XP, ITSM 7, BMC Remedy User

Confidential

Senior System Analyst

Responsibilities:

• 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
• Involved in Full life cycle design and development of Business Objects reporting Applications.
• Installation of Business Objects and repository Creation.
• Installation of 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
• 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.
• Tuning of 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, etc.
• Use of Analyzer to view reports from different prospect (Slice and Dice and Drill down).
• Generated web reports using Business Objects Web Intelligence 6.5.
• Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily
• Creation of Shipment Linearity reports for Daily run via Broadcast Agent Server.

Environment: Platinum Erwin 4.x, SQL Server 2000, DTS, Business Objects Ver. 6.5, (Designer, Business Object, Supervisor, Business miner, WebIntelligence Ver. 6.5.1 Broadcast Agent Server), Windows XP

Confidential

Data Warehouse Consultant

Responsibilities:

• Involved in OLTP study, reporting requirement study, designing of Logical Data Model (LDM), Physical Data Model (PDM) using Platinum Erwin.
• Creating 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.

Environment: Platinum Erwin 4.x, QlikView 6.7, Oracle9i, and Windows NT

Confidential

DATA MART - Architect

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

Environment: Windows NT, Oracle9i Business Objects 5.x (Designer, Business Object, Supervisor, Business miner), Informatica Power mart 5.1 (Designer, Repository Manager, Server Manager)

Confidential

DATA MART - Architect

Responsibilities:

• Involved in OLTP study, Involved in users meetings, reporting requirement study, designing of Logical Data Model (LDM), Physical Data Model (PDM)
• Implemented Data Demoralizations, Data Separation, Entity Integrity Rules and Referential Integrity Rules in the data model as a part of the project requirement.
• Used Visio 5.X as a modeling tool.
• Designed Staging Models Tables from different Sources (VISTA, PANS, SILAS etc.,),
• Designed Enrichment Area Model by creating Lkp tables and Flat files, some kind of spread sheet Tables.
• 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
• Created reports using OLAP (PSYBER SCOPE VOYAGER)