SUMMARY

• 9+ years of industry experience in Data Analysis, Data Modeling, process flow and quality assurance skills.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes ofdataand smooth structural flow of the data.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction,Data Transformation and Data Loading (ETL).
• Extensive experience in testing and implanting Extraction, Transformation and Loading ofdatafrom multiple sources intoData warehouse using Informatica.
• Good command over Logical and Physical entity relationship data modeling using Erwin, Oracle Designer and Power Designer.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule - based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Extensively worked on Dimensional modeling,Data cleansing andData Staging of operational sources using ETL processes.
• Experience inDataTransformation, Data Loading, Modeling and Performance Tuning.
• Strong in database design, domain modelling and ER diagrams design
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a OperationalData Store to a Enterprise Data Warehouse Strong knowledge of all phases in Software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
• Highly motivated and a self starter with excellent communication and interpersonal skills
• Strong analytical and problem solving skills, capable of addressing relevant facts and recommending solutions.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financialdata and other SAS application fordata updates,data cleansing, and reporting
• Design and review of various documents including the Software Requirement specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Used Team Site Content Management Tool to deploy and manage the content managed files.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center/Power Mart 8.x/7.x/6.x/5.x, Power Connect, Oracle Warehouse Builder, Microsoft DTS, Informatica Power Exchange, DAC (Datawarehouse Application Console)

Analysis/Reporting Tools: Business Objects, OBIEE, Oracle BI Discoverer, Cognos, Microsoft Analysis Services, MS SQL server 7.0 OLAP services, Oracle OLAP, Oracle Reports, and Informatica Power Analyzer

Databases: Oracle 10g/9i, MS SQL Server 7.0/2000, DB2, Teradata, Sybase, MS Access

DataModeling: Erwin, Visio, Rational RoseDataModeler, IBMDataArchitect

DB Tools: SQL*Plus, SQL* Loader, TOAD

Requirement Management: Rational Requisite Pro, DOORS, RUP, SDLC, Agile Modeling, XP

Change Management: Rational ClearQuest

Repository Management: Rational ClearCase, Share Point, Harvest

Design: Entity-Relationships,DataFlow Diagrams

Environment: Sun Solaris, UNIX, IBM-AIX, WINDOWS XP/NT/ 2000/98/95, Mainframe.

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, UNIX, Shell Scripting, Visual basic, ASP, JSP, XML, Macromedia Software.

Scripting Languages: Java Script, VB Script and UNIX Shell Scripting

Standards: Datamodeling Standards, IBM IAA (Insurance Application Architecture), IFRS (International Financial Reporting Standards)

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. Data Analyst

Responsibilities:

• Worked alongside Users/SMEs (Subject Matter Experts) to recommend and gather low-level business processes andconvert them into technical requirements for the development team, at various stages of the SDLC (System Development Life Cycle).
• Used SAS ODS to create output files in different formats including PDF and RTF
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Used Reverse Engineering to createdatamodels of existing databases.
• Analyzed Business Requirementsand segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining theDataProcess Models.
• Worked on Performance, Tuning and loadingdatafor fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData,DataProfiling.
• In charge of comprehensiveDataQuality by making sure invalid, inconsistent or missing Obligor Risk Ratings are reported to portfolio managers for remediation and ensure that checks are in place to prevent the issue from re-occurring.
• Created/Revieweddataflow diagram to illustrate wheredataoriginates and howdataflows within the EnterpriseDatawarehouse (EDW).
• Involved inDatamapping specifications to create and execute detailed system test plans. Thedatamapping specifies what data will be extracted from an internaldatawarehouse, transformed and sent to an external entity.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate thedatabetween EnterpriseDataWarehousing andDataMart Staging Tables.
• Developing severalcomplex mappings in Informatica a variety of Power Center transformations, Mapping Parameters.
• Facilitated transition of logicaldatamodels into the physical database design and recommended technical approaches for gooddatamanagement practices.
• Extraction of testdatafrom tables and loading ofdatainto SQL tables.
• Validated the testdatain DB2 tables on Mainframes and on Teradata using SQL queries.
• Transformed projectdatarequirements into projectdatamodels.
• Wrote Test cases for EnterpriseDataWarehousing (EDW) Tables andDataMart Staging Tables.
• Created customized reports in Charles River such as commission analysis report, boxed position report, take-over report, and compliance report etc. using Crystal Reports, Excel VBA and SQL.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts, and activities.
• Implemented RUP and followed iterative approach followed Use Case driven process for requirement documentation and deployment.
• Produced functional decomposition and logical models into an enterprisedatamodel.
• Conductdatamapping sessions, and write the required business requirements documentation including use cases.
• Collected business requirements to set rules for properdatatransfer fromDataSource toDataTarget inDataMapping.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Environment: VC++, SQL, Microsoft NT, VBA MACROS, Clear Quest, Clear Case, Teradata, Rational RequisitePro, Rational Rose, and UML, Test Director, SAS.

Confidential, New York, NY

Sr. Data Analyst

Responsibilities:

• Developed systems for automated import processes of user lists for user account security.
• Created and maintained automatic processes for identifying terminated and transferred users for application access removalto comply with the Sarbanes-Oxley act.
• Designs and coordinates the development of new or special reports while utilizing knowledge of SQL, SAS and/or Data flux.
• Implementation of Data Flux focusing on rules development and reporting, implementation, and support.
• Creates new or enhanced components of the data warehouse. Undertakes the most complex data warehouse issues/projects involving high risk to the organization or that have an impact to multiple business units/entities.
• Works with the metadata development team to design and integrate changes to the Meta model to support data governance initiatives.
• Develop and document high level Conceptual Data Process Design for review by Clinical Analysts, and Quality Assurance analysts that will serve as a basis for writing ETL code and designing test plans.
• Established definitions, data dictionary, standards, and naming conventions for enterprise housing data to ensure ongoing integrity, accuracy, and internal consistency of housing data.
• Extensive user and technical documentation for processes.
• Implemented quarterly tracking of manager certifications of user security levelsutilizing automated VBA processes within MS Exceltoprovide managers with forms andone-click reply through integration with MS Outlook.
• Cleaned up and updated heritage databases.
• Experience in development of data integration solutions using leading ETL products.

Environment: Utilized Microsoft Access 2007, VBA, SQL, Sybase, and a wide variety of JPMC proprietary software tools.

Confidential, San Diego

Data Analyst

Responsibilities:

• Experience in identifying and documenting business rules and creating detailed Use Case. Conduct User Acceptance Testing (UAT).
• Developed UML diagrams such as activity and other flows to document and present to business users using MS Visio.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams,datamodels, and use-case realizations using RUP tools in Agile
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Worked on profiling thedatafor understanding thedataand ETL specification document.
• Involved in the performance tuning of the DataStage Jobs and SQL queries.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Understanding the specifications forDataWarehouse ETL Processes and interacting with thedataanalysts and the end users for informational requirements
• Involved in extensiveDATAvalidation using SQL queries and back-end testing
• Provided Business Requirement Documentation (BRD) for the customers after thorough market and technology research and by analyzing current market trends.
• Used various Informatica transformations to recreate data in thedatawarehouse
• Conduct analyses and queries in Excel, SPSS, and SQL and used SSIS and SQLdataimport tool to loaddatafrom flat file source to database.
• Collaborated with business and technical teams to reengineer and translate the current trading process into new requirements that encompassed an improved solution. This included defining a new trading flow,datamapping,datamessages, exception handling, gaps and impacts.
• Gathered requirements, organized team meetings requirements from business users, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Identified the objects and relationships between the objects to develop a logical model in ERWin tool and later translated the model into physical model using Forward Engineering technique in ER Win tool.
• Configuring privileges and different level of access for different SAS users.
• Conducted interviews with key business users to collect requirement and business process information.
• Facilitated JAD sessions and conducted peer review meetings periodically to keep track of projects milestones.

Confidential, NYC

Data Analyst

Responsibilities:

• Managed the Metadata associated with the ETL processes used to populate theDataWarehouse.
• Assisted in generating ETL packages with differentdatasources and loaded thedatainto target tables by performing different kinds of transformations using SSIS.
• Employed SQL queries for back end testing anddatavalidations
• Acted as Member of the reporting project team for analyzing and designing a system that would improve reporting ofcustomers data.
• Assisted in walkthroughs/sessions (JRDs/JADs) with business stakeholders andSMEs as well as development teams to gather system requirements. Worked with businessanalysts to develop and finalize test plans.
• Analyzed key business requirements and assisted in the development of Business Requirement (BRS), Functional Requirement (FRS), and System Requirement Specification (SRS).
• Documented specifications for transformation of olddatafrom various sources like flat files, MS Access, and Excel into SQL Server using SSIS Packages.
• Documented specifications for variousdatatransformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.

Environment: SSIS, SSRS, UML, MS Access, MS Office, MS Visio, SQL Server 2005.