SUMMARY

• Over 11+ years of IT experience in the field of Business & Data analysis, ETL Development, ETL Testing and Data Modeling.
• Strong experience in Business and Data Analysis, Data Profiling, Data Mining, Data Migration, Data Integration, Data architecture and Metadata Management Services and Configuration Management
• Over 3 years of experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Sybase Power Designer.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities. Good experience in Healthcare domain skills.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
• Worked on different platforms such as Windows and UNIX.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side
• Experience in creating functional/technical specifications, data design documents based on the requirements
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Data Modeling: Erwin 4.0, Power Designer, Microsoft Visio 2003, ER Studio

Etl Tools: Ethority, Informatica Power Center, SQL * Loader, Data Stage, Informatica Data Quality, SSIS

Data Modeling: Erwin 4.0, Power Designer, Microsoft Visio 2003, ER Studio

Databases: Oracle 9i, 10g,11g, MS SQL Server, MS Access, Teradata

Operating Systems: Windows, UNIX

Programming Languages: SQL, PL/SQL, T-SQL

Reporting/Dss/Analysis: SAPBusiness Objects, COGNOS 7.0, Tableau, Qlikview,Microstrategy, SSRS and Crystal Reports.

Testing Tools: HP-ALM

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Analyzed business requirements into detailed, production-level technical specifications, detailing new features and enhancements to existing business functionality.
• Executed data modeling using ERStudio data modeling tool.
• Created the data models for OLTP and analytical systems.
• Engaged in data profiling to integrate data from different sources.
• Performed the analysis to improve the performance to meet the performance metrics.
• Assisted DBAs on support needs and provided guidance on architectural issues.
• Worked with Development teams with loading and extracting data (ETL).
• Facilitated QA for developing test plans and test cases for unit, system and Enterprise testing.
• Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.
• Modeled new data models based on user requirements and updating existing data model.
• Discussed with business clients on providing tactical solutions and designing logical data models accordingly. Worked with clients to generate use case scenarios based on user requirements.
• Verified if the data model helps in retrieving the required data by creating data access paths in the data model.

Environment: ER Studio, Teradata, MS-Excel, STAR Team Migration Request generation tool.

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Performed Database testing and the Report level testing as per the requirement with excellent knowledge in understanding the data workflow by referring through FSD’s(Functional Specification Document).
• Excellent understanding of mapping between Source and Target by referring the mapping document.
• Performed end to end mapping testing for database as well as reports. The type of mapping involved is one to one and its lift and shift process, that means need to check whether the data gathered in target table is mapped properly to the Source table and the same target table is populating the same records into the report tool(SAP-BO, Qlikview) properly.
• Performed Smoke test to do the primary checks like record counts, Column matching for database and Dashboard testing.
• Performed testing at SIT(System Integration Testing) level and UAT(User Acceptance testing) level.
• Gathered requirements from the development team and database developers to analyze the tables and entity relationships for understanding the database.
• Designed the integration document/xls. Derive input and output of each of the integration points.
• Documented the acceptance criteria for each of the test cases. Built the test cases based on test scenarios.
• Created test plan and strategy for the given LOB(Line of Business).
• Verified of import/export and obfuscation data.
• Verified of known issues, development of work arounds and wrappers as required.
• Identified data scenarios and business cases. Created test case development.
• Scripted and automated test cases. Identified source data pattern and reports.
• Developed scripts for comparison with target. Planed and run the SIT(System Integration Testing) for the given LOB.
• Developed test cases, established traceability between requirements and test cases.
• Performed data analysis to determine the completeness and accuracy of the data or checked if new data needs to be pulled up/ requested.
• Executed test cases & log results, performed data validation testing as appropriate, tracked defects and participated in defect resolution.
• Provided inputs to the test lead for documentation and reporting purposes. Identified, documented and updated testing dependencies and participants.
• Identified primary point of contact to raise the risks/issues around testing dependencies.
• Reported status on test execution including risks/issues and targets. Updated latest information in regular testing status meetings with all involved constituencies to ensure smooth test execution and timely issue resolution.

Environment: Informatica Power Center, HP-ALM, Sharepoint, MS-Visio, MS-Excel, Teradata SQL Assistant, Qlikview, SAP-BO,Oracle 11g, Microsoft SQL Server.

Confidential, Alpharetta, GA

Data Analyst

Responsibilities:

• Expertise in configuring the instance in eThority tool as per the Configuration Acceptance document approved by Business Analyst and Activation Manager. Experience in Configuring the CORE/IRS Instance that involves data files with single feed and multiple feeds, single control group or multiple control group, at the same time preparing Instance Verification document for all the CORE/IRS instances that has different version of Specification files created by Business Analyst as per the Client requirement for every individual instances in order to check the eligibility of the employee for the 1095C form.
• Experience in modifying the instance and purging (i.e. Clearing the data from the database) the data from the data warehouse as required by the client to get the clean validation pass for the files.
• Ability to analyze the data by performing Extraction, Transformation & Load function mentioned by clients to process and get the accurate feedback that includes cause for warnings & failures. Ability to explain the cause for the loss of records when the data moves from import table to Transformation table.
• Ability to analyze the problems occurring with the clients data by verifying the contents of the file from the data warehouse in order to provide the accurate feedback by providing the exact cause of the problem along with its fix. Ability to analyze data in the database SQL Server by running SQL queries & troubleshoot the issues related to the clients data. Worked and created a PPACA Document as per the client requirement.
• Good experience in Data mining with regards to collecting, searching through, and analyzing a large amount of data in a database, as to discover patterns or relationships. Good experience in transforming EMR(Electronic Medical Record) to Database.
• Experience in performing the SME (Subject Matter Expert) review done by Business Analyst & Activation Manager by thoroughly verifying list of questionnaire & updating the same and inform Business Analyst and Activation Manager about the necessary actions to be taken to resolve the issue.
• Experience in performing Regression testing i.e. finding the loopholes or bug in the tool by building up the test data as per the test cases which is then sent to development team to develop a software patch for that, in order to fix the issue. Experience working with large amounts of data: facts, figures, and number crunching. Ability to see through the data and analyze it to find conclusions. Experience in working as Quality Analyst by reviewing the task done by QA ETL Tester. Experience in mentoring the new joinees about the project and training them.
• Ability to present findings, or translate the data into an understandable document. Expertise to write and speak clearly, easily communicating complex ideas. Ability to look at the numbers, trends, and data and come to new conclusions based on the findings.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks. Strong background in support documentation. Analysis and review of Business Requirement Documents.
• Conducting requirement gathering sessions, feasibility studies and organizing the business requirements in a structured way.
• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.

Environment: Ethority(BI Tool), SQL Server, MS-Office, Tableau, Teradata, SQL, WinRunner

Confidential, Longview, WA

Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for New Customer Engagement (NCE)Data mart.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Good experience in Data mining with regards to convert raw data into useful information. By using software to look for patterns in large batches of data.
• Liaising with end-users and 3rd party suppliers. Analyzing raw data, drawing conclusions & developing recommendations Writing SQL scripts to manipulate data for data loads and extracts.
• Developing data analytical databases from complex financial source data. Performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
• Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements. Involved in defining the source to target data mappings, business rules, business and data definitions. Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team. Reverse engineered all the Source Database’s using Embarcadero.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document data quality and traceability documents for each source interface.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Involved in Data warehouse and Data mart design. Experience with various ETL, data warehousing tools and concepts.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and, assisting in the development of current and target state data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Also worked on some impact of low quality and/or missing data on the performance of data warehouse client. Identified design flaws in the data warehouse.
• Designed application components in an Agile environment utilizing a test driven development approach. Created and maintained project tasks and schedules.
• Provided task estimates, identified potential problems and recommended alternative solutions.
• Worked in close cooperation with project managers and other functional team members to form a team effort in development. Collaborated with other members of the product development team.
• Coordinated configuration of back-end components in support of application development.

Environment: SQL/Server, Oracle10 &11g, MS-Office, Netezza, Teradata, MDM, Informatica Data Quality, ER Studio, TOAD, Business Objects, Microstrategy, SAP, Greenplum Database, Qlikview, PowerPivot, Selenium, SoapUI, CruiseControl.Net, HP Quality Center 10, Maven, PL/SQL, OBIEE, Cognos.

Confidential, SanDiego, CA

Data Analyst

Responsibilities:

• Work with users to identify the most appropriate source of record required to define the asset data for financing
• Perform data profiling in the source systems that are required for financing
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the trumping rules applied by Master Data Repository
• Define the list codes and code conversions between the source systems and MDR.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Responsible for defining the key identifiers for each mapping/interface
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
• Involved in configuration management in the process of creating and maintaining an up-to-date record of all the components of the development efforts in coding and designing schemas
• Developed the financing reporting requirements by analyzing the existing business objects reports
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates
• Document data quality and traceability documents for each source interface
• Establish standards of procedures. Generate weekly and monthly asset inventory reports.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Provided direction and shares knowledge with and mentored team members in areas of expertise.
• Identified and continuously acted to improve individual and team knowledge of new technologies, business processes and project management skills.
• Stayed current on trends, latest industry developments and shared knowledge among colleagues.
• Excellent skills in user research and analysis of the existing systems, with knowledge of traceability matrix.
• Strong Experience in conducting User Acceptance Testing (UAT), Unit Testing and documenting Test Cases and Test Scripts.
• Involved in Test Planning, Test Preparation, Test Execution, Issue resolution and Report Generation to assure that all aspects of a project are in compliance with the business requirements.
• Excellent verbal and written communication skills with the ability to interact professionally with stakeholders at all levels of the organization, including the ability to exercise good judgment in frequency and nature of communications to senior management, stakeholders and team members.
• Possess a disciplined, professional and quality centered approach with strong analytical and problem solving skills.

Environment: SQL/Server, Oracle 9i, MS-Excel, Teradata, MDM, SAP, QlikView, Microstrategy, Informatica, PowerPivot, ER Studio, XML, Selenium, SoapUI, CruiseControl.Net, HP Quality Center 10, Maven Business Objects, OBIEE, Cognos

Confidential

Data Analyst

Responsibilities:

• Creation of Teradata FastLoad, BTEQ, Fast export scripts and UNIX shell scripts to perform the fulfillments Creation of Tables, Views to fulfill the business needs and support the Production systems with day to day activities and support the performance issues.
• Developed SQL, BTEQ (Teradata) queries for Extracting data from production database and built data structures, reports.
• Used the MS Excel, MS Access for data pulls and ad hoc reports for analysis.
• Performance tuning and Optimization of large database for fast accessing data and reports Ms Excel
• Informatica, Oracle, Teradata being used for data transformation
• Reports generated for various departments like Tele Marketing, Mailing, and New Accounts by using SQL, BTEQ, Ms Access.
• Developed Data mining processes for large data files.
• Ad-hoc reports developed using Oracle, SQL, and UNIX.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, SAS, Ms Excel, Ms Access, and UNIX.
• Extensively used excel and VBA to generate reports
• Created and manipulated datasets using SAS, Access, and Excel.
• Wrote JCL programs to communicate with the MVS (TSO, ISPF) operating system.
• Designed and implemented SQL queries for QA Testing and Report / Data Validation
• Assisted in preparing BRDs, FRDs, and Test Cases.
• Design Extract Transform load (ETL) procedures for data import and Manipulation.
• Worked with data modelers and assist them in verifying and validating the relationships between tables using Teradata SQL assistant.
• Execution, Maintenance & Debugging of the scripts with Teradata Bteq.
• Execution, Maintenance & Debugging of SAS scripts to update the Teradata Tables
• Creat Teradata tables, Views, Macros and analyzed various Teradata tables for UPI’s and Monitor the same. Execution of Mainframes JCL scripts.
• Utilized ODBC for connectivity to Teradata & MS Excel.
• Good experience in identification and requirements gathering as per the business requirements via meetings, interviews, interface analysis, research, etc.
• Experience in documentation of business requirements and system functional specifications in the form of Use Cases.
• Utilized a combination of business knowledge, technical skills and strategic analysis to provide solutions and creative insights to critical business problems.
• Maintained channels of organizational communication and acted as the point of contact between teams.

Environment: Teradat, Informatica, Ab Initio, Business Objects, Oracle 9i, PL/SQL, Microsoft Office Suite (Excel, Vlookup, Pivot, Access, Power Point), Visio, PowerPivot, QlikView, SAP, Cognos, Micro Strategy, Tableau, ERWIN, OBIEE.

Confidential

Data Analyst

Responsibilities:

• Stored reformatted data from different Mainframe applications using Informatica (ETL).
• Translated business-reporting requirements into data warehouse architectural design.
• Designed and maintained logical and physical enterprise data warehouse schemas
• Designed, developed and deployed new data marts along with modifying existing
• Marts to support additional business requirements.
• Extracted business customer product/revenue data from Express Track systems and consumer product/revenue data. Created naming and system standards for lookup, transformation and target tables. Loaded consolidated data using SQL*Loader in parallel and direct mode.
• Used Business Objects Designer, Reporter and Supervisor.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Designed, developed and implemented universes using Business Objects and Web intelligence.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager. Generated reports for end client using Query tools.
• Developed data mining to validate various data pulls for accuracy and completeness.
• Involved in meeting with Project owners and project managers to define the scope of the project.
• Followed the Agile methodology for elicitation and representation of requirements based on interaction with the Project owner, SME’s and the development team, participated in daily scrum.
• Facilitated requirement sessions, including creation of agendas and recording of action items from meetings and writing meeting minutes.
• Documented the requirements in the form of detailed use cases and sent out the same for inspection to the team.
• Responsible for creating Use case diagrams and process flow diagrams by using tools like MS-Visio.
• Involved in preparing test cases and also involved in reviewing test plans and test scripts developed by QA team to make sure that all requirements are covered in scripts and tested properly.

Environment: Informatica ETL, ER-Win, Shell Scripts, SQL*Loader, QlikView, SAP, Business Objects 5.0, PowerPivot, Web Intelligence 2.0, BigData, Oracle 7.x/8.0, Selenium, SoapUI, CruiseControl.Net, HP Quality Center 10, Maven Windows NT,OBIEE

Confidential

Data Analyst

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in developing interactive forms and customization of screens using Forms 4.5.
• Involved in building, debugging and running forms.
• Involved in Data loading and Extracting functions using SQL*Loader.
• Designed and developed all the tables, views for the system in Oracle.
• Designing and developing forms validation procedures for query and update of data.
• Extensive learning and development activities.
• Performed back-end testing for the Application.
• Performed manual testing for integration and acceptance.
• Performed negative and positive testing for the application.
• Modified existing Test Plans and Test Scripts for regression testing.
• Conducted data integrity testing by extensive use of SQL.

Environment: Oracle 8.0, SQL*plus, SQL*Loader, T-SQL, PL/SQL, Forms 4.5, Reports 2.5, Business Objects, WinRunner