Summary of Qualifications:

• Over 17 years of IT experience, which includes 10+ years of data modeling and ETL development using Informatica 9.5.1/8.x/7.x/6.x/5.x, 1 year of business Objects and 5 + years of Visual Basic.
• Experience in complete life cycle of an Enterprise Data warehouse
• Expertise in implementing complex Business rules by creating robust mappings/mapplets, shortcuts, reusable transformations, User defined functions and Partitioning Sessions
• Developed standards for Informatica/Data Integrator development, code reviews, and migration methodologies
• Extensive knowledge of performance tuning techniques for Informatica and Data Integrator
• Used multiple RDBMS including Oracle 8i/9i/10/11, Teradata SQL Server and MS Access
• Worked with different Data sources ranging from flat files, Oracle, SQL server, Teradata databases
• Hands on experience in Star and Snow flake schema design and De - normalization techniques
• Well versed with Data warehousing concepts such as Design, Development and Extraction of data
• Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process

COMPUTER SKILLS:

ETL tools: Informatica Power Center 9.5.1/8.1.1/7. x/6.x…

Reporting Tools : Business Objects XI, 5.1, 4.0, Web Intelligence, Crystal Reports

Data modeling tools: ERWIN 3.x, 4.0; Oracle Designer 2000

GUI: Visual Basic 6, 5, 4; API, COM, ActiveX, VBA, VBScript

RDBMS: Teradata, Oracle 9i, 8i, 8x, 7x; MS SQL Server, Sybase

Languages: Korn shell, SQL, PL/SQL

Operating Systems: Solaris, Compaq Tru64, AIX, LINUX, HP-UX Windows XP/ 2003/2000/98/95/ NT

EMPLOYMENT HISTORY:

Confidential, Virginia

Sr Informatica Developer/Informatica Admin

• Was part of the team during the upgrade from 8.6.x to 9.5.1.
• Worked on following projects
• NFTS(convert SQL code to Informatica).(Lead Developer)
• Files Mart(2nd iteration of NFTS)(Lead Developer)
• C3 Consolidation
• C3 Benefits Mart
• VSS(Canadian Visa)(Lead Developer)
• Created complex mappings and reusable code for the common shared dimensions across all applications.
• Worked on implementing a very sophisticated parameterization of the entire ETL code.
• Deploy the code to different environments.
• Provided guidance to my peer developers.
• Tune the mappings to enhance the performance by considering various options (use DB lookup or Informatica lookups/ use dynamic lookups vs lookup cache, weather to use the join conditions in the Source qualifier or the joiner transformation ……)

Confidential, 

Virginia,

Data Warehouse ETL Developer

• Was part of the team during the upgrade from 7.1 to 8.1.1.
• Sources: flat files, tables (My SQL, SQL Server, Oracle) & XML files.
• Target: Teradata, Oracle
• Participated in the Software Development Lifecycle and created the Software Development Plan
• Involved in full life cycle development including design, ETL strategy, troubleshooting and reporting
• Performed data cleansing and transformation using Power Center/Power Mart
• Worked extensively on Normalizer, sorter, Expression, Lookup (connected and unconnected) Sequence, Update Strategy, Filter, Joiner, Router, Expression, and Aggregate Transformations.
• Created Mapplet input, Mapplet output transformations, reusable transformation, reusable tasks and Worklets
• Created and scheduled workflow with the following tasks: command, decision tree, email, event wait and timer.
• Shell scripts to notify the operations team to notify failure in job failures.
• Wrote SQL stored procedures to create temp tables on the source DB for ETL process.
• I have documented all of the initiatives that were assigned to me. I have documented the requirements, design and the Technical ETL process.
• Worked with QA to create the test plan and provide the test cases to be tested.

Confidential 

Washington D.C., Data Warehouse Architect

• Installed Business objects XI on a cluster environment for DCStat.
• Created objects such as dimension and fact tables and sequences
• Involved in analysis, design and development of the Enterprise Data Warehouse.
• Involved in the detailed design of STAR Schema Dimensional Model using Erwin 4.0.
• Installed and configured all Business Objects modules (Supervisor, Designer & Business Objects) and created Repository.
• Extensively used Business Objects clients - Supervisor, Designer & Business Objects and scheduled the actions like Refreshment and Distribution of Documents, using Broad Cast Agent.
• Developed Universes using the Business Objects Designer and connected to the Database using ODBC.
• Used Designer Module to Create prompts and queries, applied Aliases to remove cyclic Loops
• Created Cardinalities, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Linked one Universe to another in Business Objects Designer to incorporate Inheritance.
• Created reports for the users on a regular and ad-hoc basis using Business Objects and WebI, which were used by the Managers to take key decisions.
• Used Aggregate Awareness feature of Business Object Universe for better performance and smooth execution of BO reports.
• Extensively used BO & WebI reporting functionality such as Slice and Dice, Sorting, Hierarchies, Drill Down, Drill up, Filter, Calculation, Report Layout, Prompts, Tabular, Cross-Tabular, Bar-Chart reports, Aggregates, formatting, Scheduling of Jobs for full client reports for Performing OLAP on the generated reports.
• Worked with multiple Data Providers (Universes, stored procedures and personal data files) in a report.
• Developed BO Reports and published on the Web under Corporate Documents folder.
• Worked on Web Intelligence in developing and publishing thin client reports.
• Define Sets by grouping your business data using highly visual step-wise queries.
• Define key Metrics you want to track over time, and perform advanced time series analysis.
• Define Business rules to automate actions based on conditions, define and publish alerts.
• Migration of Universes from development to Production environment.
• Worked on the hot fixes and production fixes on emergency basis and gave support to the users.
• Proficiently worked together with management as well as development team

Confidential

Washington D.C., Data Warehouse Developer

• Used Informatica 6.0/7.1, Oracle Designer, SQL, PL/SQL, Oracle 9i, Shell Scripts, Windows NT, PVCS
• Participated in the Software Development Lifecycle and created the Software Development Plan
• Involved in full life cycle development including design, ETL strategy, troubleshooting and reporting
• Dimensional modeling for the data marts using Oracle Designer
• Performed data cleansing and transformation using Power Center/Power Mart
• Identified the Slowly Changing Dimensions
• Implement business rules using Oracle procedures, packages, functions and triggers
• Designed, created and scheduled Korn shell scripts for various jobs and wrote scripts to generate the parameter files
• Created repository using Informatica Repository Manager
• Created objects such as dimension and fact tables and sequences
• Worked extensively on Lookup, Sequence, Update Strategy, Filter, Joiner, Router, Expression, and Aggregate Transformations in Informatica 6.0.
• Created Mapplet input, Mapplet output transformations, reusable transformation, Mapplets, reusable tasks and Worklets
• Used type coercion, string manipulations, arithmetic functions, aggregation
• Created and scheduled workflow with the following tasks: command, decision tree, email, event wait and timer
• Loaded the data warehouse using relational data and text files (fixed length, fixed width and comma delimited)
• Created a centralized metadata repository of all the applications
• Tuned Informatica for better performance
• Train the new employees in Informatica

Software Quality Assurance (SQA) Responsibilities:

• Performed SQA Audits to ensure that all applications are following the CMM standards
• Developed processes and procedures to facilitate learning CMM for the team
• Created, updated and maintained SQA processes, procedures and tools to support SQA planning, tracking, audits, reviews, reporting and training for each project
• Worked with project management team to coordinate SQA for the project, which included customizing the SQA activities and use of documented processes, procedures, and project compliance
• Ensured that quality methods, procedures, and standards were followed at each step in the software development life cycle
• Identified and provided training needs on SQA processes and procedures using standardized training material
• Worked with the SQA manager to define project-specific SQA activities
• Performed audits/reviews of project work products using the SQA plan
• Performed software baseline audits of the documentation against the new product baseline
• Reported SQA product activities and results to the SQA manager , along with evidence of use
• Sorted SQA audit work products in PVCS Dimensions
• Recommended activities to the SQA manager to improve the work products, including checklists and guidelines as a result of usage and lessons learned