PROFILE:

• Overall 7 years of IT experience on Data Warehousing
• Having extensive experience in Datastage development, ETL, Big Data (Hive and Impala), BI (COGNOS and OBIEE).
• Handson experience on Cognos cubes, DMR Modelling, Adhoc Reports, Report Studio, Analysis Studio .
• Functional experience on Guidewire Claim Center .
• Ability to understand, analyse, design and develop as per the customer s requirements.
• Expertise in validating the report functionality by generating reports through query studio in Cognos by writing complex SQLs at the backend.
• Worked on creating and loading data into Hadoop HDFS external tables and developed sql's on Hive and Impala editors using Hue UI .
• Knowledge on Cognos report functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Functions, Cascading Prompts and User Defined Objects.
• Proficient knowledge of Datastage designer, Datastage director, Datastage Administration, Autosys, ETL Testing,Informatica Power Center and Unix shell scripting.
• Have written efficient SQL scripts to test various stages of the data flow to the warehouse by understanding the critical business requirements implementing various transformations.
• Performed data Validations and have written SQL scripts to test CDC, Classification and TDQ (Technical Data Quality).
• Good understanding on the principles of Data warehousing, Dimensional modeling and extensive experience in Entire Life Cycle of the projects.
• Good domain knowledge on Banking, Insurance and Financial Domain.
• Excellent problem solving skills and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Received three weeks technical training on Infosphere MDM by IBM Software Group.
• Received extensive classroom training on IBM Cognos Analytics ( v11.0 )

SKILLS:

ETLTools: Datastage 11.3,Datastage 8.1, Informatica 8.6

BI Tools: Cognos 10.2 / 11.1

DB Used: Oracle, Db2,Teradata

Languages: Core Java, SQL

O/S: Windows Server, UNIX/LINUX

Scheduling Tools: Autosys

Others: Master Data Management(MDM),Hadoop, Hive, Impala, HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, Ohio

BI/ETL Analyst

Environment: Cognos 10.2/11.6, Teradata

Responsibilities:

• Involved in Data Analysis which includes understanding end to end functionality and Data models used as per business requirement.
• Perform detailed Functional/Requirement Analysis on mapping so as to ensure that technical and business aspects are in sync.
• Act as an interface between offshore and business counterparts to gain more functional/domain knowledge.
• Responsible for effective communication between the project team and the customer.
• Updating day to day status in order to ensure that deliverables are on right track.
• Involve in Coding, Performance tuning, rectification of bugs, change requests and participate in all phases of testing - System testing, System Integration testing, User Acceptance testing and Regression Testing.
• Involve in peer to peer review in team.
• Gained in depth knowledge on database, marts, warehouse and how views/helpers are built on top of warehouse to support reporting .
• Actively participating in all client calls and meetings and gather more information relevant to project.
• Testing of the application to ensure that the client requirements have been taken care of and without affecting the existing functionality

Confidential, Charlotte, NC

ETL Developer

Environment: Informatica, Datastage, Teradata

Responsibilities:

• Analyze the requirement specifications.
• Responsible for the offshore deliverables and update the client for the daily status progress details.
• Responsible for development and testing of the process and support during production.
• Involve in Different reviews like Internal and external code review, weekly status callsissue resolution meetings and onsite code acceptance meeting.
• To write queries to test the functionality of the code during testing process.
• Used hierarchical stage while designing Jobs processing XML data .
• Coordinate with other teams and among team during test execution and defect resolution.
• Creating documents for the task assigned illustrating the flow and the logic used.
• Extensive knowledge and use of Scheduling tool like Autosys.
• Worked on the UNIX shell scripts for the automation of different processes and for archival of files
• Responsible for migration of code in lower environments as well in production and to support till the warranty period.
• Worked on creating and loading data into Hadoop HDFS external tables using Hadoop scripts and beeline commands and developed sql's on Hive and Impala editors using Hue UI.

Environment: Teradata,Oracle

Tools: Used: Data stage, UNIX, Autosys, Star Team

Hadoop Ecosystem: HDFS,Hive

Confidential

ETL & BI Tester

Environment: Datastage, Teradata, OBIEE

Responsibilities:

• Understanding database design schemas for different sources and targets and end user business requirements.
• Developing and modifying the scripts by looking into the mappings, according to business logic.
• Having good knowledge on Data Warehousing and ETL concepts, was able to understand the End to End flow which helped in execution process.
• Was involved in Report testing i.e. OBIEE report Testing by understanding the detailed business functionality of the reports.
• Having a clear understanding of existing Business Requirements.
• Interacting with the client for requirement gathering and clearing the issues both on business and technical perspective and going ahead with the task.
• Maintaining query logs and regular follow - ups with clients to resolve the open queries.
• Preparation of TIDs and KT Summary Documents during the transition phase.
• Involved in giving playback sessions during the transition phase.

Environment: Teradata.

Tools: Used: Informatica, Data stage, UNIX

Confidential

ETL Tester

Environment: DB2, Data stage

Responsibilities:

• My responsibilities as part of this project are to understand the mapping requirements, various subject areas used in the data model and in - detail concepts of data ware housing which are implemented in the project and write test cases (SQL scripts) to test whether the data is moved as per the business requirement to target or not.
• I was very pro-active in doing mapping analysis and debugging the issue during execution and have also detected several mapping issues in semantic layer.
• Analysis of data from different source systems which are on different platforms is a challenging task and I have written queries based on the analysis and have also raised many critical high priority defects during execution.
• I was also part of Test Data (Intelligent Data) creation team and also helped COGNOS team in our project to validate reports.
• Writing the SQL queries and execute them in SQL Developer and compare the results as part of System Testing.
• As part of unit testing - covered different scenarios in the report and ensured that report is as expected for different prompt selection criteria.
• Validated the cognos reports by writing queries against DB and comparing the data with the report data generated through query studio.
• Also helped development team in loading files and executing jobs in Data stage and try debugging the issue when job fails.
• Maintained Good Interaction with development team to resolve the issues.
• Performed File Validation, Data Validation, CDC, TDQ and classification check.
• Have performed End to End ETL Testing including various stages like Smoke Test, Primary Key Validation Test, Duplicate Key Validation, Attribute Testing, TDQ, CDC Check and Classification Check.

Technical Environment: Db2.

Tools: Used: DataStage, UNIX.