SUMMARY

• 8+ experience with expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools.
• Strong technical experience in SDLC including requirement gathering, development, debugging, deployment, documentation and production support.
• Adept at all phases of SDLC, which includes Design, Analysis, Coding, Testing, Code Reviews, Implementation and System
• Good knowledge of Relational Databases like SQL Server, Oracle, DB2,Teradata.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Datamodeling using Erwin and SQL Server Enterprise manager.
• Good understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Experience in multidimensional modeling and RDBMS concepts using Star Schema and Snow - Flake Schema.
• Well-versed in developing Mappings-Sessions using Informatica Components like Power Center, Workflow Manager, Workflow Monitor, Repository Manager.
• Strong Experience on Performance Tuning (source, target, sessions, transformations) and Power Analyser, Data Mart.
• Used Unix Shell scripts to write pmcmd commands to automate workflows.
• Worked on COGNOZ Cube queries- Drill Through reports, CRYSTAL report queries as part of BI environment.

TECHNICAL SKILLS

BI Tools: SSIS, Informatica 9.1.1/9.5.1 , Cognos 8.4/10, BX 4.1

Databases: MS SQL Server 2008/2005, Oracle 11i/10g, DB2 10.1,Teradata 13

Operating Systems: Microsoft 7/XP/2000/NT, UNIX

Data Modelling: ERWIN, Microsoft Visio

Tools: SQL developer, PL-SQL developer,Toad, Benthic,Jira-Jama

PROFESSIONAL EXPERIENCE

Confidential, PA

ETL CONSULTANT

Responsibilities:

• Responsible for forward and reverse engineering to create and modify existing database model
• Implemented complex business logic using complex T-SQL queries.
• Created operational staging tables for conversion purpose to cleaning the data while converting from old system to new system.
• Documented and prepared project status report updates.
• Tuned SQL queries using execution plans for better performance.
• Validated data by creating various validation queries for each table.
• Created statistical mappings for further skewing of data.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Responsible for elevating and automating successful code to production environment.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Identified the database tables for defining the queries and flow through ODS - ETL and defined datasets for report generation.

ENVIRONMENT: Informatica 9.5.1, DB2 10.5, ERWIN, BX 4.1, Windows Server 2010, JAVA, SQL Developer

Confidential

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Carried thorough validation of database model and designed ETL architecture.
• Automated crucial NCANDS reports and PSA reports for federal purpose.
• Worked on data integrity to maintain accurate and sensible reports.
• Involved in creating jobs and alerts and scheduling it on daily, weekly and monthly bases.
• Verified reports created on weekly basis and held technical meetings to reduce inappropriate data.
• Created back up tables to hold in experimented data.
• Used sql transformations to get various counts.
• Conducted validations on data and sent requests to DBA’s for loading cleaned data.
• Documented and prepared project status report updates and audit reports.
• Created complex Mappings using union, xml, lookup, router, aggregator, sorter and sql transformations.
• Define match rules, columns for match and merge process.
• Data Cleansing, De-duping and Address correction were performed incorporating MDM.
• Deployed packages, folders and Reports from a development environment to Testing environment and Production environment.

ENVIRONMENT: Windows Server 2010, Informatica 9.5.1,MDM, Cognos 8.4, Oracle 11i, Microsoft Visual Studio 2005, Erwin, PL-SQL Developer, Unix.

Confidential

Responsibilities:

• Participated in gathering phase, attended meetings with clients.
• Used Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Creating logical and physical design models.
• Applied modifications back and forth according to the meetings.
• Review reports to determine basic characteristics - origin, report flow, format, frequency, distribution, purpose by generating Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Cognos.
• Assist reporting team with sources and mock up reports and validations.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using Power Analyzer.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Created logical and Physical database design, data structures, primary key, foreign key and implemented large databases using Erwin.
• Provided back-end support for functional testing and performance testing.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Responsible for elevating and automating successful code to production environment.

ENVIRONMENT: MS SQL Server 2005, Informatica 9.5.1, Cognos 8.4, Oracle 11i, Microsoft Visual Studio 2005, Erwin, PL-SQL Developer, Windows XP, MS Office, MS Access.

Confidential

Responsibilities:

• Played a pivotal role in requirement gathering with users, meeting various representatives from different Program Offices.
• Developed and maintained a combined data store for reporting purposes.
• Working on data integrity project to maintain accurate and sensible reports.
• Rewrote various business process and tested result in MS Excel,SQL using various functions and sub queries
• Involved in the analysis, design, development and handled modifications, shaping and re-designing of progress of the project.
• Designed and altered structures for production tables.
• Created parameter files to assist the staging as well as ODS load process.
• Built mapping’s from report queries.
• Involved in creating jobs and alerts and scheduling it on daily, weekly and monthly bases.
• Involved in updating functional requirement document after development and created documentation for deployment team.
• Loaded data warehouse in both development and production environments.
• Documented all the developments and enhancements during project for future references.
• Applied analytical sql concepts to obtain desired results through mappings.
• Implemented thorough changes throughout mapping designs to retrieve accurate results to be sent to application team.
• Part of performing intensive testing programs.
• Used Teradata’s BTEQ, FLOAD, MLOAD and Sql Assistant for data testing, analysis and loading.
• Created batch sessions and workflows to load production and other schemas making it available for other projects.

ENVIRONMENT: SQL Server 2005,Teradata 13, Windows Server 2010, Informatica 9.5.1, Cognos 8.4, Oracle 11i, Microsoft Visual Studio 2005, Erwin, SQL Developer, C#, .Net 2.0, SQL Server Profiler, SSRS, SSIS

Confidential

Responsibilities:

• Collect files from various county representatives of that division to group data and work on it.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Run monthly loads and generated daily, weekly and monthly reports for the managers.
• Close interaction with users to send, receive and discuss updates on data.
• Maintain record of anomalies if found and turn it in during meetings.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP.
• Performed unit testing and system testing to test validity of data.
• Development ofBTEQ /FAST LOAD /MULTILOADscript for loading purpose.
• Developed SQL scripts for validating data from monthly load process.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Created filters within the Model for improving performance of the Run.
• Worked with complex mappings to update the logic used for the EDW load process

ENVIRONMENT: Informatica power centre 9.1.1, Oracle 10g/11i, Cognos 8.4,Teradata 13, VB.NET 3.5, SQL Server 2005Benthic, PL-SQL Developer, Erwin

Confidential

Responsibilities:

• Developed ETL strategy based on the data model design and different subject areas which conformed to the set of business requirements.
• Worked on developing the ETL design of data marts based on changing requirements.
• Implemented the database in Oracle and applied necessary performance tuning techniques for optimum performance.
• Tested the reports and fixed bugs in the queries.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• WroteBTEQ scriptsto run complex queries .
• Involved in the analysis, design, development, testing, deployment and used complex expressions to calculate, group, filter, parameterize, and format the contents of the transactional reporting system.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones and tuned them such that they perform well.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Design and run SQL scripts for validating data from load’s with cognoz reports.
• Employing tables defined by other projects from different schemas to deliver data for users.
• Created various design documents such as detailed system design (DSD), source to target document.
• Screenshot details document to ease the development process

ENVIRONMENT: Windows Server 2010, Informatica 9.1.1, Cognos 8.4, Teradata 13,Microsoft Visual Studio 2005, Erwin, SQL Developer,VB.Net, C#, .Net Framework 3.5,, MS Visio, MS Access 2003, VB.Net, Oracle 8i/9i.

Confidential

Responsibilities:

• Worked on data marts to created and generate new reports for Business usability.
• Migrated mappings to higher environments in EDW.
• Involved in provider modifications and work out complete packages for loss mitigation for various purposes based on the requirements.
• Created SCD’s using Informatica power center.
• Extracting data from different servers of business partners
• Generate and Test Adhoc and operational Reports for collections and loss mitigations Reports like Audit Reports for Collections in SQL Report Builder using SSRS.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Worked on tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Datamodels, Transaction logs.
• Checked over cube queries and made changes to it to do data validations in reports.
• Created new initiatives that can support the client’s new requests.
• Worked on warranty Program change requests in timely limit to make the schedule run on time.
• Researched and fixed mappings and sessions as to why their run time exceeds more than a day.
• Wrote sql queries for obtaining data in combinations of various environments based on report query logic.

ENVIRONMENT: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, Erwin, T-SQL, Windows XP.Informatica power centre 9.1.1, Oracle 10g, VB.NET 3.5, SQL Server 2005, Benthic, SSRS.

Confidential

ETL DEVELOPER

Responsibilities:

• Developed workflows and dataflows using business logic.
• Importing metadata from various sources flat files, xml and sql server.
• Created workflows and data flows in data integrator.
• Created the mappings using transformations such as the source qualifier, aggregator, expression,lookup, router, filter, joiner and update strategy.
• Used for workflow manager for creating and maintaining the sessions, monitor, edit, schedule copy, abort and delete the session.
• Generated completion messages and status reports using workflow manager.
• Interacted with the business analyst and the manager in gather the business requirements to design and Develop reports.
• Involved in installation, configuration and deployment of Informatica suite.
• Created mapping document for the source components to the data base.
• Created mappings, session, workflows and handled daily /weekly loads.
• Validated queries of different types of reports, such as master/detail, cross tab and chart. Modifying the existing

ENVIRONMENT: Informatica Power Center 8.1, Informatica Power Analyzer, Mainframe,DB2, Erwin, TOAD, Business Objects XI, SQL Developer, windows NT/XP, Db2, flat files, xml files and windows 2000.

Confidential

DATAWAREHOUSE DEVELOPER

Responsibilities:

• Analyzed the existing system,informaticacode and business standards.
• Understanding the existing system and customer requirements.
• Analyzing the issues if any in data loading/ database and communicate with the concerned person to resolve the issue.
• Created (entity relationship) diagrams, function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Erwin.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Gathered and translated business requirements pertaining to online automation into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Consulted with core team on new data definitions and other extensions to the existing strategies.
• Effectively involved in functional and technical documentation for report development as per Business needs.
• Created use cases to depict the interaction between the various modules of the system.
• Involved in user acceptance testing to ensure customer satisfaction.

ENVIRONMENT: Erwin, Oracle 8i, Windows 2000, MS Access, PL/SQL.