SUMMARY

• More TEMPthan 8+ years of experience as Data Analyst in product development and Data Warehousing. Significant experience in working across organizational groups, using clear/concise communication skills to facilitate mission objectives in a timely manner.
• In depth noledge of teh Software Development Life Cycle (SDLC).
• Strong hands on experience wif ETL tools.
• Strong business analysis skills and in depth understanding of teh software development life cycle (SDLC).
• Vast experience of working in teh area data management including data analysis, gap analysis, and data mapping.
• Expertise in Requirement Analysis, Use Case development, UML Modeling using MS Visio.
• Motivated team player wif demonstrated talent for deploying IT and organizational skills toward Analyzing, Designing, Implementing and streamlining complex IT processes for improvement opportunities.
• Working noledge of Data Warehouse including star schema, snow flake schema, slowly changing dimension, facts and dimensions.
• Extensive experience wif Data Analysis on Data warehouse system for various reporting systems wifin an organization.
• Experience working wif Oracle Developers and DBA to identify bottlenecks and performance issues and work on fixing them.
• Created and executed Test Plan, Test Scripts and Test Cases based on Design document and User Requirement document for testing purposes.
• Involved in User Acceptance Testing and training of end users. Defined and documented business training requirements for new product releases.
• Coordinated and prioritized outstanding defects and system requests based on business requirements.
• Acted as a liaison between teh development team and teh management team to resolve any conflicts in terms of requirements.
• Interacted wif all levels of teh project development team, from end users to Software Architects, Technical Lead, Database Administrators and System Administrators
• Experience wif various technologies such as: Oracle database, PL/SQL SQL*Loader, TOAD.
• Extensively Worked on Packages, Procedures, and Functions in PL/SQL.
• Used Explain Plan to monitor execution path and to decide on which hints to use.
• Excellent noledge of UNIX shell script on Sun Solaris 2.8/2.7 and HP UNIX 12.x/11.x.
• Extensive worked on Data dictionary and Interface agreement documentation.
• Good communication and customer service skills, Responsible, self - motivated and organized, Excellent written and verbal skills.

TECHNICAL SKILLS

Database: Teradata, DB2, Oracle, SQL Server, My SQL, MS Access, Netezza

Data Warehouse Concepts: ODS, Star Schema, Snowflake schema, OLTP, OLAP

Operating Systems: UNIX, MS Windows 2000 & NT, MS DOS

Design: Entity-Relationships, Data Flow Diagrams

Languages: Pro *C, SQL, PL/SQL

Tools: Informatica, Epic Clarity ETL, Erwin, TOAD, Power designer, Rational rose, MS-Visio, E-R Studio, DB Visualizer, SQL developer, SQL*Loader, MS SQL, Altova & Altova Mission Kit Suite of Tools

Reporting Tools: Business Objects 6.5, Cognos, SAS

Desktop Software: Microsoft Word, Excel, PowerPoint

Ticketing Tool: BMC Remedy Action Request System 5.0 & 7.1

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr.Data/ ETL Analyst

Responsibilities:

• Analyzed teh historical source data from teh Mainframe system and teh current application
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Involved in JAD sessions to solve teh different issues occurred during teh project development.
• Interacted wif users for verifying user requirements, managing change control process, updating existing documentation.
• Installing and Set up of Microsoft SQL Server 2014 and Oracle 11g
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Defined key facts and dimensions necessary to support teh business requirements.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Installation and Setup of Altova ETL tool.
• ETL coding to handle bad data during transformation and build lookup/reference table
• Building table based on Zip Codes, City, Town, County purchased from USPS for Mass State.
• Involved in writing test cases, test plans and participated in user acceptance testing (UAT)
• Used Quality Center for bug tracking, reporting and report generation for teh test cases
• Performed backend testing to check teh system data integrity for insert, update, delete and retrieve transactions by writing
• Worked on various documents including Quality Document, Design Document, ETL Design Document, Deployment Document, Business Matrix Document, Result Document and Analysis Document.
• Using SSRS creating well-formed reports and web-based reports for Monthly birth related application.

Environment: Altova ETL Tool, Altova Enterprise Mission Kit (Map force, DiffDog, UModel, Schema Agent, DB query), XML Spy,, Oracle 11g, Microsoft SQL server 2014, Clover ETL, SQL query, MS Visio, MS office Suite, Oracle Developer, Windows, Move IT server, Nuance PDF convertor

Confidential, Pleasanton, CA

Sr.Data Analyst/Business Analyst

Responsibilities:

• Analyzed teh source data, coordinated wif Data Warehouse team in developing Relational Model. Understand and translate business needs into data models supporting long-term solutions.
• Worked wif teh Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Coordinated wif teh data owners and implying teh transformation/business rules to test teh target data.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.Optimize and update logical and physical data models to support new and existing projects.
• Created teh Mapping document to specify, teh location of teh table in database, conversion rules and business rules.
• Performed Data analysis, and created Data mapping for ETL design that feeds to physical data models
• Analyzed teh source data coming from various data sources like Mainframe & Oracle.
• Defined key facts and dimensions necessary to support teh business requirements.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Converting raw file into SAS Datasets and worked on SAS/Base, SAS/Stat, SAS/Access, SAS/Graphs and SAS/Macro.
• Experience in testing Facets
• Flat file conversion from teh data warehouse scenario.
• Involved in JAD sessions to solve teh different issues occurred during teh project development.
• Interacted wif users for verifying user requirements, managing change control process, updating existing documentation.
• Executed SQL queries, PL/SQL stored procedures, triggers on back end as a part of data analysis and data validation.
• Involved in Data analysis using OLAP tools and Cognos reporting tasks to generate quarterly, yearly reports.
• Complex SQL queries including joins, group by, having clause etc.
• Extensive noledge of working on MS excel using IF, look up, date, PMT functions.
• Involved in writing test cases, test plans and participated in user acceptance testing (UAT)
• Used Quality Center for bug tracking, reporting and report generation for teh test cases
• Performed backend testing to check teh system data integrity for insert, update, delete and retrieve transactions by writing
• Reviewing ETL jobs using Extensible Markup Language (XML)

Environment: Informatica, EPIC Clarity ETL, SAS, MS Office, Quality Center, SQL, PL/SQL, WinSQL, UNIX, Cognos, Oracle, Teradata, MS Visio, Windows, MS Visio

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Worked wif business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Resolved teh data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Worked on several data mart projects as a senior data warehouse architect, was involved in complete system development life cycle, starting from requirement specifications to delivering teh tested product.
• Worked closely wif Data Architect to review all teh conceptual, logical and physical database design models wif respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds teh logical data models.
• Analyzed teh source data coming from various data sources like Mainframe & Oracle.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Assisted in documenting teh end-user’s AS-IS and TO-BE business processes (Gap Analysis) to ensure that teh system initiatives are met.
• Defined key facts and dimensions necessary to support teh business requirements.
• Worked on ETL design for various source systems.
• Worked on OLAP tools to perform analysis from different point of views as per user's requirements.
• Involved creating teh Data dictionary object using SQL server.
• Proficient in using MS Excel using functions pivot tables, look up function, macros, graphs etc.
• Provided teh required transformation logic using Oracle queries
• Performed ad hoc Data analysis through UNIX command line
• Reviewed all teh systems design by assuring adherence to defined requirements.
• Meeting wif user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Flat file conversion from teh data warehouse scenario.
• Created Fact and Dimension tables in Data Mart.

Environment: Oracle, SQL, Rapid SQL, OLTP, TOAD, MS Access, Test Manager, Requisite Pro, Clear Quest, UNIX and Windows

Confidential, Bethesda, MD

Data Analyst/Developer

Responsibilities:

• Supporting existing Sales Reporting Data Warehouse built upon Oracle using PL/SQL for ETL and reporting.
• Performing daily monitoring of system logs, events and scheduled batch jobs to ensure ongoing system operation.
• Performing and documenting root cause analysis for each incident.
• Working wif upstream and downstream applications to ensure incoming data feeds are complete and successful as well as outgoing data feeds.
• Responding to and resolve production support requests from users
• Responding to and resolve alarms from batch jobs.
• Supporting performance testing and tuning activities for all applications
• Creating teh data mapping document to specify teh location of teh table in database, conversion rules and business rules.
• Performed gap analysis between teh “As-Is” model of teh legacy system and teh “To-Be” model to identify teh gaps, logged issues relating to teh identified gaps and worked wif teh SME to get clarifications.
• Analyzed teh source data, Coordinated wif Data Warehouse team in developing Relational Model. Performed Data Analysis and Data validation by writing complex SQL queries using TOAD and SAS against teh ORACLE database.
• Extensive noledge of working on MS Excel using Pivot tables, Lookup, Graphs, Macros functions.
• Experience on OLAP software for data analysis from different point of view by users.
• Performing Data Analysis and Data validation on SCD2 and fact tables by writing complex SQL queries against teh Oracle database.
• Performing validation of application after upgrading version of Oracle Database (11g).
• Update target tables to fix defects in SRW.
• Experience on UNIX scripting during teh ETL batch process
• Using Rational ClearQuest for defect tracking and resolution

Environment: Oracle, SQL, PL/SQL, Toad, WinSQL, ClearCase, Informatica, SAS, ClearQuest, Cognos, Netezza, UNIX, MS Excel, MS Visio.

Confidential, IL

Data Analyst

Responsibilities:

• Created data requirements that identified each available business source systems that can possibly utilize and teh necessary business attributes it will require to facilitate commitment tax accounting.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, SAS, MS Excel, MS Access, and UNIX.
• Worked in collaboration wif various areas of teh organization, identifying additional stakeholder requirements, and preparing project plans and status reports; managed teh test project utilizing a dynamic plan that ensures that key stakeholders continually understand deliverables, timing and dependencies for success.
• Responsible for updating project status using MS Project and maintaining teh Dashboard.
• Work closely wif various financial and mortgage business teams in gathering teh business requirements.
• Analysis of teh data identifying source of data and data mappings.
• Involved in segmentation of raw data. Used SAS ODS to generate reports.
• Created tabular reports using Base SAS & SAS/Reports procedures.
• Worked extensively in documenting teh Source to Target Mapping documents wif data transformation logic.
• Interact wif teh SME's to analyze teh data extracts from Legacy Systems and determine teh element source, format and its integrity wifin teh system
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate wif data modelers, ETL developers in teh creating teh Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that teh data elements and attributes are properly named,
• Support development teams creating applications against supported databases.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.

Environment: MS SQL Server 2005/2008, MS SQL Server, SQL, Windows XP, Agile Methodology, T-SQL, SAS, MS Excel, MS Visio.