SUMMARY

• 9+ Years of experience in information technology in Designing, Development and Implementation of Data Warehouse and Data Marts
• Extensively used Informatica Power Center 9.X and 8.X for extraction, transformation and loading
• Worked on Netezza, Redshift, Teradata MPP systems and EPIC, Oracle & SQL server data bases
• Worked on Credit Bureau, e - Commerce, Health Care & Insurance, Telecommunication & Banking domains
• Worked on teh whole SDLC in various projects
• Good noledge on modeling, ETL, BI DWH modules
• Good noledge on Star and Snow Flake Schema
• Extensively used Java, Transaction & SQL transformation to process Unstructured data and to make teh ETL processes dynamic and used expression, Lookup, Joiner, Router, Filter, Aggregator, Update Strategy, Normalizer, Rank, Sequence Generator transformations for daily routine jobs
• Extensively worked on mappings, mapplets, sessions(reusable and non reusable),workflows and worklets
• Built several ETL control processes like File Control Process, ETL Params etc
• Good experience on Informatica DVO for testing
• Worked on both Unix and Window informatica Servers
• Good at Unix and windows dos scripting
• Good noledge of OLTP and OLAP systems
• Good noledge of ETL standards and used advanced features of informatica like pre and post variable assignment, passing mapping variables from one mapping to different mapping wifout using parameter file and running workflows concurrently wif different parameter files to achieve some complex tasks
• Mainly worked on S3, Salesforce, EPIC legacy systems
• Worked on Informatica Power Exchange for Salesforce
• Good experience wif web services and online storage systems
• Good experience in informatica admin work like informatica installation, deployments, user & folder creation and assigning teh privileges
• Facilitated scrum meetings for gathering teh requirements and prepared teh design review document using informatica visio
• Good noledge on debugging and performance tuning
• Worked on-call and production support
• Closely worked wif BI team in preparing teh dashboards
• Have undertaken several DBA work like vacuuming, creating databases and other objects in DB and backing up teh objects
• Very good communication skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x,8.x Informatica Power Exchange for salesforce, DVO

Appliances & Database systems: Netezza, Redshift, Oracle, EPIC, SQL Server and Teradata

Legacy Systems: Salesforce, S3, EPIC, Flat files both fixed width and dsv, Unstructured files, XML files, Cobol files, SQL Server and Oracle databases

Third party Tools: SQL Workbench, WINSCP, Aginity workbench, WinSQL, SQL Developer, Core FTP, Toad, Erwin, putty

Scripting: Unix Shell Scripting, Windows DOS scripting

BI Suites: OBIEE, Cognos, Business objects, Ms Access Reports

PROFESSIONAL EXPERIENCE

Confidential, Costa Mesa, CA

Senior DWH Developer

Responsibilities:

• Used Informatica 9.5 and Netezza Twinfin’s as ETL tool and target appliance respectively
• Adobe, Credit.Com, SQL server 2008 and XML’s are teh legacy system’s
• Several stored procs are converted into informatica code
• Worked extensively on Java, Transaction & SQL transformations to load unstructured data and to make teh ETL processes dynamic
• Loaded teh XML files which has no DTD and unparsed incoming data
• Built a ETL control process to dynamically validate teh XML files and parse it automatically
• Closely worked wif business to gather teh requirements and prepared teh design review documentation using informatica visio
• Good practice in choosing teh right distribution key
• Used Informatica DVO for unit testing
• Prepared several shell scripts to automate teh load, file validation and maintenance
• Performed teh tuning especially teh one’s wif transaction control transformation
• Worked on several enhancements on dis ongoing project
• Completely worked on one SDLC
• Star Schema has been used in teh data modeling
• Deployments are done to QA & PROD environments
• Closely worked wif Cognos developer to pull teh reports
• Closely worked wif QA to perform testing in QA environment
• Worked on-call and prod support
• All teh process flow has been documented and uploaded to share point

Environment: Informatica 9.5, Netezza, SQL Server 2008, UNIX, DVO, putty, Aginity workbench, WINSCP, Cognos

Confidential, Pasadena, CA

Senior DWH Developer

Responsibilities:

• Facilitated scrum meeting to gather teh requirements from teh business
• EPIC & Oracle 10g are teh main legacy systems
• Informatica 9.1 is used as teh ETL tool.
• Extensively used Netezza bulk writer to load huge table wifout any performance issues
• NZSQL & NZLOAD are used to load few one time tables from SAS
• Extensively used Java transformation to perform data cleansing and data type conversion wifout using expression transformation
• Well trained on Clarity system
• All teh dimensions are maintained as type-2 and fact as type-1
• Closely worked wif Web dev team to prepare teh interface
• Extensively worked on mapping variables, parameters, pre and post variable assignment to make teh mappings generic
• Written several windows dos scripts to perform file maintenance and automation
• Unit test cases has been prepared for teh developed code and tested before any migration
• All teh process flow and test cases are documented mainly using Informatica visio

Environment: Informatica 9.1, Netezza, EPIC, Oracle 10g, WINSCP, Aginity Workbench, SQL Developer

Confidential, Seattle, WA

Database Engineer

Responsibilities:

• Salesforce and Oracle 10g are teh main legacy systems
• Informatica power exchange for salesforce is used to load salesforce entities
• Amazon proprietary appliance RedShift is used as teh target
• Systemmodstamp and Prone Duration are used to pull teh delta load
• S3 buckets are used as online storage and intermediate layer before loading teh data to RedShift
• S3cmd tool has been used to upload teh file to S3 buckets
• Transaction Control Transformation has been extensively used to generate teh target files dynamically based on teh incoming source count
• Encountered several performance issues while loading teh data from S3 buckets to RedShift and successfully rectified all of them
• Used workbench for SOQL Query
• Created different clusters and performed admin work like vacuuming
• Prepared an ETL control process called ETL load stats which gives teh stats about all teh load and any performance issue’s
• Unit tested all teh code and migrated to different environments and documented all teh test cases

Environment: Informatica 9.1, Redshift, Salesforce, Informatica Power Exchange,S3, Oracle 10g, OBIEE, Unix, SQL workbench, SQL Developer, Putty, WINSCP

Confidential, Madison, WI

Senior DWH Developer

Responsibilities:

• Gatheird teh requirements from teh business and performed teh gap analysis
• SQL server and several flat files are teh main legacy systems
• Informatica 8.6 is used to perform ETL
• Prepared teh design review doc using Informatica visio
• Written WINSCP scripts to get teh files from SFTP server
• Star schema is used for teh data model
• To maintain teh history of teh patient visits almost all teh entities are maintained as type-2
• All teh code has been unit tested and documented all teh test cases
• Worked on informatica administration work like creating teh repositories, user & folder creation and assigning teh privileges
• All teh process flow’s has been documented and uploaded to share point
• Closely worked wif BI team in preparing teh dashboards

Environment: Informatica 8.6, Oracle 10g, SQL Server, Qlikview, WINSCP, SQL Developer, Core FTP

Confidential, Madison, WI

Datawarehouse Developer

Responsibilities:

• Adobe and Oracle 10g are teh main legacy systems
• Informatica and Teradata are used as ETL tool and target respectively
• Several stored procs are converted into informatica code
• Closely worked wif adobe to understand how teh ads information can be consumed from adobe
• All teh ads information is gatheird using Adobe
• Closely worked wif Cognos developers to pull teh reports
• Teh developed code has been unit tested and documented teh test cases
• Performed teh code deployments to different environments
• Closely worked wif QA to test teh deployed code in QA
• Performance tuning has been achieved at both session and mapping level

Environment: Informatica, Teradata, Oracle 10g, Adobe, Cognos, SQL developer, UNIX

Confidential

Web Dev

Responsibilities:

• Developed web pages using ASP.NET
• Used SQL Server as teh backend database
• Written several stored procs and tuned it
• Performed teh database admin work like database creation and database maintenance

Environment: ASP .NET, SQL Server, SQL Developer