SUMMARY:

• Six Plus 6 Years of experience working with databases using Oracle 11g/10g/9i, SQL, PL/SQL, Stored Procedures, TOAD, Explain Plan, TKPROF Functions, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, IBM Netezza 7.1.x, tera data 14.
• Four Plus 4 years of professional experience in Data Warehouse, Relational Database and System Integration. Proficiency in gathering and analyzing user requirements and translating them into business solutions. Worked for major HealthCare Health First , Financial Wangbangwaiqi and Education NY Department of Education Organizations.
• Four Plus 4 years of experience in System Analysis, Design and Development in the fields of Data warehouse, Database and Client server technologies. Worked in project areas - Installation, Repository configuration, Mapping, workflow, Data Architecture, Data Analysis, Data Quality Testing, Data Cleansing, Data Mapping and Data Migration.
• Four Plus 4 years of expertise in Extraction, Transformation and Loading ETL processes using Informatica Power Center Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer , Repository Manager, Repository Server, Workflow Manager Workflow Monitor, Informatica Power Analyzer, Power Exchange, Super Glue, Informatica Power Connect, Informatica Power Plug, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, ETI, DataMart, OLAP, OLTP, Mapplet, Transformations, Autosys, Control M, Maestro.
• Four Plus 4 Years of Data Modeling experience using Dimensional Data Modeling and Relational Data Modeling using, Star Join Schema/Snowflake modeling, FACT Dimensions tables, Physical logical data modeling, ERWIN 4.5/4.0/3.5, Oracle Designer, Visio, Proficient with Ralph Kimball and Bill Inmon Methodologies. Thorough understanding of database concepts and experience in E-R modeling, normalization of tables and in using development tools like ERWIN for forward/reverse engineering.
• Four Plus 4 years of Business Intelligence experience using Business Objects XI/6.5/6.0 Web-Intelligence 2.5, Designer 5.0, and Developer Suite Set Analyzer 2.0 , Cognos Series 7.0/6.0, MS Access Reports.
• Experience in working closely with Business Analysts, Data Modelers and Data Analyst/Test Analyst.
• Assist technical team to transform business requirements into technical specifications and formulating the Test Cases Test Scenarios.
• Excellent analytical skills. Exhibits great ability to grasp newer technologies.
• Effective team player with excellent communication skills.

TECHNICAL SKILLS:-

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in the Design, Analysis and Development of data warehouse using Informatica Power Center.
• Gathering requirements from subject matter experts SME's , Business Analysts and Data Analyst.
• Design ER diagram, logic model and physical database using the Ralph Kimball methodology.
• Designed and developed complex Informatica mappings including Type-II slowly changing dimensions using Power Center Designer.
• Developed Informatica mappings and workflows to meet the data migration, cleansing, integration needs and government regulation, using Informatica PowerCenter.
• Analyzed Mapping, Session, Source, Target and System Bottlenecks to improve and tuned Performance of various ETL Jobs.
• Use Unix Shell scripts to handle the ftp and processing of source files.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Migrated code from developer side to QA and production.
• Implemented performance tuning in mapping level by refining mapping logic and cache size.
• Applied session level performance tuning using pipeline partition and push up/down optimization.
• Wrote stored procedures Triggers which serve various purposes.
• Used SQL override in source qualifier, used Lookup override
• Load the data into Netezza database using powerexchange and netezza bulk load.
• Used Pre session and Post Session to send e-mail to various business users through Workflow Manager.
• Create workflow, apply sequential and concurrent batch for proper execution.
• Apply SQL override in lookup and source qualifier improves the efficiency of the mapping.
• Using debugger to identify the bugs and logical inconsistency.
• Properly created reusable transformation to simplify the mapping.
• Widely applied the usage of Shared folders, project folders Non-Shared folders and short cuts to maintain integrity between Development, Test, Data validation and Performance.
• Worked along with administrator in creating Users, shared folders and grant privileges to users in Repository Manager
• Fetched and Inspected log files in order to apply error handling and performance tuning.
• Set up repository server using admin console, mange repositories, folders and deployment groups using Power Center Repository Manger.
• Use UNIX shell crontab to schedule daily, weekly and monthly jobs.
• Worked with Parameters and Variables at mapping and session level.
• Use Informatica Data quality 9.0 to get rid of the duplicate records.
• Setup repository server based on business and data integration requirement.
• Introduced mapping variables in order to catch the incremental load.

Environment: Informatica Power Center 9.1, PL/SQL, Toad for Oracle, Oracle 11g, Netezza 7.1.0

Confidential

ETL Informatica Developer

Responsibilities:

• Gathering business requirement from Business Users, Business/Data Analysts
• Extracted data from Oracle, Flat Files, and XML and loaded them into teradata database through teradata load utility fast load, multiload, tpump .
• Developed Complex transformations, mapplets, using Informatica power center 9.10 to extract ,transform and load into data marts, EDW and ODS.
• Designed ER diagrams, logical model and physical database.
• Performed Type1 and Type2 mapping use Power Center Designer.
• Managed the Metadata associated with ETL processes.
• Used Informatica data quality to remove the duplicate records. Used debugger to test the mapping and fixed bugs.
• Created sessions, sequential and concurrent batches for proper execution of mapping.
• Applied performance tuning in mapping level by refining the logic and cache.
• Performance tuning in session level using pipeline partition and push down- push up.
• Created Workflows with worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Introduced mapping variables which serves as time stamps for delta load.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Session in the workflow manager.
• Molding data warehouse DataMart's in star schema.
• Migrated code from Development to Quality Assurance for testing.
• Involved in Migrating code from QA to Production for Pilot testing before going live.

Environment: Informatica Power Center 9.1, PL/SQL, Toad for Oracle, Oracle 10g, teradata 14.

Confidential

ETL Informatica developer

Responsibilities:

• Understanding the requirements from the BRDs and converting them to Technical Design Documents
• Load data from different department's into Oracle.
• Extracts data from homogeneous or heterogeneous data sources.
• Develop mapping in Informatica using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Developed detailed mapping specification documents to provide field level transformation logic.
• Worked with Data Modelers to understand the Data Model and assist in the ETL Design documents.
• Developed Informatica Jobs to load data into the Staging, ODS, Fact, and Dimension Tables.
• Implemented business logic in Power Center to accommodate the business rules.
• Responsible for Data Profiling and Data Cleansing.
• Analyzed, Designed and implemented stored procedures to Extract, Transform and Load data from external source to target.
• Created reusable logic to clean the data, which were used in several informatics jobs.
• Work with Project Management team to provide resource and effort estimates for ETL projects.
• Producing ETL mappings to translate/transform data from one system's structure to another.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Responsible for scheduling jobs use UNIX CRONTAB for Daily, Weekly, and Monthly Loading of Data into the Oracle Data warehouse.
• Design the control files for automation of migration process across environments
• Extensively used context Variables and global variables for the capturing delta loads
• Worked with slowly changing dimension components of Oracle DB - Type1, Type2.
• Worked with the BI Developers for report development using COGNOS.
• Involve in data cleaning in order to guarantee the consistence of the records.

Environment: Informatica Power Center 8.1, PL/SQL, Cignos, Crontab, Oracle, UNIX

Confidential

SQL developer

Responsibilities:

• Recognize the business requirement design proper schema, normalize the original table.
• Understand the businesses requirement, build schema, applying normalization.
• Create SQL objects including tables, views, indexes, triggers, packages.
• Ensure the code meet the company's standards and requirement.
• Work with the user interface designer to build a user friendly interface.
• Using Unix Shell Crontab scheduling and Oracle resource monitor each week and find the most resource intensive query and try to optimize that.
• Writing multiply stored procedures which serving the analysis purpose.
• Writing triggers to prevent mis-input and format inconsistence.
• Solving the problems when testing encountering the user input ambiguos.
• Document the database environment of the company.
• Maintaining the database by adding new business requirement and trouble shooting.
• Assist the client to setup the configuration.
• Created accessibility to different user group to keep the confidentiality.

Environment: PL/SQL, SQL, ORACLE 9g, Shell Scripting, Crontab, UNIX