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 Consolidation, Data Visualization, Performance Tuning & Gap Analysis successfully.

SUMMARY

• 7+ years of experience in the Information Technology (IT) Industry serving as a Data Analyst in a Data warehousing environment.
• Hands on experience on Full life cycle of the project using methodologies like Waterfall, Agile and hybrid methods.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. Performed JAD sessions with business and technical teams.
• Experience in Data alignment and Data cleansing.
• Involved in constructing and running Unix shell script
• Vast experience of working in the area data management including data analysis, gap analysis and data mapping.
• Worked extensively with Dimensional Modeling and Data Migration.
• Experience in Data Transformation, Metadata, and Data dictionary, Data Loading, Modeling and Performance Tuning.
• 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.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Involved on retrieving and extracting data from multiple sources.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking.
• Acted as a liaison between the development team and the management team to resolve any data conflicts in terms of requirements.
• Interacted with all levels of the project team, from end users to Software Architects, data governance team, Database Administrators, and testers.

TECHNICAL SKILLS

Database: Teradata 13, Oracle 11g, SQL Server 2005, My SQL, MS Access

D/W Concepts: ODS, Star Schema, Snowflake schema, OLTP, OLAP

Operating Systems: UNIX and windows

Languages: SQL, XML, PL/SQL

Tools: Informatica, Erwin, TOAD, MS-Visio, SQL developer, SQL*Loader

Reporting Tools: Business Objects 6.5, Cognos, SAS

Desktop Software: Microsoft Word, Excel Macros, and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis MN

Data Analyst

Responsibilities:

• Created test scenarios, test data executed for test cases.
• Performed multiple source data analysis for the input OLTP systems.
• Coordinated multiple OLAP and ETL projects for various data lineage and reconciliation.
• Debugging the SQL-Statements and stored procedures for business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Validating and profiling Flat file Data into Teradata tables using Unix Shell scripts.
• As Data analyst responsible for the understanding the business data requirements, ETL and subsequently creating testing of data in reports.
• Tested several BO Reports for completeness, quality for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Analyzed the bug reports in BO reports by running similar SQL queries against the source system(s) to perform root-cause analysis.
• Created and Reviewed Informatica Mapping documents to with business and data governance rules.
• Created SQL queries to generate ad-hoc reports for the business.
• Translated cell formulas for business users in Excel into VBA code to design, analyze, and deploy programs for their ad-hoc needs.
• Created and updated metadata repository in Oracle for End to end DW.
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Extensively worked on data profiling and scanning to de-duplicate records in the staging area before data gets processed.

Environment: Informatica 8.6.1, Business Objects XIR3, WinSQL, QTP 9.2, Quality Center 9.2, TOAD, Oracle 9i/10g, SQL, PL/SQL, IBM DB2, VBA MS Excel.

Confidential, Baltimore, MD

Data Analyst

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 Teradata.
• 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 Teradata 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 SAS tool.
• 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.
• Validated the data during unit testing in the MO region before sending it for system testing.
• Awarded the ‘Above and Confidential Award’ for my excellent performance and meeting the deadlines beforehand.

Environment: Mainframe, Cognos, Windows XP, Windows 2003 Server, Excel Macros, UNIX, Teradata, OLAP, MS VB, MS Office, UML, Rational Clear Quest, Teradata, Microsoft Dynamics CRM, SAS and Power designer

Confidential, Temple Terrace FL

Data Analyst

Responsibities:

• Analyzed and interpreted statistical data to identify significant differences in relationships among sources of information.
• Reported results of statistical analysis, including information in the form of graphs and models.
• Data mapping work of the data exist on the warehouse.
• Effectively implemented defect management process using ClearQuest.
• Performed User Acceptance testing (UAT) for few data intensive reconciliation modules the system
• Performed data analysis for the existing data warehouse and changed the internal schema for performance
• Participated in Designing and development of the application.
• Used user stories approach for describing the requirements using the user story template.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Extensively used SQL for accessing and manipulating database systems
• Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Prepared business flow diagrams and defined the workflows.
• Involved writing the stored procedure for 14 days Mailers
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results for the project team.
• Worked extensively on the MS-SQL environment to run out the queries and explore the Databases.
• Created and executed SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement and generate expected results for UAT.

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

Confidential, Temple Terrace FL

QA Lead tester- Consultant

Responsibilities:

• Validated Fios orders in SQL database. Created SQL queries for the order flow and compared the fallout of orders both in front end and backend.
• Analyzed business requirements, and Functional requirements.
• Wrote detailed test cases for the Integration testing and system testing with 10 member team.
• Participated in defect review Meetings.
• Used SQL statements for Data validation and Database integrity testing
• Wrote SQL scripts for retrieving and updating the database tables for the
• Backend Testing
• Managed entire quality process like creating test cases, submitting defects in Quality center. .
• Communicated with the offshore test and dev teams.
• Used TOAD tool for database querying. Verified data population using sql queries in pending status, orders, customer data and fulfillment tables etc.
• Responsible for making Defect status report and Project status report weekly.

Environment: - .NET, XML, ASP.Net, C++, Oracle 11 PL/SQL, J2ee and tools - MS office Excel, HP Quality Center, TOAD.

Confidential, Cleveland, OH

Data Analyst

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, data consolidation, 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.
• Developed and ran Unix shell scripting
• 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.
• Dealt with Oracle Hyperion Financial Management tool for financial consolidation and reporting.
• Worked extensively in Data consolidation and harmonization
• 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, MS-SQL, UNIX, SAS, Mainframe, DB Visualizer, OLAP, MS Office, VB.NET, PeopleSoft CRM, Oracle Hyperion, PL/SQL, and Putty

Confidential

Business System analyst

Responsibilities:

• Analyzed the customer behaviors on Confidential website.
• Analyzed different versions of the site and the traffic for each month, quarter and year.
• Generated weekly, monthly, and quarterly reports necessary in maintaining a good and balanced financial statement.
• Graphical representation of the reports using MS Power Point Presentation and MS Excel Charts.
• Coordinated with several managers in linking information and data within the financial departments.
• Involved in user trainings during system upgrades and enchantments.
• Compiled reports such as Marketing reports, Brand reports and branch reports
• Creating SQL files indexes and calculated the table spaces for each table, tuning the SQL queries (based on the plan tables).Grant and revoke table access to users.
• Created Tables, Indexes, Views, Snapshots, Database links to see the information extracted from SQL Files.

Environment: Oracle, Toad, MS PowerPoint, MS Excel.