SUMMARY

• 6+ years of experience in the Information Technology Industry as Data Analyst in Data Warehouse Environment, Data Modeling and Data Manipulation.
• Strong experience in assisting with the development and upgrading of database systems.
• Experience in using Excel, Access and SQL for Data Manipulation, Data Cleansing & Processing data.
• Experience working with Excel functions such as Pivot, VLOOKUP, SUMIF and knowledge of Macros and VBA.
• Experience working with System Development Life Cycle (SDLC) methodologies like Waterfall and Agile/SCRUM.
• Experience on Business Intelligence tools such as OLAP, Data warehousing, reporting and querying tools.
• Good knowledge on Relational Database and Dimensional Data Modeling.
• Experience in Data Modeling, Data Transformation, Data Loading, Data Dictionary, Meta Data, and Performance Tuning.
• Experience in conducting user interviews, working with the business users to define business requirements, data requirements and analyze the possible technical solutions.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Experience on integration and implementation of projects and products, creating database, modeling, calculating object sizes, table spaces and database sizes.
• Experience with SQL, PL/SQL objects and involved in creating Packages, writing Procedures and Functions.
• Experience on creating Source to Target Mapping documents, gathering business requirements from business/user, creating Process Flows and Data Flow Diagram (DFD).
• Working directly with ETL team for data extraction and Data Quality (DQ) team for validation.
• Profiled large datasets and data files using SQL as primary language to check the quality of the source data.
• Experience on translating business requirements into data requirements.
• Experience in conducting Joint Application Development (JAD) session with end - users, SME’s, Developers and QA team.
• Interacted with all project development teams such as front end users, software designers, technical lead, database administrators and system administrators.
• Good communication skills and team approach.

TECHNICAL SKILLS

Databases: MS SQL Server, Oracle, DB2, MS Access, MySQL, Teradata, Sybase

Languages: SQL, PL/SQL, XML, UML, C

SDLC Methods: Agile (SCRUM),Waterfall

ETL Tools: Informatica 9.1/8.6.1, SSIS 2005/2008

Reporting Tools: SSRS 2005/2008 Business Object

Business Tools: IBM Rational Requisite Pro, IBM Rational Rose, Enterprise Architect, MS Visio, IBM Rational Clear Case, MS Word.

Database Tools: SQL Developer, Teradata SQL Assistant, MySQL Workbench, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS)

Data Modeling: ERWIN, MS Visio, Power Designer, ER Studio

Other Tools: MS Project, MS Office, SharePoint, Business Objects

Defect Tracking: IBM Rational Clear Quest, Mercury Quality Center (QC)

PROFESSIONAL EXPERIENCE

Confidential, Bridgeton, MO

Data Analyst

Responsibilities:

• Worked with the Project Manager in creating the process swim lane and also estimates for completion of the technical artifacts needed for development.
• Verified the correlation between the UML diagrams and developed detailed diagrams.
• UsedSQLto verify the data from theOracleand MS SQL Server databases.
• Extensively tested the ETL mappings which were developed to load data from Oracle and SQL Server sources into the Oracle Staging/Target Area.
• Worked closely in conjunction with business (SME’s) and application data stewards to get business responses and source-to-target mapping clarifications.
• Provided pseudo code for DQ and ETL developers.
• Validated the system End-to-End Testing to meet the Approved Functional Requirements.
• Interacted with client user personnel to ensure continuing adherence to requirements and user standards.
• Involved in formal review meetings with project teams and developers to report, demonstrate, prioritize and suggest resolution of issues discovered during testing.
• Interacted with the developers to report and track bugs using Rational Clear Quest.
• Increased process efficiencies and reduced development cycle time across department by spearheading the implementation of the full lifecycle software development methodology.

Environment: Windows 2000, MySQL, Oracle, MS Access, MS Excel, MS Word, MS PowerPoint, Rational Clear Quest, MS Visio, Erwin.

Confidential, NY

Business Data Analyst

Responsibilities:

• Analyzed business and wrote Business Rules Document.
• Implemented Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.
• Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Performed Gap Analysis to check the compatibility between the existing system and the new business requirements.
• Facilitated Joint Application Development (JAD) sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people.
• Used MS Visio for business flow diagrams and defined the workflows.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Participated in designing and development of the application.
• Wrote technical papers, gathered technical requirements, and compiled them to help the design system.
• Interacted with the software development team and executive team to liaison the business requirements ensuring that the application under development confines to the business requirement.
• Performed data mapping from source to target.
• Extensively used SQL for accessing and manipulating database systems.
• Facilitated in overall management of the project, status reports, client presentations, defining milestones, deliverables and establishing critical success factors.
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Created Use Case Diagrams using UML to define the functional requirements of the application.
• Performed User Acceptance Testing (UAT), Unit Testing and Documenting.
• Organized meetings with the development teams to elicit use cases and document them.
• Wrote manual Test Cases for checking the application.
• Involved in Manual Testing by checking of various validations.
• Created, maintained, and executed manual test scripts.

Environment: Oracle, DB2, MS Visio, MS office, SSRS 2008, Business Object, IBM Rational Suite (Rational Requisite Pro and Rational Rose).

Confidential, Irving

Data Analyst

Responsibilities:

• Documenting functional, nonfunctional/ supplemental requirements, business rules/web intelligence rules from users, existing systems for the evolving applications.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Reviewing business requirements and working with business and requirements team for gaps found during the review.
• Facilitated Joint Application Development (JAD) sessions.
• Gathered requirements using interviews, document analysis, requirements workshops, storyboards and surveys.
• Participated in creating ER diagrams and class diagrams during the central repository implementation phase. Gathered requirements for the reporting system based on the central repository.
• Performed risk management for identifying, analyzing and managing existing and expected risks in the project by creating Risk Management and Response Action Plan
• Creating/Updating Use Cases, Activity Diagrams, Class Diagrams, Data Flow Diagrams (DFD).
• Wrote SQL queries on data staging and data warehouse tables to validate the data results.
• Eliciting requirements for relational databases, batch processing systems and various reports.
• Created and executed SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement and generate expected results for User Acceptance Test (UAT).
• Writing User Acceptance Test Cases from requirements and managing them in Mercury Quality Center.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
• Test defect tracking in Quality Center and coordinating bug remediation.
• Managing, version controlling, distributing project documents, release review decks via Share point.
• Process measurement (metrics), process monitoring, process simulation, process improvement.
• Training users, peers on various deliverables, process steps/methodologies, tools, applications.

Environment: Rational Requisite Pro, Rational Rose, IBM Workbench, SharePoint, Microsoft CRM 3.0, Business Objects, MS Project, Mercury Quality Center, ClearCase, ClearQuest, Teradata, DB2.

Confidential

Research Data Analyst

Responsibilities:

• Assist the project leader in all the project related activities such as carrying out research activities, organizing and presenting training, workshops, seminars and administrative support.
• Assisted in designing and modifying questionnaires and other data-collection forms.
• Designed/created consumer profile database using Microsoft Access and data entry into MS Access.
• Prepared tables including keying, verifying, and formatting data for presentation and publication.
• Managed statistical calculations, and summarized results for professional review.
• Assisted in gathering, evaluating and presenting data.
• Studied and examined skewed results, investigated possible causes and deviations, and prepared relevant reports explaining findings.
• Compiled tables, charts, graphic displays from processed data for final reports and analyses using excel and statistical tool SPSS.
• Prepared the relationship diagram between the various study parameters using SPSS.
• Preparation of report with the detailed summary of the analysis.

Environment: Windows XP, MS Access, MS Excel, MS Word, MS Power Point, SPSS.

Confidential

Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for RML System.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules 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.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Documented 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 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 project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data warehouse.

Environment: Oracle, Informatica, SSIS 2008, ER Studio, MS Office, MS Visio, IBM Rational Clear Case.