PROFESSIONAL SUMMARY:

• Over 10 years of comprehensive and versatile exposure in Data warehousing and around 8 years of expertise in IT Industry Development and Implementation of Data Warehouse applications in Finance, Retail, Manufacturing and Telecommunications domains.
• Knowledge of data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimensions tables, physical and logical data modeling OLAP and Report delivery methodologies.
• Performed analysis of Business and system requirements including impact analysis of existing systems and create design specifications with the consultation of Business users and technical architects.
• Familiar with Logical Data Model and Physical Database design.
• Strong hands on experience using Teradata utilities (SQL, Macros, B - TEQ, Fast Load, MultiLoad, FastExport, Tpump,).
• Designed ETLs using BTEQ scripts and conducted review meetings to implement BTEQ and Bulk load jobs.
• Familiar in Creating Secondary indexes, and join indexes in Teradata
• Created business reports by writing complex SQL queries using views, macros, volatile and global temporary tables
• Using Teradata manager PMON utilities to monitor and improve performance.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics
• Created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases
• Experience in Automating and Scheduling the Teradata SQL Scripts in UNIX using Korn Shell scripting.
• Proficient in Design and Development of process required to Extract, Transform, Load data to the data warehouse using Informatica PowerCenter 9.x/8.x/7.x/6.x.
• Experience in using webservices to extract XML/XSD sources using webservices call.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and SQL transformation.
• Implemented various Performance tuning techniques on Sources, Targets, Mappings and Workflows in all versions of Informatica.
• Working knowledge on different data sources as Flat files, Oracle, Teradata, SQL Server, XML and Excel files.
• Knowledge in Informatica Data Explorer ( IDE) and Informatica Data Quality (IDQ) tools.
• Involved in Unit Test Case, Integration Test, User Acceptance Test (UAT) preparation and testing of the applications.
• Expertise in developing SQL and PL/SQL codes through various procedures, functions, triggers and packages to implement the business logics of data base in Oracle
• Experience in writing, testing, and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL.
• Experienced on File Transferring from Windows Server to UNIX using UNIX FTP Commands
• Strong Experience in working on MS Access, MS Excel and MS Power Point
• Good experience in Production Support, Identifying root causes, Trouble shooting and Submitting Change Controls
• Automated and scheduled the Informatica jobs using Control and Work Load Manager
• Highly organized and detail-oriented professional with strong business and technical skills.

TECHNICAL SKILLS:

RDBMS: Teradata12, 13 Oracle 8i,9i,10g,11g, MS-Access, SQL Server 2006,2008

ETL Tools: Informatica 6.x, 7.x, 8.x, 9.x (Powercenter client, IDE, IDQ, web services), ODI 11g

OLAP Tools: Business Objects 5.1,6 OBIEE Negril

Languages: SQL, PL/SQL, VB6.0, HTML, C, Java

Operating Systems: Windows 98/NT/2000/XP, UNIX

Others: TOAD, SQL developer, SQL Assistant, Control M

PROFESSIONAL EXPERIENCE:

Confidential - Richmond, VA

Senior ETL Developer / Technical Lead

Responsibilities:

• Playing tech lead role and owns the accountability of all the technical deliverables.
• Participated in the due diligence phase of requirements gathering, scope determination and translating the business requirements into technical requirements.
• Performed detailed Data Analysis to identify data sources, data gaps, redundancies & anomalies.
• Involved in detailed analysis of the downstream/upstream dependencies of the legacy warehouse.
• Involved in effort estimation for the requirements for the project.
• Co-ordinate with all the business users, SMEs and process owners to complete the activities of SDLC phases.
• Worked TEMPeffectively with Business Analysts and Project managers for assigned tasks and deliverable timelines.
• Created spreadsheets as user interface for the business users to confirm on the data required for migration.
• Documented the data analysis in the excel pivot summary of data availability to the business SMEs.
• Maintained data validations in the excels charts and tables.
• Used various excel functionalities like vlookup, sorting, filtering during the analysis phase.
• Designed simple and complex mappings using Informatica Powercenter to load the data from various heterogeneous sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Normalizer, SQL, Rank and Router transformations.
• Created sessions, event tasks, decision tasks and workflows using powercenter
• Used Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, FastLoad, Multi Load, Fast Export, Tpump on UNIX/Windows environments and running the batch process for Teradata.
• Created UNIX shell script to FTP flat files from different systems to the ETL server
• Responsible for QA migration and Production Deployment.
• Schedule the Informatica Jobs through WLM
• Used debugger in debugging some critical mapping by setting breakpoints and trouble shot the issues by checking sessions and workflow logs Created and maintained various project related documents like high level design documents.
• Used informatica IDE and IDQ for data profiling.
• Processed XML files using informatica webservices.
• Compared the data from two data sources for finding the gaps.
• Created reusable transformations and mapplet and used with various mappings
• Participated in the Integration testing and Unit Testing along with the Development team. Performance tuning of sources, targets, mappings and SQL queries in the transformations
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Ensure 24*7 availability of PRODUCTION environment.
• TEMPEffectively monitored weekly and monthly production jobs and solved the issues related to their abort state.
• Responsible for INDIANA and SC state’s encounter submission process.
• Monitoring and fixing the issues related to the tasks related to the submission process.
• Automated the manual steps involved in production jobs.
• Reviewed the deliverables of peer group

Environment: Informatica 9.1, IDE and IDQ webservices, Microsoft SQL Server 2008, UNIX, Flat Files, Teradata 13, Workload Manager (WLM), Control - M, Tivoli

Confidential - Plano, TX

Lead-Senior Software Developer

Responsibilities:

• Participated in sessions with Business SMEs in understanding the source applications both from Business and Technical Aspect. The Data included both from internal application systems and data files procured from external vendors.
• Worked close with Data Modelers to understand and verify required tables, fields and data in different schemas and databases.
• Created the list of activities and objects for development in the excel.
• Captured the business transformation logic applying excel functions for validation.
• Maintained the tracker of work breakdown in the form using excels sub totals and array functions.
• Captured the result of runtime of one load against the no. of runs required for the history loads using the excel formulas.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings
• Designed the ETL process for extracting data from heterogeneous source systems, transform and load into Teradata warehouse
• Extracted data from various source systems like Oracle and flat files as per the requirements and loaded it to Teradata using FASTLOAD, TPUMP and MLOAD
• Extensively used key transformations like source qualifier, aggregator, filter, joiner, Update Strategy, Unconnected and connected Lookups, Router, Sequence Generator, normalizer and SQL transformation.
• Used informatica mapping debugger in debugging some critical mapping by setting breakpoints and trouble shot the issues by checking sessions and workflow logs.
• Created reusable transformations, sessions and worklets in the workflows.
• Informatica maps reads the webservices input and fetches the service data and provides the output to the SMG data as WSDL/XMLS which will be provided to the business users in the intranet business portal.
• Developed web services workflows using informatica
• Created UNIX shell scripts and called them as pre session and post session commands
• Validated the OLAP data warehouse data with BOBJ reports
• Performed bulk data load from multiple data source (ORACLE 9i, SQL Server and Flat files) to TERADATA RDBMS using Fastload, Multiload and TPump.
• Created macros in TERADATA SQL Assistant for populating the stage tables.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Wrote complex macros in Teradata to capture Confidential websites traffic data key metrics.
• Created UNIX shell scripts and called them as pre session and post session commands.
• Task assignment and monitoring the work progress of a 6 member team
• Prepared and Executed the Test Cases during Unit testing and provided extensive support to QA in System, Regression and UAT (user acceptance testing) and deployment of mappings.
• Worked with the EST lead in activities related to code migration from development to test environment.
• Involved in Confidential ’s deployment process for code migration. Follow Change Management Control processes, CAB & CRRB Checklist for deployment
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.
• Prepared training materials and presented to both the operational and Business teams.
• Reviewed documents like STM (Source to Target mappings) with Data Analyst, Test Plans with EST, and Production Support documents with the Maintenance Team.
• Configured sessions in a job and scheduled them through control - m job scheduler
• Worked in a time boxed environment and the team completed all deliverables including code and documentations on or before the timeline, in all three phases of this project.

Environment: Informatica 8.6.1/9.5 webservices, UNIX, Oracle 11g, Microsoft SQL Server 2008, Flat Files, Teradata 13/12, Control M

Confidential

Senior Applications Developer

Responsibilities:

• Owned the responsibility of creating ETL for OBIA Supply Chain Management SCM procurement data model.
• Analyzed Oracle eBiz Applications for purchasing module and converted functional requirements to technical requirements.
• Data Analysis and validations are captured in the excels .
• Detailed pivot summary tables of purchasing attributes are documented.
• Analyzed new functional/reporting requirements and worked closely with the various application teams and business teams to understand and design the ETL procedures for the new release.
• Participated in meetings and functional/technical trainings required for the OBIA Fusion release. Acquired knowledge of the supply chain management business domain and oracle’s EBS applications.
• Worked on the Bug fixing of the earlier 796x releases using Oracle Data Integrator (ODI).
• Analysed logical and physical design requirements for the purchasing facts and dimensions.
• Implemented physical and logical (BMM Layer) rpd design for purchasing facts, dimensions and new reporting metrics using Oracle Business Intelligence Enterprise Edition (OBIEE).
• Created SDE (Source Dependent Extracts) mappings using informatica powercenter transformations to populate stage tables.
• Developed SILO (Source Independent Loads) mappings using MAPGEN utility to load the purchasing fact and dimension tables as per requirement for the Negril version.
• Ensured the reporting layer design is tested whenever there is a new build for OBIEE.
• Prepare test cases based on functional scenarios and generate sample test case reports.
• Documented extensively all the design considerations as per Oracle corporate standards.
• Used Oracle DAC for configuring the schedule of the execution plan.
• Reviewed code of team member.
• Verification of functional specifications and review of deliverables.

Environment: Informatica 8.6.1, MAPGEN, Oracle 11g, Oracle Data Integrator (ODI) 11g, Oracle Business Intelligence Enterprise Edition (OBIEE) negril version, Oracle Business Intelligence Applications- OBIA, - Datawarehouse Administration Control DAC Windows XP.

Confidential

Senior Software Developer

Responsibilities:

• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design
• Contributed in the design activities and assisted in analyzing the tool feasibility (Informatica) for business requirements.
• Created dynamic excel reports creating links where users need to key in the respective geography and the reports are automatically refreshed based on the current data.
• Used the excel functionality to connect to the database from excel.
• Worked on Informatica Power Center and created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Used extensively Source qualifier, Aggregators, lookups, Filters & Sequence generators.
• Created sessions and batches to move data at specific intervals & on demand using Workflow Manager.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Followed Informatica recommendations, methodologies and best practices.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Worked closely in setting up the environment for various file transfer activities between the systems using SFTP as the file transfer protocol.
• Developed PLSQL procedures for the business requirements.
• Document the entire ETL process and testing.

Environment: Informatica 8.6.1, Oracle 10g, unix.

Confidential

Senior Software Developer

Responsibilities:

• Understanding the source system and project architecture.
• Analyze the business requirements, existing systems & participate in internal team meetings to determine actions for the respective assignment.
• Designed, Developed and tested Informatica Mappings, Transformations, Mapplets, Sessions, Tasks, Workflows, Worklets, SQL queries to implement complex business rules.
• Designed reusable objects like mapplets & re-usable transformations in Informatica PowerCenter 8.5.1/7.1.
• Most of the transformations were used like the Source Qualifier, Aggregator, Lookup, Router, Filter, Sequence Generator, Expression, Joiner and Update Strategy.
• Created Parameter files and validation scripts
• Created complex SQL queries are used for data retrieval.
• Used SQL ANALYTIC functions like lag, lead for calculating the time between the different statuses in their source applications.
• Involved in the system testing and documentation of the ETL development design and testing.

Environment: Informatica 8.1.1, Oracle 10g, SQL, PL/SQL, TOAD, Windows XP

Confidential

Team Lead Global Data Warehouse

Responsibilities:

• Understanding the source system and architecture.
• Design and development of ETL specifications and code.
• Development of PL/SQL procedure for KRAs as per the business requirements.
• Coordinating with the offshore team during the project tenure
• Creation of test plan, test strategy and test approach.
• Created Test scripts, Traceability Matrix and mapped the requirements to the test cases
• Used HP quality centre for testing
• Involved in the system integration testing.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures
• Used oracle explain plan feature to identify the query execution cost and tuned the queries based on the oracle optimize plan for good query performance
• Involved in identifying the performance Bottlenecks on source, target, mapping, session and successfully tuned them to increase session performance as wells as Oracle views.
• Interaction with various other teams for setting up of servers and databases
• Task assignment and monitoring the work progress of a 3 member ETL development team
• Assist project manager in estimation, planning, tracking schedule, team management, change management and other life cycle processes

Environment: Informatica 8.1.1, Oracle 10g, SQL PLSQL, Business Objects5.x, Autosys, Windows XP

Confidential

Senior Software Engineer

Responsibilities:

• Understanding the source system and architecture.
• Involved in the ETL Design as per business requirements.
• Transformed the business requirements into high level technical requirements.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Expressions, update strategy, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using TOAD.
• Created file extracts to the downstream application and business users as reports.
• Prepared unit test cases, conduct unit testing and generate test case reports.
• Prepared a detailed design document on the flow of the requirements and proposed solution.

Environment: Informatica 7.1.1, Oracle 10g/9i, TOAD, SQL,PLS/SQL