SUMMARY

• 6 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in Data Modeling using Erwin in Client/Server and distribute applications development.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using ETL tools like Informatica.
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation and Load (ETL) of data from Legacy systems.
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000 / 7.0.
• Good experience in Data modeling using Star Schema and Snow Flake Schema.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Excellent logical, analytical, communication and inter- personnel skills with exceptional ability to learn new concepts / fast learner with complex systems and a good team player, problem solver and ability to perform Confidential high level to meet deadlines, adaptable to ever changing priorities.

TECHNICAL SKILLS

Data Modeling Tools: IBM Infosphere Data Architect, ERWIN, MySQL, MS Visio.

ETL Tools: Informatica.

Business Intelligence Tools: Cognos, MicroStrategy.

Languages: SQL, C#, VB.NET, XML, C, C++.

Planning tools: Oracle IOP, Hyperion.

Big Data Ecosystem: Cloudera Hadoop CDH4, MapReduce, HDFS, HiveQL.

Databases: Oracle 9i, 10g, DB2, SQL Server, MS Access.

Development Tools: Visual Studio 2008/2010, MS Excel.

Utilities: Oozie, Sqoop, Hbase, Flume.

PROFESSIONAL EXPERIENCE

Confidential, Wallingford, CT

SQL Developer/ETL Developer

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Tested several Cognos dashboards and deployed them across the organization to monitor the performance.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Was involved in setting up Cloudera Hadoop CDH4 Big Data Ecosystem via Cloudera Manager in a pseudo distributed mode and cluster mode as a POC.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Jira/Quality Center 9.0.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Teradata data warehouse
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Performed front-end testing on CIE Portal and Executive Dashboard portal.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).

Environment: Informatica PowerCenter, SQL Server 2005, TOAD, Oracle 11g, IBM DB2, Cognos, UNIX, Microsoft Visio 2003, Cloudera CDH4, HiveQL, MS Access, Flat Files.

Confidential, Harrisburg, PA

Sr. SQL Data Analyst

Responsibilities:

• Obtained the requirement specifications from the SME’s, Business Analysts in the BR, and SR meetings for corporate work place project. Interacted with the Business users to build the sample report layouts.
• Involved in writing the HLD’s along with the RTM’s tracing back to the corresponding BR’s and SR’s and reviewed them with the Business.
• Implementing an Enterprise level Transfer Pricing System to ensure tax efficient supply chains and achieve entity profit targets.
• IOP implementation involved understanding the Business requirements and solution design, translating the design into model construction, data loading using ETL logic, data validation and creating several custom reports as per the end user requirements.
• Extensive Reverse engineering, Data Modeling using IBM Infosphere data architect.
• Worked on Xml Stub’s integrating them with the Excel VB code and the backend DB.
• Preparation of IDP for the scheduled releases with the Developers and the Solution Architect.
• Deploying/Importing new Reports into IOP using the isa files from the command prompt.
• Designed Validation packages for the inbound data feeds coming in from different Divisions and scheduled jobs for regular data feeds coming from the Informatica ETL team.
• Informatica was used to extract/integrate data from different RDBMS systems into the staging tables.
• Designed Outbound Packages to dump IOP Processed data into the Out tables for the Data Warehouse and the Cognos BI team.
• Involved in Unit testing, System Integration testing and UAT post development.
• Provided End User training and configured reports in IOP.

Environment: SQl, Informatica, DB2, Infosphere, SQL Server 2000/2005, Oracle 10g, Teradata, XML, MS Access, WINSQL.

Sr. Data Quality Analyst/BI Analyst

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using IBM Infosphere data architect.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Created Sample BI reports with small subsets of data for SIT and UAT.
• Analyzed and tested various Business reports for Hierarchies, KPI’s, Aggregation, Conditions and Filters developed in Cognos.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing..

Environment: SQL, Cognos, Informatica Power Center 8x (Power Center Designer, workflow manager, workflow monitor), Infoshpere, SQL *Loader, Oracle9i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7.

Confidential, Bentonville, Arkansas

Sr SQL Data Analyst/Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Document and publish test results, troubleshoot and escalate issues
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, SQL, Informatica Power Center 6.1/7.1, Oracle 8i, Flat/CSV files.

Confidential

SQL DB2 Developer

Responsibilities:

• Obtained the requirement specifications from the Business Analysts for corporate work place project. Interacted with the Business users to build the sample report layouts.
• Developed SQL queries for the retrieval of Archived data.
• Designed and implemented the Data flow diagram using Visio and IBM Data Architect.
• Created Sql DDL’s and relationships between the tables.
• Used IBM DB2 as the staging database for the complex table structures in the secure OPTIM server.
• Data Migration from Oracle/Sql Server/Mainframe format to DB2 format.
• Used DB2 Import and EMS Data Import tool to import huge amounts of validated data into DB2.
• DB2 data load test, using DB2 control center to check loaded data and its count.
• Configured DB connections to DB2 via OPTIM Configuration tool.
• Defined Access definitions to archive the data using OPTIM tool.
• Created the Archive file for the applications with the loaded data.
• Tested the Archive file using OPTIM’s extraction methodology.
• Used Attunity Connect driver for establishing a connection to the Archive files.
• Tested the connection established through the Attunity via the SQL utility manager.
• Used MS Excel and MS Access as the reporting tool for the data to be returned via ODBC connections.
• Developed multiple GUI’s in some applications for complex querying and reporting.
• Performed system test on the GUI’s and the field names of the corresponding tables.
• Prepared Documents for the Archiving solution specification, Test conditions and Cases, User Guides.
• Performed UAT’s and Application handovers for the decommissioned applications.
• Demonstration of the completed application to the Users and the Testers.
• Performed various System test, stress test and data validation test.
• Designed, Developed, Tested and successfully handed over 6 decommissioned applications.

Environment: SQL, DB2, IBM OPTIM Integrated Data Management tool, IBM Data Studio, IBM Infosphere, EMS Data Import, Win Forms, XML Spy, MS Access, MS Excel, ER Studio, WinScp, Attunity Studio, ODBC data source administrator, SQL utility.