OBJECTIVE

• To obtain a challenging position as Data Analyst with an emphasis on Data Warehousing to utilize my qualification and experience in Data Validation, Data Modeling, Data Mapping, Data Profiling, Data Manipulation, Data Cleansing, Data Filtering, Data Visualization, Performance Tuning and Gap Analysis successfully.

SUMMARY

• Over 6 years of experience in the Information Technology (IT) Industry serving as a Data Analyst in a Data warehousing environment.
• Working knowledge of Bank, Credit Card, Insurance, Mortgage, Finance, Investment and Healthcare domains.
• Hands on experience on Full life cycle of the project using methodologies like AGILE, SCRUM, XP Extreme Programming, Waterfall, RUP and hybrid methods.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Expert in analyzing/troubleshooting and providing technical support for Oracle/Unix applications and their interfaces.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Constructed and ran UNIX script.
• Vast experience in the area of data management including data analysis, gap analysis and data mapping.
• Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.

TECHNICAL SKILLS

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

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

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

Business Intelligence: SSIS, SSRS, SSAS

Design: Entity-Relationships, Data Flow Diagrams

Languages: SQL, PL/SQL

Tools: Erwin, Informatica, TOAD, Power Designer, MS Visio, E-R Studio, SQL developer, SQL*Loader, Microsoft Dynamics CRM

Reporting Tools: Business Objects 6.5, Cognos

Desktop Software: Microsoft Word, Excel, VB Macros, and PowerPoint

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Irving, TX

Responsibilities:

• Identify relationships and trends in data, as well as any factors that could affect the results of research.
• Analyze and interpret statistical data to identify significant differences in relationships among sources of information.
• Report results of statistical analysis, including information in the form of graphs and models.
• Develop and test experimental designs, sampling techniques, and analytical methods.
• Data mapping work of the data exist on the warehouse.
• Conducted User Acceptance testing (UAT) and work with users and vendor who build the system
• Perform data analysis for the existing data warehouse and changed the internal schema for performance
• Participate in Designing and development of the application.
• Use user stories approach for describing the requirements using the user story template.
• Perform Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Extensive use of SQL for accessing and manipulating database systems and Profiling.
• Gather requirements and create Use Cases, Use Case Diagrams, and Activity Diagrams using MS Visio.
• Prepare business flow diagrams and define the workflows.
• Assist in writing the stored procedure for 14 days Mailers that automated to SSRS reports to Business Analysts.
• Maintain a close and strong working relationship with team mates and management staff to achieve expected results for the project team.
• Work extensively on the MS-SQL environment to run out the queries and explore the Databases.
• Create and execute SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement and generate expected results for UAT.
• Assist in Manual Testing by checking various validations.
• Create, maintain, and execute manual test scripts.

Environment: s: Windows XP, Windows 2003 Server, Power Pivot, UNIX, SQL Server 2008/2012, SSRS, SSIS, MS Office, UML, MS Access, MS Visio, MS Excel, XML

Data Analyst

Confidential, Solon OH

Responsibilities:

• Identify relationships and trends in data, as well as any factors that could affect the results of research.
• Analyze and interpret statistical data to identify significant differences in relationships among sources of information.
• Report results of statistical analysis, including information in the form of graphs and models.
• Develop and test experimental designs, sampling techniques, and analytical methods.
• Data mapping work of the data exist on the warehouse.
• Conducted User Acceptance testing (UAT) and work with users and vendor who build the system
• Perform data analysis for the existing data warehouse and changed the internal schema for performance
• Participate in Designing and development of the application.
• Use user stories approach for describing the requirements using the user story template.
• Perform Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Extensive use of SQL for accessing and manipulating database systems and Profiling.
• Gather requirements and create Use Cases, Use Case Diagrams, and Activity Diagrams using MS Visio.
• Prepare business flow diagrams and define the workflows.
• Assist in writing the stored procedure for 14 days Mailers that automated to SSRS reports to Business Analysts.
• Maintain a close and strong working relationship with team mates and management staff to achieve expected results for the project team.
• Work extensively on the MS-SQL environment to run out the queries and explore the Databases.
• Create and execute SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement and generate expected results for UAT.
• Assist in Manual Testing by checking various validations.
• Create, maintain, and execute manual test scripts.

Environment: Windows XP, Windows 2003 Server, Power Pivot, UNIX, SQL Server 2008, SSRS, SSIS, MS Office, UML, Rational Clear Quest, MS Access, MS Visio, MS Excel, XSLT, XML, ASP.NET

Data Analyst

Confidential, Detroit, MI

Responsibilities:

• Designed data and source-to-target mapping work on the MIDE data warehouse.
• Worked on mapping and modeling of the data.
• Checking and validating data in the Mapping document running the queries on Oracle and SQL Server.
• Documented and maintained RTM (Requirement Traceability Matrix) to ensure that all requirements are traceable from top to bottom, hence provide a basis for test plan.
• Modified the existing mapping template to a more clear and easy to understand template.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Identified the source and target tables. Developed mapping document using MS excel.
• Determined the natural keys and surrogate keys for the target tables.
• Involved working on solution integration relative to the needs of the business.
• Performed Data alignment and Data cleansing
• Provided the required transformation logic using SQL/TSQL queries.
• Performed ad hoc Data analysis through UNIX command line.
• Organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Developed communications plan and message content in MS Office environment.
• Managed and exceeded counterparts’ and leaderships’ expectations.
• Worked on analyzing the data statistically and also prepared statistical reports.
• Involved on retrieving the different database and manipulated those data.
• Worked closely with the data architect to resolve the referential integrity problems.
• Delivered the artifacts within the stipulated time lines and excelled in the quality of deliverables.
• Awarded the ‘Above and Beyond Award’ for my excellent performance and meeting the deadlines beforehand.

Environment: Informatica, SQL Server 2008, Windows XP, Windows 2003 Server, Excel Macros, UNIX, OLAP, MS VB, MS Office, UML, Rational Clear Quest, and Powerdesigner.

Data Analyst

Confidential, Lisle IL

Responsibilities:

• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Resolved the data related issues such as: assessing data quality, evaluating existing data sources.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Analyzed the 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.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Performed Data cleansing and scrubbing while finding the quality data
• Worked on integration workflows and load processes.
• Worked extensively on the MS-SQL environment to run out the queries and explore the Databases.
• Defined key facts and dimensions necessary to support the business requirements.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling.
• Managed and supported the warehouse with the help of CRM tool.
• Meeting with 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 the data warehouse scenario.
• Created Fact and Dimension tables in Mart.

Environment: Windows 2003 Server, Mainframe, SQL Server 2005, UNIX, Mainframe, DB Visualizer, OLAP, MS Office, VB.NET, PeopleSoft CRM, PL/SQL, and Putty

Data Analyst

Confidential, Horsham PA

Responsibilities:

• Followed Rational Unified Process (RUP) methodology for creating artifacts.
• Conducted Interviews, brainstorming and Question and Answer sessions to identify requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design.
• Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using Visio.
• Created and maintained Data Dictionary and pursued to reach consensus.
• Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.
• Provided primary liaison between business/operations/vendors and development
• Created data models and data flow diagrams for the to-be process.
• Researched upstream data sources and ensured its owners attested all source data sources.
• Created report specifications containing mapping to source data sources.
• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Conducted UAT to verify whether all the Requirements were catered to by the application.
• Used Rational Test Manager for Test Case Management and Rational ClearQuest for defect tracking and resolution.
• Worked with the developers on resolving the reported bugs and various technical issues.
• Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Environment: Oracle 10g, SQL, Rapid SQL, OLTP, TOAD, MS Access, MVS, Excel Macros, Requisite Pro, Clear Quest, UNIX and Windows