SUMMARY:

• 8+ years of Database Analyst of experience on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD.
• Worked on various Domains like Banking, Financial, Health Care and Telecommunications.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Worked with heterogeneous relational databases such as Teradata Oracle, MS Access and SQL Server.
• Experience in working third party tools like WinSQL, TOAD and SQL Developer.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• Experience in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Well versed with Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\ SQL Scripts
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center, Data stage, Mainframes SAS, SSAS, SSIS, OLTP, OLAP, Business Objects.
• Experience with Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Experience with Relational Databases like Oracle 10g/9i/8i, DB2 ESE, MS SQL Server 2005/2010, DTS, Sybase, Teradata V2R5, MS Access and formats like flat-files, CSV files, COBOL files and XML files
• Good command in modeling using case tools like ERwin, Oracle Designer, Power Designer & E-R/Studio.
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
• Experienced in handling concurrent projects and providing expected results in the given timeline.
• Excellent communication, documentation and presentation skills with clear understanding of business process flow.

TECHNICAL SKILLS:

Database Systems: Oracle 11g, 10i 9i/8i, SQL Server 2008/2005/2000, IBM DB2, Teradata 12, Sybase ASE 12, MS Access 2007.

Data Modeling Tools: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Erwin r7.2/3/4, Visio, Sybase Power Designer.

Reporting: Crystal Reports and SQL Server 2000/2005 reporting services

ETL Tools: Informatica 9.0/8.1/7.x/6.x/5. x., Data Stage, SSIS, SSAS

Database Development: T-SQL and PL/SQL

Office Applications: MS Office (Word, Excel, Visio, PowerPoint, Project)

Web Development: HTML, XML and FrontPage, Visual Basic 6.0

Operating Systems: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3, Sun Solaris7

Programming Languages: C#, Visual Basic.NET and C++, VB 6.0

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, California

Sr Data Analyst

Responsibilities:

• Processed large Excel source data feeds for Global Function Allocations and loaded the CSV files into Oracle Database with SQL Loader utility.
• Performed code Inspection and moved the code into Production Release.
• Documented all the Relative activities in Quality Centre and coordinated with QA team.
• Developed the best practices and standards for Data Governance Processes.
• Performed Data filtering, Dissemination activities, trouble shooting of database activities, diagnosed the bugs and logged them in version control tool.
• Performed source data analysis and captured metadata, reviewed results with business. Corrected data anomalies as per business recommendation.
• Created source to target mappings for multiple source from SQL server to oracle. This was used by ETL developers.
• Performed the batch processing of data, designed the sql scripts, control files, batch file for data loading.
• Performed the Data Accuracy, Data Analysis, Data Quality checks before and after loading the data.
• Coordinated with the Business Analyst Team for requirement gathering and Allocation process
• Methodology, designed the filters for processing the Data.
• Designed and developed the Database objects (Tables, Materialized Views, Stored procedures, Indexes),
• SQL statements for executing the Allocation Methodology and creating the OP table, CSV, Text files for business.
• Performed the physical database design, normalised the tables, worked with Denormalised tables to load the data into fact tables of Data warehouse.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
• Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into base tables.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for Data Accuracy, Data Analysis and Data Extraction needs.
• Designed star schema with dimensional modeling, created fact tables and dimensional tables.
• Involved in data analysis, data discrepancy reduction in the source and target schemas.
• Designed and developed the star schema Data model, Fact Tables to load the Data into Data Warehouse.
• Implemented one-many, many-many Entity relationships in the data modelling of Data warehouse.
• Developed the E-R Diagrams for the logical Database Model, created the physical Data Model with Erwin data modeler.
• Analyzed the tables once the imports were done.
• Edited the Database SQL files with Vi Editor, used Unix Commands like Cron, Job scheduling, Executing files, Process, Background, Grep etc.,).
• Written PERL Scripts to extract the data from Oracle Database, checking the database connections, regular expressions etc.,
• Developed the VBA Integration with Excel feeds and SQL database, SQL Extraction, Transformations Excel Data into SQL database.
• Involved in writing Oracle PL/SQL procedures, functions, Korn Shell scripts that were used for staging transformation and loading of the data into base tables.
• Involved in debugging and trouble-shooting of database objects.
• Involved in Data loading and data migration - Used SQL * Loader to load data from excel file into staging table, Data Cubes and developed PL/SQL procedures to load data from staging table into base tables of Data warehouse.
• TOAD, SQL Developer tools were used to develop programs for executing the queries.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in the monitoring of database performance in Enterprise Manager Console.
• Created the XML control files to upload the data into Data warehousing system.

Environment: Struts Framework 1.1, JSP 1.2, Servlet 2.3, XML, Oracle 11g, Data Warehouse, OLAP, SQL Navigator, SQL Developer, Erwin 4.0, XML, OLTP, 9.6.1 Informatica Power Center, MS-Excel 2000, MS-office 2000, Microsoft XP Professional.

Sr Data Analyst

Responsibilities:

• Designed & Created Test Cases based on the Business requirements.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed separate test cases for ETL process and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file
• Creation Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyzes and compares results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Prepares and submit the summarized audit reports and taking corrective actions
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and Schedule
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting

Data Analyst

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Participated in analyzing and modeling the requirements for the logical and physical design of the database using star schema and normalization techniques.
• Involved in Data Mining, Profiling and Data Modelling.
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Built re-usable mapplets using Informatic Designer.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Developed and modified mappings for Extraction, Staging, Slowly Changing Dimensions of Type1, Type2, Type3, Facts and Summary tables duly incorporating the changes to address the performance issues as stated in the Re-architecture specifications.
• Developed mappings for Slowly Changing Dimensions of Type1, Type2, Facts and Summary tables using all kinds of transformations.
• Worked on Informatica Power Center 7.1.1 - Source Analyzer, warehouse designer, Mapping Designer,
• Workflow Manager, Mapplets, and Reusable Transformations.
• Written PL/SQL Stored Procedures and Functions for Stored Procedure Transformation in Informatica.
• Define and represent Entities, Attributes and Joins between the entities.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Written UNIX shell scripts to automate loading files into database using crontab.
• Developing batch files to automate or schedule tasks.
• Support for the development, pre-production and the production databases.

Environment: Agile, Oracle10g (SQL, PL/SQL), SQL*Loader, Forms 10g, TOAD 7.4, HTML/DHTML, PRO*C, JavaScript, Windows NT/2000, Crystal Report 10, Informatica Power Center 7.1.3, Erwin 4.0, UNIX.

Data Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• External interactions with NSCC, DTCC, NFS and various fund companies in which MMLISI is associated.
• Involved in Data mapping specifications to create and execute detailed system test plans.
• The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested several stored procedures.
• Validated several Business Objects reports. Reviewed and tested business requests for data and data usage.
• Tested the ETL process for both before data validation and after data validation process.
• Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles.
• Tested whether the reports developed in Business Objects are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.1/7.1, Informix, DB2, Java, Business Objects, SQL, SQL Server 2000/2005, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant 7.0, Toad, XML, XSLT, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Rumba UNIX Display, Quality Center 8.2.

Data Analyst

Responsibilities:

• Analyzing the results and Documenting the process and preparing Data Mapping Document and analyze incoming feeds, conduct data profiling and map the relevant fields to the target repository incorporating business validation rules to integrate the data.
• Identified Use cases from the requirements and wrote Use Case Specifications
• Created business process workflow diagrams (Activity diagrams)
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Create Mapping documents, ETL technical specifications and various documents related to data migration
• Writing complex SQL Queries to test the Informatica ETL process.
• Developed PL/SQL programs, stored procedures for data loading and data validations.
• Involved in Testing Argus safety system 5.0/5.1.
• Developed Oracle and Teradata queries to replace current data ware house reports
• Involved in testing Cognos Custom reports and Out of the box reports using Argus Insight 5.0/5.1.
• Developed complex SQL Queries to validate the data in the Cognos Custom reports against Safety Database.
• Coordinated with the offshore team in the testing process of the SDA (Signal Detection and Alerts) & CBS ( Corporate Business Support) Cognos custom reports.
• Performed end to end ETL testing of Custom Tables which were developed for Cognos Custom reports.
• Coordinated the testing process for Out of the Box reports (Argus Insight reports).
• Coordinated the testing process for various periodic reports like (CTPR, NDA, IND, and PSUR).
• Developed complex SQL’s to validate the data in periodic reports as a part of Aggregate Testing
• Involved in Regression testing of Argus Safety(Periodic) and Insight reports (Cognos Custom and Out of the box) to verify if the Hot fix defects have been fixed in the system (Hot fix1 and Hot fix2 Testing)
• Assist in the configuration of products, licenses and studies in Argus Safety.
• Test various Biztalk interfaces developed for the automation of product, license and study configurations.
• Familiar with EDC, eCRF, E2B and other data exchanges
• Validate the systems as per GxP and SOX compliance requirements. Provide support for post-production issues, fix the issues, test the issues.

Environment: Oracle 11g, PL/SQL, SQL Loader, SQL Reports, Teradata, DB2, Cognos 8 BI, MS Office, MS Visio, MS Word, MS PowerPoint, MS Excel, ERWIN, EDM Teams, EDM Quality, Argus Safety, Argus Insight.