SUMMARY:

• Over 13 Years of experience in IT industry with 10 Years of strong Experience in Design, development of ETL applications.
• Designed and developed data marts using star schema dimensional modeling.
• Expertise in E - R modeling, Dimensional modeling developing Database Schemas like 3NF, Star schema and Snowflake schema.
• Strong experience with Fact and Dimensional tables and worked extensively with slowly changing Dimension.
• Created ETL applications using Informatica, Aptitude Accounting Hub and Data Integrator.
• Fine tuned ETL Mappings, ETL workflows for optimal performance.
• Experience In Various RDBMS Databases (Teradata, Oracle, MSSQL Server and MS Access).
• Extensively Worked On Teradata including Teradata utilities MLOAD, FASTLOAD and Teradata Utilities (MLOAD AND FASTLOAD).
• Developed PL/SQL procedures, views, Materialized views.
• Performed IMPACT Analysis for Change Control for an Existing System.
• Experience in Informatica administration.
• Experience and handled the Versioning and Labeling in INFORMATICA.
• Extensively Worked on Version control (HARVEST Tool) to Create, Update, Modify (SQL Views and Procedures) to deploy ENV to ENV to maintain Versions.
• Strong Work Experience in Creating UNIX and LINUX Shell Scripts to Perform Automated Mailing Tasks, Concatenate, Splitting, File Transfers.
• Work Experience in MAINNFRAME ENV for checking status of jobs, archival of files.
• Experience in Creating Change Requests (CR) based on Requirements using Clear Quest.
• Strong Knowledge in SDLC, Data Warehousing Concepts and RDBMS Normalization Technique.
• Worked with Business Associates to Gather the Requirements, Understands the Business Flow and translating them into Design and Technical Requirements.
• Experience in Creating/ Submitting ESP JOB names based on Dependencies
• Experience as Data mover to set up Complete Test data for TEST and QA ENV to perform (UNIT, SYSTEM and INTIGRATION TESTING) .
• Experience in Writing the Preliminary Design, Detail Design, Mapping Document, Unit Test Case, Unit Test and Production Turnover Document to Maintain the Business Requirement History.
• Experience Document Presentations to Various Teams / Departments (Development, Testing and Production).
• Installed and Configured the Repository Power Center 7.1.4 on Windows Server.
• Expereinced in Agile Software development using Scrum.
• Created Business Objects Universes and Reports usng Business Objects XI R2.

PROFESSIONAL EXPERIENCE:

SENIOR ETL DEVELOPER

Confidential

• Working on revenue subledger project.
• Involved in the functional specification.
• Aptitude account hub configuration
• Designed the inbound process for reference data and transaction data
• Created edf's, data objects, microflows
• Created external call formats.
• Built procedures using AAH DB Clarity.
• Performed validations and enrichments.
• Designed the outbound process for the BI.
• Guided new aptitude developers and created reference document for new developers.
• Completed tasks ahead of the sprints.

Environment: Aptitude Accounting Hub (AAH4), Teradata 15, UNIX, Accurev, Rally

ETL Architect

Confidential, Denver,CO

• Implemented Agent scheduling tool IEX upgrade from 3.X to 4.6 on the ETL side.
• Analyzed existing systems, processes for changes and recommendations.
• Communicated system processes and architecture to business and technical teams.
• Evaluated design for the IEX Upgrade changes.
• Maintained list of reusable objects and created new reusable objects.
• Worked with developers for design changes and new implementations.
• Provided impact analysis for source system changes.
• Unix is used widely for file transfers and error handling.
• Monitored Autosys jobs and guided production operations team in resolving Autosys Job failures
• Created Service Desk tickets using Unicenter Service Desk.
• Teradata utilities Fastload and Mload are extensively used.
• Used Teradata view point to monitor queries.
• Fine-tuned slow running Teradata SQL queries.
• Presided and provided many process improvements.

Environment: Informatica 9.5, Teradata 14, UNIX (Korn), Autosys, Unicenter SD.

Data Architect

Confidential, Pittsburgh, PA

• Collaborated with teams and other stakeholders to assess business and system requirements to develop and implement scalable EDW solution that meets current and future needs.
• Lead Data warehouse Dimensional Modeling efforts including defining the Data Model Design and Naming standards from the Database to the BI Layer to ensure consistency
• Participated in the design, development, documentation and application of best practices and procedures that govern EDW implementations and operations.
• Documented and diagram the proposed solutions to present to management, IT groups and project stakeholders. Prepare functional specifications and data dictionaries.
• Participated in the resolution of complex performance issues or enterprise failures involving critical business processes. Help to provide root cause analysis and recommend solutions.
• Provide technical mentoring, guidance, and training to EDW support and user teams throughout the organization.
• Built EDW applications to pull inpatient and outpatient claims, processing medical claims for different regions.
• Created application views for Teradata databases which involved processing of millions of rows of data.
• Created Change requests using clear quest workbench
• Created detail design documents .

Environment: Erwin 7.2, Teradata 12, Clear Quest 7, Harvest CM 7.1,Unix

Confidential, Dallas, TX

Informatica Lead/Developer Various Clients

• Analysis of EBS systems and Design and development of data mart for aftermarket project.
• Involved in the design of EDW and ETL solutions.
• Integrated data from 11 different source systems including Oracle EBS .
• Extensively used oracle partitions to load 7 source systems.
• Used oracle bitmap indexing for improve query performance
• Created Informatica maps, workflows with decision task, email and session tasks.
• Used Informatica performance techniques to decrease the load times.
• Designed and developed the file handling from the ftp server.
• Created customer master data from different geographic regions.
• Responsible for Informatica administration tasks.
• Setup informatica on Windows environment, created users, backed up repository
• Created sql packages, procedures, cursors.
• Created ad hoc reports in Business Objects.
• Prepared test cases for testing the complete application
• Tested the Business Object’s Universe and created reports
• Extracted data from salesforce.com by creating Salesforce mappings. nvolved in the modeling of the data mart using dimensional modeling techniques.
• Created new joins, Pre Defined Filters in the Designer and added them in the right contexts, Resolved loops in universes using Aliases and Contexts.
• Created new Deski reports and Webi reports as per user requirements
• Redesigned and created new Informatica mappings to fit new business demands.
• Implemented SCD methodology including Type 1 and Type 2

Environment: Informatica 9.X/8.*, Oracle 11g/9i, SQL Server, Oracle EBS11, Windows 2008 64 Bit,MDM Erwin, Pl/SQL, Unix/Linux, Business Objects XI R2, MS Visio, Teradata, BTEQ, Fast Load,DB2

Confidential

Lead Lab Technician

• Responsible for taking care of hard ware and application issues of computers in the student labs, assist students in labs, guide junior technicians

Confidential

Manager Genaral Admin and Member of Technical Staff

• Reduced the costs of hardware purchases by utilizing multiple vendors.
• Developed PL/SQL Procedures and fine tuned SQL queries, for faster data retrieval.
• Performed System admin activities like in server installations and taping backups.

Environment: Windows 98, NT, Unix, Oracle 7.1, Visual Basic