Data Developer
Resume:
MOHAMMED ***.
Informatica Architect/Developer
********.***@*****.***
I have over eight years of experience in the IT fields of Design and
development, maintenance in Informatica, PL/SQL, SQL Server, and DB2. I
have extensive technical knowledge using and supporting enterprise wide
IT applications in various industries. As an ETL Developer
(Informatica) for the past six years, I have worked on Data warehouse.
On Data marts I have very profound knowledge and experience in the
areas of capturing requirements, working experience on modeling star
schema and snowflake schema methodologies and performing Extract
Transformation and Load process. I had an experience of Database
Development Oracle, the cutting technologies.
Summary of Experience:
* Six plus years of as Data warehouse (ETL) Informatica Developer.
* Excellent experience in designing the Star and snowflake models for
Data Warehouse.
* Expertise use in Informatica Data Exchange and Data Transfer tool B2B
DX/DT.
* Experience with complex mappings using transformations like
Expressions, Aggregators, Routers, Joiners, Rank, Sorter, Stored
Procedure, Lookups, Sequence Generator and Update Strategy.
* Experience in designing of Dimension modeling, star schema, and
snowflake schema
* Working experience of to identify and normalize the modeling in Fact,
and Dimensions.
* Expertise in Oracle PL/SQL program and performance tuning
* Strong in developing cognos reports
* Experience on create the Architecture in both ways top down approach
and bottom up.
* Monitors and tunes ETL repository and system for performance
improvements
* Oracle performance tuning and query optimization techniques.
* Good in preparing documentation and test plans, unit testing
experiences.
* Experience in creating Sessions, Workflows, and Worklets by using the
Workflow Manager tools like Task Developer, Worklet and Workflow
Designer.
* Used Data Exchange tool informatica to use typical data transfer.
* Experience in integration of various data sources like Oracle, SQL
Server, MS-Access, Flat Files and XML Files into staging area.
* Hands on experience with performance tuning, and using query
Optimization Techniques in SQL Server.
* Expertise with using Change Data Capture (CDC) technique for easy and
fast updates.
* Experienced with full life cycle and Methodology for implementing Data
warehouse and Business Intelligence Reporting system with Cognos.
* Good experience with table partitioning in SQL Server and using
partitioning Techniques in Informatica.
* Developed Low Level Design at mapping level Architecture as per
Business requirement.
* Experience in working on slowly changing dimension SCD type II to fast
updates.
* Hands on experience of complete life cycle, SDLC (Software development
life cycle) .
* Experienced with full life cycle and Methodology for implementing Data
warehouse and Business Intelligence Reporting system.
* Writing Stored Procedure, functions, create Indexes, synonyms, views.
* Self-motivated and possess ability for critical thinking, analysis,
good interpersonal and communication skills. Team-oriented,
technically motivated and creative. User oriented with a desire to
learn client's business requirements. Excellent communication skills,
management and leadership qualities.
* Strong Experience in Oracle 10g/9i/8i, MS SQL Server 2000/2005, DB2,
MS Access, MS Excel, SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored
Procedures, Triggers.
* Experience in UNIX Shell Scripting, Job Scheduling on Multiple
platforms like Windows NT/2003, UNIX, Linux.
Education qualifications
Master in Computer Applications - India.
Certifications
. Oracle Certified Associates. OCA.
. Database Administrator Oracle - Interface Academy- Hyderabad.
. Post Graduate Diploma in Computer Application- India.
Experience of Summery:
Client Period Position Domain
BCBSM 04/2009 - till date Informatica Health Care
Architect
HRD State, TN 10/2007 - 04/2009 ETL Designer Mental Health
program
Credit Suisse First 08/2005 - 10/2007 Informatica Financial
Boston, New York, Developer & Investment
NY
HUMANA -KY 09/2003 - 10/2005 Informatica Health Care
Developer
Stockx IN 06/ 2002 - 08/ 2003 Oracle Stock agents
Developer
T E C H N O L O G I E S:
ETL : Informatica Power Center, 8.6/8.1/7.2
Databases : Oracle 9i, 10g, 11g, SQL Server 2000/2005, UDB DB2,
Sybase, MS.Access
Reporting Tool : Cognos Report net 8.1, and BI Series, Business
Objects, Crystal Report.SSRS
Data Warehouse : Star Schema, Snowflake Schema, EDW, Data Marts.
Programming Language : C#, Visual Basic, JAVA, UNIX, Shell Scripting.
Tools: : Rational Rose, Toad, Win Sql, Erwin, VISIO. SQL *
Plus.
Web Technology : ASP.net C#, V.B. JAVA, DHTML, HTML, Java Script,
XML, VBScript, Shell Script, Perl Script. PL/SQL
Scheduling Tools: : Crontab, Autosys.
Operating System: : Windows NT/XP/2000/2003/2007 HP-Unix/11.0/11.1 Sun
Solaris 7.0/8.0, Linux (Fedora)8.0/9.0.
Professional Experience:
BCBSM- MI April-2009 to till
date
Informatica Architect.
This is the system to integrate all the information through the various
applications at one level from all applications databases we will put
together at on EDW, operational data sources are DB2, XML, SQL Server and
vsam files also. Target data bases are Oracle10g.
Responsibilities:
. Create/Modify Informatica ETL mappings in various stages folders like
Staging area, Mirror area and production area for development and
production environment that transfers data from SQL Server, Flat
files, as ODS target data was Oracle to the Mart (Oracle Target
system).
. Experience in Design and Development ETL mappings.
.
. Hands on experience working with EDW modeling like star schema,
snowflake schema.
. Expedite experience on update strategy, and slowly changing
dimensions.
. Used SCD Type II to get accuracy of data in updated method.
. Used working with Data modeling, physical, logical and conventional
. Hands on experience to co-ordination with off-shore team.
. Developed cross tab reports, Child and Master detailed reports
. Using Stored procedures, Triggers and cursors with SQL queries
. Used SQL Queries and Optimization techniques and performance tuning on
Oracle.
. Expert in using XML Generate transformation, transfer data in XML
file.
. Used aggregator, lookup, expression, stored procedure, filter in the
mapping.
. Extensively used incremental update and CDC methods to load the data.
Power Exchange.
. To increase the performance through identify the bottleneck methods.
. Used Advanced Transformations like stored procedure, unconnected,
Transformations
. Created Task (Sessions) using Task Developer.
. Used BI tool Cognos report net to generate the reports.
. MS xl data and non format data convert into the XML through the Power
Exchange Transformation.
. Used Mapping Parameter files and Session Parameter files.
. Conducted brainstorm session meeting with the off-shore team.
. Good experience in white box testing.
. Good experience working with Informatica Power Exchange.
. Used performance tuning techniques is Parallelism, created indexes,
partitions and SQL hints also.
. Hands on experience in Transaction Control Transformation. TCL
. Used XML Qualifier Transformation to generate the flatfiles,
. Job Schedulers like Cron tab, Autosys.
. Hands on experience with W.H. Inmon DWH methodologies
. Used Constraint based load technique (CBL) as advance transformations.
. Hands on experience of Incremental update Techniques used.
. Reading Workflow Log Files, Session Log Files.
. Working experience with multiple targets and performance tuning
experience.
Environment: Informatica Power center 8.6/7.2 Informatica, Cognos 8.1,
Oracle 10g, SQL Server 2005, Crontab, JAVA, J2EE, DB2 Toad, UNIX, Shell
scripting
HRD, Chattanooga TN Oct-2007 to
April2009
ETL Developer.
This Project is basically to enhancement of DWH working EDW, Data Marts.
The Analysis Team requirement Provides bundled record keeping of all type
of customer information. Enterprise level Data Scrubbing, Data Quality, and
Data Acquisition. Created process for loading of data from various OLTP
systems to ODS (Operational Data store) Sybase and MS Acess finally into
EDW through data mart using Informatica ETL Tool.
Responsibilities:
. Created Informatica ETL Mappings that transfers data from internal
source systems to Oracle.
. Used Update Strategy, Sorter, Joiner, Source qualifier, Router in the
mapping.
. Monitor Workflows and Tasks using Workflow Monitor.
. Writing queries in SQL for checking the Source and Target Tables Row
Count.
. Create Reusable Transformations, alter or override default query in
source qualifier.
. Created target flat file for unit testing.
. Dealing with the very large database on EDW.
. Created Dynamic parameter files through mapping variable for workflow.
. Design ETL Mappings as the requirement.
. Experience with Data warehouse with all methodologies star schema and
snowflake schema.
. Used BI Tool to generate typical reports SSRS.
. Hands on with Performance tuning.
. Faster execution of SQL query on windows environment
. Extensively expertise on Developing Mapplets.
. Hands on experience to write Stored procedures, Triggers.
. Working experience on Mapping Variables,
. Wrote multiple SQL Queries to retrieve the PL/SQL data.
. Expertise on create Session parameters.
. Experience to generate the Drilldown, master details report through
Cognos.
. Bottom-up approaches architecture we have, Ralph Kimball's concept.
. Sources, Targets, Mappings, Sessions and optimized mappings and
sessions.
. Written documentation to describe program development, logic, coding,
testing, changes and corrections.
. Automated ETL jobs using Informatica batches and Pre-Session and Post-
Session UNIX scripts, JOB scheduler with Crontab.
. Used Workflow Manager for creating and maintaining the Sessions and
Workflow Monitor to monitor, edit, schedule, copy, abort and delete
the session.
Environment: Informatica 8.1/7.2, ORACLE 9i, PL/SQL Sybase, DB2, Oracle
9i, SQL* Loader, Winsql.
Credit Suisse First Boston, New York, NY
Aug 2005 to Oct 2007
ETL Developer
IT Answer Base is a web based intra asset management system that stores all
its technology assets like infrastructure, storage, databases, end-user
technology etc. It gives the flexibility to navigate between users,
applications, databases, assets and locations and how they all relate to
each other.
IT Cost Transparency: It provides the management with informed decisions
about consumption of technology infrastructure services. Data is then used
to feed the financial transparency invoice creation process in a fixed
share percentage per department.
Responsibilities:
. Involved in designing the process for getting the data from all
systems to Data Warehousing system.
. Performed major role in understanding the business requirements and
designing and loading data into data warehouse (ETL).
. Collection of data source information from all the legacy systems
and existing data stores.
. Imported various Application Sources, created Targets and
Transformations.
. Involved in Data Extraction, Transformation and Loading from source
systems to ODS.
. Developed complex mappings using multiple sources and targets in
different databases XL, MS Access, flat and XML files.
. Stored procedures and Triggers.
. Hands on experience with user acceptance testing UAT.
. Designer in Workflow manager and monitored the results in Workflow
monitor.
. Extensively used SQL queries to implement the type 2 changes.
. Actively participated in the performance of Informatica Mappings.
. Used DTS Packages to migrate the data from one db to another Data
marts.
Environment: Informatica 7.2.Oracle9i, Toad, Cognos impromptu TOAD,
ASP.net C#, Shell.
HUMANA -KY Sept 2003 Aug
2005
Database Developer
This project was developed for Customer Data Information. It is used for
the purpose of analysis the claim information from customer usages and used
for agencies selling of various plans to customers and review it between
Agencies and customers spread across different cities in USA. It provides
the most cost-effective and easy method for communication customers through
various offers to compete through various analogy, on the Internet.
Responsibilities:
. Involved in the Design, modeling in the Database.
. Developed coding using SQL and PL/SQL.
. Experience with performance tuning and testing.
. Developed PL/SQL procedures, functions, packages, objects, and
triggers for inserting, updating, retrieving and validating of
data.
. Created database links to access data from various other databases
in the organization.
. Developed test scripts on the procedures, functions and packages
before putting them into production.
. Excellent work through with query optimization and SQL performance
Tuning.
. Created views on the tables for generating reports based on the
user requirements.
. Involved in production support of the application by reforming the
existing PL/SQL Objects
. Data base connectivity provided by OLE-DB Providers. Created Stored
Procedures and triggers to perform automated rules, updating to
related tables using Oracle.
Environment: Oracle 9i, TOAD, Sql * Loader, ASP.net C#, Shell scripting,
PL/SQL, SQL
STOCKX - INDIA
June 2002 to April 2003
Database Developer
This is the maintenance project here the reports regarding the
securities traded every day will be generated by the STOCK-ex
application.
Our objective is to convert the reports into the flat files of
specified format and scheduling the tasks of loading flat files into
database. We have to fix any run-time errors at the time of loading,
if the errors are out of our knowledge or scope like insufficient
space in the table etc, are to be intimated to the concerned people to
fix and we have to reschedule the loading tasks again.
Responsibilities:
. Designed the database for entire system by creating database objects
like Tables, Views, Synonyms, Sequences and Indexes. Written packages,
triggers, stored procedure and functions for the following modules
products, catalogue, billing, shipping, rejected material, purchase
orders and material receipts.
. Loaded traffic data logs into staging tables using SQL loader and
shell scripts
. PL/SQL coding for Exception Handling and duplicate data maintenance
. Developed PL /SQL code for updating payment terms.
. Implemented the code involved in modifying the database records using
nested queries and PL/SQL routines.
. Writing shell programming to convert the reports into flat files.
. Scheduling the job of loading using Crontab program
. Developed SQL Loader and PL/SQL program units using oracle UTL_FILE
package for extracting and loading data.
Environment: Oracle 8i, Sql * Loader, UNIX, Shell script, Winsql, Autosys.
Contact this candidate