We provide IT Staff Augmentation Services!

Data Analyst Resume

Trenton, NJ

SUMMARY

  • Over Seven years of total IT experience in the Business Requirements Data Analysis, Application Design, Development, Implementations and Testing of Data Warehousing and Database business systems for various Retail, Pharmaceuticals and Manufacturing industries.
  • Five years of experience as Data Analyst by gathering data from different sources, data profiling, data definition, and loaded those data on business warehouse. Worked on different kind of source systems and deeply understanding of business and accounting terms and formula.
  • More than Five years of Data Warehousing experience using Informatica Power center 8.1.1/7.1/6.2/5.1 , Power Connect, Power Exchange, Warehouse Designer, Power Analyzer, ETL, Data Mart, OLAP, OLTP, Star Schema, Snowflake Schema.
  • Experience in providing reporting analytical thinking, process improvements, problem solving, time management, decision making and issue resolution.
  • Technical expertise in ETL methodologies, Informatica 6.x/7.x/8.x - Power Center, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
  • Expertise in Data Warehousing, Data Mart, Data Migration, Data Modeling, and Data Cleansing.
  • Experience in software development life cycle.(SDLC)
  • Experience in testing and writing SQL and PL/SQL statements.
  • Experience in writing test cases to test the application manually and automated using Quick Test Pro.
  • Experience in Business Intelligence in generating various reports using Cognos and Business Objects.
  • Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
  • Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments.
  • Extensive database experience and highly skilled in Oracle, SQL Server, DB2, Teradata, Sybase, Flat Files, MS Access.
  • Expertise in configuring and manipulating Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling. Extensive knowledge with Dimensional Data modeling, Star Schema / Snowflakes Schema, Fact and Dimension tables.
  • Advanced knowledge in ETL, DSS and Data warehousing with OLAP technology.
  • Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
  • Experience to work as a Data Analyst to perform complex Data Profiling, Data definition, Data Mining, validating and analyzing data and presenting reports.
  • Ability to handle and interact with Business users, collect and analyze business / functional requirements.
  • Excellent Analytical, Communication skills, working in a team and ability to communicate TEMPeffectively at all levels of the development process.

TECHNICAL SKILLS

Data Warehousing: ETL Informatica Power Center 8.x/7.x/6.x, (Warehouse Designer, Transformation Developer, Mapplet, Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) Data Mart, FACT & Dimensions tables, Physical & logical dataModeling

Databases: Oracle 10g/9i/8i/8.0, IBM DB2, Teradata, MS SQL Server 2005/2008, MS Access

Database Languages: SQL, PL/SQL

Programming Languages: C, C++

Office Package: MS Office-97, 2000, 2003 and 2007

Environment: Linux, HP-UX, Windows2000/NT, Windows XP/Vista/7

Reporting Tool: SSRS 2005/2008

PROFESSIONAL EXPERIENCE

Confidential, Trenton, NJ

Data Analyst

Responsibilities:

  • Worked on gathering the requirement from client and develop the financial, administrative, FNOL and Litigation reports on SSRS and SQL Server 2005. I worked on Workers compensation Data Dictionary and Claim Center to analyze the data and to solve the production issues.
  • Develop the report on SSRS 2005/2008 using SQL 2005/2008
  • Work on unit test cases and coordinate with QA team to start working on scenarios.
  • Created deployment doc and send it to configuration team for deployment into VST and HST
  • Created deployment doc and send it to configuration team to deploy it in to UAT
  • Worked on smoke testing to see if the report is deployed and running in report manager.
  • Deployed reports on VST, HST, UAT and Production.
  • Worked on HPQC to generate a defect and assign the defects.
  • Worked on production issues and most of the time it is related to analyze data from mainframe(legacy) and compare it with new system(vendor Guidewire)

Environment: SQL Server 2005/2008, Tivoli, SSRS 2005/2008, ERWIN, HPQC

Confidential, Richmond, VA

Data warehouse Analyst/Modeler

Responsibilities:

  • Analyzed the source data coming from Legacy system, Oracle, DB2, sql server, PeopleSoft and flat files. Worked with Data Warehouse team in developing Dimensional data Model.
  • Co-ordinate with different application team to develop and standardize enterprise wide data model, created dimensional data model using Ralph Kimball Methodology, Designed and developed fact tables, dimension tables, conformed fact and dimension tables.
  • Extensively interacted with user for requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan, Release notes etc.
  • Extensively worked on Analyzing data, Applying business rules, designing the data warehouse, creating data mart/ schemas, partitioning the data, creating easy/quickest ETL process to load the data and automating the ETL process.
  • Participated in Complete formal Design process from initial specifications and requirement. Involved in creating technical design documentation.
  • As a team lead worked closely with the entire team member to assign the work and get the updated status of work as well as helped them to complete their job wherever required.
  • Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model to acrobat files.
  • Designed and developed Data warehouse, Data marts, star schemas, fact table, Dimension tables, Slowly Changing Dimension, Staging areas, Operational Data Store.
  • Involved in designing, development and testing of Interfaces to communicate with third party data.
  • Managing Oracle 11g databases for daily data loads
  • Worked with ETL team responsible for Designing, modeling, and creating ETL procedures to load bulk data into the highly denormalized database.
  • Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
  • Worked with reporting team in generating various reports using BO XI and helped them in providing the data according to their requirement.
  • Involved in designing Universes incorporating all the business requirements and creating hierarchies to support drill down functionalities in reports.
  • Created Unix Shell Scripts for Data Centric applications
  • Developed shell scripts for scheduling the jobs.
  • Extensively used Shell Scripts for loading the data. And monitoring all BULK data loads.

Environment: Oracle 11g, Erwin, SQL server 2000/2005, Informatica power center (Designer 8.x/7.x, Repository Manager 8.x/7.x, Workflow Manager 8.x/7.x,Informatica Power exchange, BO 6.5/ XI,BO DI, Hyperion, Flat files, Tivoli, Perl, UNIX and Shell Scripting

Confidential, Vineland, NJ

Data Analyst

Responsibilities:

  • Worked on 7 different source systems like JD Edwards, QuickBooks, Pecas, SAP etc.
  • Gathered all transaction fields and data from all these 7 different source systems.
  • Worked on data profile and data definition after gathered all fields from sources.
  • Worked on Source fields to Target fields mapping and put the transformation rules for each fields.
  • Responsible for Data profiling of large data sets using SQL Server 2008 to find out data quality problems before moving to the warehouse.
  • Created the data definition in Excel for each and every field for all source systems which came out from different Database Engines.
  • Created Source Mapping Excel Sheet for our group where all source and target fields are mapped and all business rules are applied to map all fields.
  • Also worked on Intercompany Transaction activity for reconciliation process.
  • Worked with Informatica Power center V8.X Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
  • Created Informatica Mappings to pull out data from these 7 different sources and load those Master Data and Transaction Data on BW staging area.
  • Used different transformations like Aggregator, Lookup, Filter, and Router.
  • Informatica Debugger is used to test the mappings and fixed bugs.
  • Created new repositories and new folders within the repositories using Repository Manager.
  • Created SQL complex queries and SQL performance tuning.
  • Changed existing Universes to accomplish the changes in business requirements.
  • Team Building, creating production and analysis report, documentation for various data processes.
  • Good experienced in communicating with different source persons, scheduling meeting with Source Business Person as well as Source Technical Persons.
  • Created final source approval and Gap/Recommendation Technical Document for each and every source systems.
  • Designed some Source system related diagrams using Microsoft Visio and prepared presentation on that.
  • Prepared documented reports for the usage of existing systems and new systems.

Environment: Informatica 8.x (8.6.1), Oracle 9i/10g, DB2, SQL Server 2008/2005, Microsoft Excel, My Access, MS Visio, Windows 2000

Confidential, Whitehouse, NJ

Data Analyst/Modeler

Responsibilities:

  • As a Data Analyst, the responsibility was to assume a key role in day-to-day support of Business Intelligence tools, Decisional and Reporting solutions, Business Objects, and underlying ETL framework.
  • Development of queries against corporate databases to extract, compile and associate records from maintenance system.
  • Involved in analysis and cleansing of data.
  • Developed data analysis models and tools in Excel or Access.
  • Developed reporting tools for use by other Transmission staff.
  • Trained staffs on use of query/reporting tools.
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
  • Responsible to Test and deploy new Business Object universes to meet business needs.
  • Involved in development of data requirements, data definitions and specifications for data collection procedures.
  • Responsible for analyzing huge data sets with basic statistical methods, interprets results, and provides written summaries of data analysis.
  • Developed Various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie-charts etc. using Microsoft Excel.
  • Worked with project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs.
  • Responsible for Data profiling of large data sets using SQL Server 2008 to find out data quality problems before moving to the warehouse.
  • Responsible for testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse.
  • Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.
  • Performed Sales analysis and projections using Access and Excel.
  • Involved in analysis and cleansing of data.
  • Involved in development of data requirements, data definitions and specifications for data collection procedures.

Environment: RUP, UML, Data stage, SQL 2008, Informatica 8.6.1, Business Objects XI R2-Web Intelligence and Desktop Intelligence, MS Office Suite (Word, Excel, Access and PowerPoint, Ms Visio).

Confidential, Basking Ridge, NJ

Technical Data Analyst

Responsibilities:

  • Involved in gathering end user requirements, User/System documentation, user training and testing developed reports for final deployment.
  • Business analysis user requirements Financial and Benefit Enrollment reports.
  • Responsible to collate appropriate data for use in databases and conduct related research.
  • Generated reports using IT / database systems and assist in their analysis.
  • Excellent use of graphs and charts with named groups and formula fields.
  • Designed and developed Crystal Reports.
  • Responsibilities included imparting training to the end-users and doing the knowledge transfer for reporting needs.
  • Analyzed the existing Crystal reports and tuned for faster execution. Troubleshoot existing reports to eliminate data discrepancies and respond to end-user inquiries.
  • Responsible for analyzing huge data sets with basic statistical methods, interprets results, and provides written summaries of data analysis.
  • Developed Various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie-charts etc. using Microsoft Excel.
  • Worked with project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs.
  • Gathered business requirements, implemented business processes, identified risks, impact analysis, sequence and activity diagrams
  • Involved in analyzing business and technical requirements and workflow of System Development Life Cycle.
  • Developed of many ETL components using Informatica 8.6.1.
  • Report writing using Business Objects XI R2.
  • Constructed process flows, stated diagrams, models, reports, and used interface design.

Environment: Oracle 9i, SQL Server 2005, Informatica 8, Web Intelligence and Desktop Intelligence, Info View and MS Office Suite.

Confidential

Data Analyst

Responsibilities:

  • Supervising the Management Information systems personnel.
  • Gathered business requirements, implemented business processes, identified risks, impact analysis, and sequence and activity diagrams.
  • Responsible for developing, implementing, Company's Plan and development of IT Strategic Plan.
  • Responsible for network security and analysis.
  • Managed the Computer Operations department.
  • Responsible for presenting the IT strategic plan to the senior management.
  • Responsible for Data profiling of large data sets using SQL Server to find out data quality problems before moving to the warehouse.
  • Responsible for testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse.
  • Conduct analysis of alternatives and provide recommendations for support issue resolution.
  • Worked with project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs.
  • Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.
  • Performed Sales analysis and projections using Access and Excel.
  • Involved in analysis and cleansing of data.
  • Designed and developed Crystal Reports.
  • Wrote SQL and PL/SQL and stored them in Crystal Query and attached them to the Crystal Reports using the Proper ODBC connections.
  • Involved in development of data requirements, data definitions and specifications for data collection procedures

Environment: Crystal Reports, Visual Basic 6.1, SQL, CRM, SQL Server Developer, SQL Server 2005, SSMS, Visual Studio, Business Intelligence tools, ER-WIN, MS Office 2007(Access, Excel, Visio), SQL.

Hire Now