We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume

3.00 Rating

Kansas City, KS

SUMMARY

  • A result oriented Business Analyst with more than 9 years of extensive experience in the field of Information Systems, Business Analysis, Business Modeling, Document Processing, and Business Intelligence with a sound knowledge of different phases of software development life cycle (SDLC) including analysis, design, development, testing, Implementation and maintenance.
  • Expertise inBusinessAnalysis, Scope Validation, Product backlog, Prioritization, project timelines and project milestones.
  • Diversified domain experience in Telecommunications, Financial, Retail, Banking and Insurance.
  • Extensive experience in Conceptualization to Implementation with experience in Requirements Gathering, Documentation, Workflow Preparation, Process re - engineering, Process Mapping, Scheduling, Capacity Planning, Statistical and Data Testing.
  • Performed feasibility and impact analysis by identifying and gathering requirements for functional and non-functional teams.
  • Experience working on Big Data Projects, Enterprise Information Architecture, Enterprise Data Modeling (EDM), ETL Processes, OLTP, OLAP, Data warehousing, Dimensional Modeling, and Business Intelligence (BI).
  • Strong skills Confidential SQL, Data Analysis, Data Mapping, Data Profiling. Exposure to ETL process through Informatica and SSIS.
  • Experience working with reporting tools like SSRS, OBIEE, Business Objects and Crystal Reports.
  • Extensively worked on star schema and snowflake schemas and modified existing schemas to meet the business requirements.
  • Extensively worked with source systems like MS SQL Server, Greenplum, HDFS, Oracle, Flat and XML files.
  • Experience in writing SQL statements, views, materialized views, stored procedures.
  • Expertise in formulating test approaches with Load, Integration, Regression and User acceptance Testing (UAT).
  • Highly analytical in developing the methods and measures to meet requirements and solve any issues.
  • Extensive experience with writing Story cards/ User Stories for the functional development and conducting sessions, methodologies like Waterfall and Agile.
  • Facilitated Change Management across entire process from project conceptualization to testing through project delivery, Software Development & Implementation Management in diverse business & technical environments, with demonstrated
  • Excellent communication skills and ability to work effectively with technical teams in order to translate business requirements into an effective solution and serve as an effective communication channel.
  • Self-starter with great leadership skills and demonstrated high aptitude in implementation of large scale projects
  • Effective Time Management Skills and consistent ability to meet deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Power Exchange, SSIS, Talend

Databases: Oracle 11g/10g/9i/8i, SQL Server 2012/2008, Netezza 7.0.2, Teradata, DB2

Database Tools/Utility: SQL Developer, Toad, Nexus, Enterprise Manager, SQL Plus, SQL Assistant, PG III Admin

Languages: SQL, PL/ SQL, T-SQL, Shell Scripting

Reporting: OBIEE 11.1.1.7, Business Objects

Scheduling Tools: Tidal, Informatica Scheduler, AutoSys, ESP scheduler, Tivoli.

Operating Systems: Windows, Unix, Linux

Other Tools: HP Quality Center, MS Office, MS Access, MS-Visio, Enterprise Architect, ERwin, Power Center Mapping Architect for Visio

PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential, Kansas City, KS

Responsibilities:

  • Conducted analysis, design and solution delivery for the data load design.
  • Worked closely with the data architect and the users to design the interfaces and data loads to ODS.
  • Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
  • Developed views and stored procedures to needed for the source data.
  • Understanding the Business Processes and prepared mapping documents based on standard templates.
  • Understanding the Scope and preparing the Project Plan, Work Breakdown Structure, and Critical Path Analysis.
  • Eliciting the requirements from the business owners for conceptual understanding of the business functions, analyzing and presenting artifacts like Business Requirements, Functional Requirements, Non Functional Requirements and Data Requirements.
  • Understanding of Functional Requirements Documentation and Ensure Implementation of Final Requirements.
  • Support and facilitate the SME’s and Data Architect in analysis and designing Logical and Physical Architecture in design phase.
  • Facilitating the technical team in determining and Validating potential data sources, Business rules, DDL scripts, building Validation plan, and communicating the reports in different environments.
  • Responsible for developing application requirements and maintaining Traceability Matrix.
  • Followed SCRUM methodology in implementation of SDLC process supporting Product Owner for researching for User Stories.
  • Assisted SCRUM team in documentation, wireframes, GUI Screens, Mockups and test cases.
  • Participating in Testing, Production and Go-Live activities.

Environment: SQL Server Management Studio, Informatica Power Center, SSIS, SSAS, AS400, Tidal, Oracle, Hadoop, Greenplum.

Sr. Business Analyst

Confidential, Charlotte, NC

Responsibilities:

  • Designed and developed expense model to assign and allocate expenses to business units.
  • Worked closely with the financial analyst, data source system experts and the business users to design the interfaces and data loads to the warehouse.
  • Responsible to identify business requirements from stakeholders using Joint Application Development sessions and interviews for complex business objectives with respect to each expense model.
  • Responsible for analysis of future state requirements and process flows.
  • Worked on scripts to process data and developed validation scripts.
  • Worked with financial consultants to analyze and develop requirements.
  • Worked closely and interact directly with the client’s business owners and IT staff to identify, rationalize and document business requirements.
  • Conducted meetings with the senior management to present the cost/benefit analysis.

Environment: Oracle SQL Developer, Informatica Power Center, OBIEE, Autosys, Oracle, DB2, Linux.

Sr. ETL Developer

Confidential, Atlanta, GA

Responsibilities:

  • Designed and developed ETL code to extract data from enterprise DW and other systems into Datamart.
  • Involved in business analysis and technical design sessions to develop requirements document and ETL specifications.
  • Worked with analysts and data source systems experts to map requirements to ETL code.
  • Worked on JIRA (Helpdesk) tickets to address requests by the report writers to enhance ETL or fix data issues.
  • Provided weekend on-call support.

Environment: Informatica Power Center, Netezza, Oracle, Teradata, Nexus, Business Objects, TOAD, SunOS.

Sr. Informatica Developer

Confidential, Charlotte, NC

Responsibilities:

  • Worked on conversion and workforce hub load from legacy systems.
  • Worked on ETL mappings using XML parser, XML generator and Web Services.
  • Documented application level documents for production support team.
  • Worked with the Quality Center test cases with the QA team to validate data load.

Environment: Informatica Power Center, SQL Server, SQL Server Management Studio, SSIS, ESP Scheduler.

Sr. ETL Informatica Developer

Confidential, Omaha, NE

Responsibilities:

  • Involved in analysis, design and development for extracting data from the source systems like XML files, Flat Files, SQL Server and loading into IDS and Data Marts.
  • Worked closely with the data architect, analysts, data source system experts and the users to design the interfaces and data loads to the Warehouse.
  • Worked on creating technical specifications using functional specifications.
  • Designed the batch processes to handle the ETL batch jobs across all the interfaces.
  • Involved in enhancement, maintenance, documentation and support of ETL processes.
  • Worked closely with the business users to develop the transformation logic to be used in Informatica.
  • Involved in Performance Tuning of the Complex Informatica mappings and also fine-tuned the SQL queries in Informatica mappings.
  • Applied Error Handling in Informatica mappings & sessions and also through validation scripts
  • Created and used Shell scripts for running workflows and generated log files for the ETL process.
  • Extensively used TIDAL scheduler tool for scheduling Informatica workflow and reports.
  • Involved extensively in Unit testing, integration testing, system testing and UAT.
  • Followed the best practices for the environment as set up by the Administrator which include but are not limited to Change control process, Documentation process, Code/Peer Review, Optimization standards.

Environment: Informatica 8.6/9.1, SQL Server 2005/2008, T-SQL Stored Procedures, SQL Server Integration Services, SQL Server Reporting Services, TIDAL Scheduling tool, Visual Studio 2005/2008, Power Point, Office, Excel Power pivot 2010

Sr. ETL Informatica Developer

Confidential, San Jose, CA

Responsibilities:

  • Involved in gap analysis, SD, SI and testing phases of ETL processes.
  • Worked on requirement gathering for B2B XML’s feed (Customer and Product).
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence.
  • Imported XML target definitions from an XML, DTD, and XML schema files.
  • Responsible for developing, support and maintenance for the ETL processes.
  • Setting up jobs to schedule the loads Confidential required frequency using Power Center Workflow manager.
  • Monitored the status of Workflows/Work lets/Sessions in Gantt chart and Task view mode using Workflow Monitor.
  • Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
  • Created Unix Shell Scripts for automation of ETL process.
  • Created documents for ETL interface specifications, technical design and Requirements Traceability Matrix (RTM).
  • Worked on migration templates, Informatica Admin standards document and monitored production jobs.
  • Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad (Query Analyzer), PL/SQL, XML, XSD, DB Grids, MS Visio, UNIX, Windows XP/2000.

Sr. ETL Informatica Developer

Confidential, Memphis, TN

Responsibilities:

  • Coordinating with the Functional team and gathering user/system requirements.
  • Developing the mapping Spreadsheets, ETL Design Documents for each Mock execution.
  • Developed complex mappings to load data from Source Systems (Oracle) and flat files.
  • Used Informatica Power Exchange to connect to IBM Mainframe systems (JCL, Cobol Files), JMS (Java Messaging Services) to provide access data in various formats such as VSAM, IMS and IDMS.
  • Employed different transformations like Normalizer, Stored Procedure, Update Strategy, Lookup, Router, Filter, Sequence Generator, Sorter, Expression transformations in Informatica mappings.
  • Created reusable transformations, mapplets and worklets.
  • Worked extensively on connected, unconnected and dynamic lookup transformations for better performance.
  • Worked on loading data from Oracle to Netezza while maintaining the referential integrity of the dimensions in Oracle.
  • Used Nexus to query Netezza DB to search 5-to-20 terabyte tables with sub second response times.
  • Worked as an ETL Admin on a short term basis, Created Folders, new Connections for existing folders, new user addition/privileges requests.
  • Was responsible for handling development/changes/defect fixes in 4 Project Modules (Project Setup, Alternate Projects, User defined, Project workforce PLC)
  • Involved in Unit testing, System testing and capturing the test results.
  • Wrote Pre-SQL and Post-SQL scripts in Informatica sessions for complex logics.

Environment: Informatica Power Center 8.6/7.1.4, Informatica Power Exchange 5.2.2, Oracle 10g/9i, PL/SQL Procedures, Netezza, TOAD, Nexus, UNIX, Autosys, Rational Clear case, MS Visio.

ETL Developer

Confidential, Auburn Hills, MI

Responsibilities:

  • Coordinating with the Functional team and gathering user/system requirements.
  • Developing the mapping Spreadsheets, ETL Design Documents for each Mock execution.
  • Developed complex mappings to load data from Source Systems (Oracle) and flat files.
  • Used Informatica Power Exchange to connect to IBM Mainframe systems (JCL, Cobol Files), JMS (Java Messaging Services) to provide access data in various formats such as VSAM, IMS and IDMS.
  • Employed different transformations like Normalizer, Stored Procedure, Update Strategy, Lookup, Router, Filter, Sequence Generator, Sorter, Expression transformations in Informatica mappings.
  • Created reusable transformations, mapplets and worklets.
  • Worked extensively on connected, unconnected and dynamic lookup transformations for better performance.
  • Worked on loading data from Oracle to Netezza while maintaining the referential integrity of the dimensions in Oracle.
  • Used Nexus to query Netezza DB to search 5-to-20 terabyte tables with sub second response times.
  • Worked as an ETL Admin on a short term basis, Created Folders, new Connections for existing folders, new user addition/privileges requests.
  • Was responsible for handling development/changes/defect fixes in 4 Project Modules (Project Setup, Alternate Projects, User defined, Project workforce PLC)
  • Involved in Unit testing, System testing and capturing the test results.
  • Wrote Pre-SQL and Post-SQL scripts in Informatica sessions for complex logics.

Environment: Informatica Power Center 8.6/7.1.4, Informatica Power Exchange 5.2.2, Oracle 10g/9i, PL/SQL Procedures, Netezza, TOAD, Nexus, UNIX, Autosys, Rational Clear case, MS Visio.

We'd love your feedback!