PROFESSIONAL SUMMARY:

• A Data Warehouse consultant with over 7 years of experience in Data warehouse Design, methodologies Extraction, Transformation and Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation
• Exposed to diverse business processes, that includes Insurance, Banking, E - business, Research Groups, Credit card services and Service Industry sector.
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Mining, Data Analysis, Decision Support System (DSS) and GUI applications
• Proficiency in Data Modeling using ERwin Tool for creating Logical and Physical Data Model and used Model Mart as the library.
• Sound knowledge of Oracle TCA (Trading Community Architecture) Tested Oracle configurations as part of CRs (Change Request) E2E SIT.
• Expertise in creating Data Marts and Data warehouse using Star flake and Snowflake schema models in implementing decision support systems
• Exposure to OLAP, OLTP, data warehouse development, system analysis, design, development, maintenance and implementation
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Excellent project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, Gap Analysis, Risk Analysis, Effort Estimation etc.
• Proficient in Rational tools including Rational Rose, and Requisite Pro. Excellent skills in Business Analysis, Data Analysis, Data Mapping, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Involved in Oracle System Administration functions such as registering users, attaching responsibilities, creating additional users, defining.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Thorough knowledge of Software Development Life Cycle (SDLC), having understanding of various phases like Requirement gathering, Analysis/Design, Development and Testing knowledge of Rational Unified Process (RUP).
• Adept in streamlining Business processes by recognizing and avoiding bottlenecks, thereby reducing Cycle time and improving system efficiency and employee productivity.
• Extensive experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
• Excellent system, process and quality validation skills.
• Excellent business communications skills in writing System Requirements document, Systems Design Specification and System Requirement Change Request.
• Excellent documentation skills in creating BRD and translating it into detailed Functional Specifications Document and Data Models.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.

TECHNICAL SKILLS:

• Business Objects
• Informatica Power mart 4.7/6.1/6.2/7.2
• Power center 1.7/6.2/7.2/8.1
• Oracle designer 10.1
• Microsoft Visio 2000
• UML
• Rational Rose
• VB
• C
• C++
• Java
• HTML
• DHTML
• Oracle 11g/10g/9i
• SQL
• Microsoft Office Suite
• MS Project
• Windows
• UNIX
• Linux
• DOS
• Windows 2003 Server

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr. Data Analyst/ QA Tester

Responsibilities:

• Involved in writing BRD’s and TDD for the services and supporting the module till post production.
• Support Wealth Management Portfolio Managers, Wealth Management Advisors, Trust Officers, and Banking officers, as needed, within the Private Client Reserve.
• Validated Prompts, filters, calendars and Cosmetics in reports. Participated in Project Status meetings and updated QA status and defect status.
• Developed the test strategy for ensuring QA of Pinnacle points advance reporting
• Conducted a detailed Gap Analysis to provide Impact Assessment on various departments across the enterprise for UIL upgrade projects.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Attended the change data management control board meetings for accommodating the enhancements to the warehouse based on the source systems upgrade.
• Tested the field mapping and transformation rules for a Wachovia-to-Wells data migration
• Analyzed the existing structures, ETL, database objects, Server infrastructure for the EDW and Data mart and then created system stabilization tasks to improve the data quality, avoid ETL failures and improve performance.
• Worked on issues with migration from development to testing.
• Create SQL, Python scripts for retrieving and transforming the data to be consumed in a statistical analysis or in Tableau.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Extensively worked on Distributed sales, Account Receivables, Order to Cash, Planning, Inventory and Purchasing modules in Oracle EBS
• Tracked QA process, reported defects and status of the defects in Mercury Quality center.
• Coordinate monthly meetings to review all Capital Markets litigation, arbitration, inquiries, and other regulatory matters with the broader Legal/Compliance and Risk groups to ensure transparency in how regulators view our business and opportunity to remediate risks identified by all regulators.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making
• Created Data mapping documents, logical data models, class diagrams and ERP diagrams and extensively used SQL queries to filter data within the Oracle database
• Heavily involved with all the phases of QA validation process.
• Defined QA procedures to plan, design, execute, evaluate and report results of software testing under minimal or no supervision.
• Tested data migration to ensure that integrity of data was not compromised.
• Worked with QA team members and application developers; quickly capture the major business functions and technology to design and implement tests of system functionality that exercise all critical intersystem integration points.
• Worked on Software change Requests (SCR’s) for issues in production for dual factor authentication. Coordinated with RSA (security division of EMC) to get the matter resolved.
• Wrote test scripts for validating the data using Advanced Query Tool.
• Created staging and Dimensional data models in ERwin based on the requirements and adhere to enterprise data warehouse standards.
• Involved in data validation, quality check and User Acceptance Testing
• Updated the SharePoint sites to have documents on service levels and project levels.
• Analyzed trends and key performance indicators for the capital markets, individual securities, and GICS industries

Environment: Windows NT Server, Oracle 11g, IBM Campaign, Business Objects, PL/SQL, Microsoft Word/PowerPoint/Access, RUP, SharePoint, UML, Crystal Reports 10.0, JIRA, Requisite Pro, SQL

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

• Organized and participated as a lead in Joint application Development sessions for developing the application and created user requirements document for corporate wide reports by communicating with end users and developers.
• Junior member of sector-agnostic investment-grade debt capital markets investment banking team.
• Perform cross functional business analysis from compiling data from multiple database sources and developing medium to complex reports/analysis
• Provided detailed analysis of data issue, mapping data from source to target, design and data cleansing on Data Warehouse
• Analyzed the extracts coming from different sources to identify the new data elements, map them to the physical elements and update them in the metadata repository.
• Supported capital markets team through equity research and fundamental analysis of publicly traded equity and fixed income securities.
• Primarily involved in E2E tests including Oracle OM, Invoicing, Account Receivables, Floor Planning and Settlement in an agile
• Created Business and Data Specification documents for the above process
• Developed logical/ physical data models in Erwin across different subject areas based on the specifications and established referential integrity of the system
• Assisted in creating E-R diagrams on the Data Warehouse
• Based on the physical model, developed strategies for Extraction, Transformation and Loading (ETL) the data into the data warehouse and document the same
• Worked as a team in conducting Gap Analysis and create requirements traceability matrix to identify data anomalies and determined the cause/scope for these anomalies and suggested options for conversion and cleanup of data.
• An ambitious and detail oriented financial associate. Solid knowledge of capital markets and financial products with exceptional analytical and data mining skills.
• Utilize sophisticated financial principles and econometric formulas to provide analytical support to capital market team.
• Thorough knowledge of various Oracle tools like OEM with management pack, RMAN, SQL Loader, TKPROF, Stats pack, AWR, ASH, ADDM TOAD, SQL trace to perform day to day job.
• Manage the Capital Markets’ internal audit process and oversee the implementation of resolution plans based on audit findings.
• Tasks included analyzing of requirements using Rational Requisite Pro
• Lead the Group subject area among the data warehouse users to understand the data and develop reporting requirements.
• Supported transactions done on the Global Capital Markets trading desk in structured underwriting and trading collateralized securities on the primary markets such as Investment Grade, Emerging Markets, Preferred Stock and High Yield bonds.
• Developed and generated PL/SQL and SQL queries for ETL processing, reporting and data analysis
• Generated the mapping and workflow specifications using Crystal reports as a part of the post-code technical transformation documents
• Involved understanding the current business process, defining scope of the project along with position statement using Rational Unified Process.
• Collaborated with Quality Assurance Analyst and wrote complex SQL queries to validate the data
• Created test plans, scripts and facilitated user acceptance testing.

Environment: Windows XP/NT, UNIX, Oracle 9i, PL/SQL, HTML, JavaScript, MS Office, MS Visio, MS Project, Crystal Reports 9.0, MS Access

Confidential, San Antonio, Tx

Business/ Data Analyst

Responsibilities:

• Create and maintain documentation as it relates to system configuration, mapping, processes and service records.
• Statistical model developing and validating based on the organization’s business optimization goal
• Worked on gap analysis for enhancements to the homeowner’s insurance process.
• Performed schedule daily, weekly and monthly maintenance.
• Documented elaborate test scripts covering all the requirements.
• Development of SharePoint web parts, web service and class creation for interaction with windows SharePoint services, and general SharePoint site layout template creation.
• Creation of validation documents and involvement with the Quality team for all QA validation activities
• Worked on writing business rules for crystal reporting for homeowner’s insurance department.
• Accumulated customer requirements from various end through surveys, interviews and JAD sessions and translated them into system requirements.
• Used Rational Rose to carry out the business modeling, data modeling, and object modeling efforts to develop the business architecture for rapid and controlled application development
• Prepared Logical Process and Data Models that contained a set of ER diagrams and class diagrams to support documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document Business Data Requirements
• Worked on trackwise system to manage various quality management phases
• Facilitated user acceptance testing and test strategies with developers and testers
• Developed Data Flow, Workflow, Process Flow, and Entity Relationship Diagrams in Visio
• Worked as an Interface between the end users and the different teams (Production Development Team, Testing Team, System Architect Team) involved in the application development for the better understanding of the business and IT processes
• Created Use Case, Activity, Sequence, and Collaboration Diagrams
• Performed Defect Tracking and Change Control Procedures using Rational Clear Quest, and Configuration Management and Version Control using Rational Clear Case
• Involved in the peek review of Test Plans, Test Cases with the QA team to verify implementation of new features and enhancements

Environment: JSP, Oracle, HTML, XML, Rational Rose, SharePoint, MS Visio, RUP, MS Project, SQL Server 2000, MS Access, MS Excel and MS Word, Trackwise, WSS 2.0, XML, QTP 8.2, VBScript, Test Director 8.0, WinRunner, Windows, Crystal Reports 9.0

Confidential

Data Analyst

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs
• Created Technical design specification documents for transform and load from IHCIS ImpactPro to identify stratified individuals for production load based on the functional specifications
• Managed the project requirements, documents and use cases by IBM Rational RequisitePro
• Analyzed the present data warehouse logical model and developed strategies for E xtraction, T ransformation and L oading (ETL) the data into the data warehouse
• Worked with Technical and reporting team to develop ETL jobs as per the technical specification documents
• Based on the current data warehouse structure created Server jobs using Data Stage designer to transfer the data from the Galaxy Database to Analytic Data Warehouse (ADW)
• Created jobs in Data Stage to load the data into ADW as per the requirements from technical design document
• Designed and Developed pre-code and post-code technical transformation documents for the Group subject area tables that has to be coded
• Created mappings, sessions and workflows in Informatica applying the business logic and finally loaded the date to the DB2 data warehouse from oracle and Teradata databases
• Configured and scheduled Pre and Post Session commands with Shell Scripts and Perl Scripts
• Worked on stored Procedures for generating the data warehouse cycle dates and for the DB2 configuration files
• Responsible for Design creation of symmetry table load files, build the jobs in DataStage and unit test the jobs
• Wrote scripts to execute the ImpactPro processing engine, Symmetry engines to load the data into ImpactPro data mart and published the data on the web server through ImpactPro reporting engine
• Designed box jobs for ImpactPro data mart, scheduled them in Autosys and migrated the jobs to the production server

Environment: Data Stage7.5.1, Oracle 9i, UDB 8.1.5/7.2.2, DB2 7.1, UNIX (Sun Solaris 5.8 /AIX), Windows, XP Professional, IBM Requisite Pro, Autosys4.1, UltraEdit-32, F-Secure SSH Client 5.4, RCS, FTP, MS Visio 2002.