SUMMARY

• 14 years of experience with design, Development, Production,Deployments,HIS implementation, Continuous integration,Continuous deployment and Clous Stack AWS in IT industry
• ETL strategy is documented accurately, then captured and documented detailed design specifications for the ETL process.
• Experience in DevOps implementation tools, AWS Cloud platform and its features.
• Extensively worked on Git, Maven, Jenkins, Docker, Puppet, Nagios tools.
• Regular status delivery updates to project manager and technical manager; consistently completed project elements on time, adhering to all strict project requirements.
• Expertise Informatica,Idr,Idq,Dvo,Autosys,PL/SQL, Shell scripting and HIS implementation
• Strong functional knowledge on Utility, Health Care, Telecom, HIS (Hospital information system).
• Used water fall & Agile methadologies.
• Experience in creating Transformations and mappings using Informatica Designer (Source Analyzer,Target Designer,Transformation Developer,Mapplet Designer,Mapping designer) and processing tasks using Workflow Manager to move data from multiple sources into target Data Base.
• Prepared check lists for every release and involved in reviews, Defect fixing.
• Experience in Performance tuning of targets, Sources, mapping and sessions.
• Good experience in writing SQL Queries using complex joins with sub queries and derived tables.
• Created database objects like Tables,Indexes,Constraints,Views,Trigger and Synonyms.
• Expert in writing PL/SQL stored/Stand alone procedures,Packages,Index,Functions,Triggers using Cursors and Exceptions.
• Involved in System Development Life Cycle (SDLC) from,analysis,design,code development,testing and maintenance.
• Ability to work independently as well as in a team with excellent written and verbal communications skills including experience in presentation creation.

TECHNICAL SKILLS

Data extraction Tools: Informatica,Dvo,Idr,Idq,Analyst

Cloud &devops: Aws, Git,Maven,Jenkins,Docker,Puppet,Nagios

Operating Systems: Windows, UNIX, LINUX

Database: Oracle, Sybase, Teradata, SqlServer,RedShift

Scheduling Tools: Tivoli,Autosys,Wlm,ControlM

Tools: Putty, Toad, HP Quality center, prism, Business objects, Erwin, Tortoise SVN,MKS

PROFESSIONAL EXPERIENCE

Confidential, Richmond,VA

Senior Developer

Responsibilities:

• Experience on AWScloudservices like EC2, S3, RDS, ELB, and EBS
• Creating S3 buckets and also managing policies for S3 buckets and Utilized S3 bucket
• Data loaded to Redshift with RDS service and loaded to S3 in the form of text file.
• ETL strategy is documented accurately, then captured and documented detailed design specifications for the ETL process.
• Worked with programmers and project managers and system analyst to create data flow for new features.
• Used Informatica various transformations based on the requirement.
• As a part of Data Quality effort performed large volume data conversion, data analysis, data cleansing and production report generation for a number of Data Marts
• Regular status delivery updates to project manager and technical manager; consistently completed project elements on time, adhering to all strict project requirements.
• Teradata utilities Mload,FastLoad,Bteq scripts are used to load data.
• Created stored procedures and queries to load data.
• Set up and maintained Control M job scheduling and production support.
• Involved in Detail design, Functional Mapping, Etl Mappings and development
• Jira tool used to capture the results as part of sprints.

Confidential, ST.Louis,MO

Lead Developer

Responsibilities:

• Extensive experience in Informatica development with good client management skill
• IDR used to replicate the initial Load data
• Audit method used for incremental data to get from the Logs which are available Confidential the mount point.
• Responsible for coding and modifications to enforce business rules and to improve performance of the system.
• Involved in Detail design, Functional Mapping, Etl Mappings, development, Client Software installation
• Extensively used Informatica client tools. The objective is to extract data stored in different databases such as, Oracle, flat files,JMS,Cobal files on a variety of sources to load into a single data warehouse repository, which is in Teradata
• Autosys and CAworkload(WCC) is used to schedule the jobs.
• Teradata view point is used to see the job running status and locking system.
• TPT connection and FastLoad, Mload utilities are used and Queries are embedded in Bteq
• Involved in Unit testing, data reconciliation for each feed and created Run Book.
• Bi temporal is used to store the data in teradata.
• Coordinate with other teams such as data modeling, testing, DBA's and mentor junior team members.
• Involved in production activities, Defect fixing and coordination with offshore team.
• PDO(Push down optimization)is used extensively for mappings.
• Used ETL transformations like Sorter Transformation, Aggregator Transformation, Normalizer Transformation, Source Qualifier Transformation, Joiner Transformation, Expression Transformation, Lookup (Cached, Un Cached and Persistent) and Sequence Generator to load data to Data marts.
• IDQ (Address doctor)is used to populate the address and geocodes.
• Extensively used IDQ developer and IDQ Analyst.
• Parser,Merge,Key - Generation,Match,exception,Decision,Case Converter tranformations are used for idq
• IDQ code is integrated to power center.

Confidential, Dayton, Ohio

Senior Software Engineer/Informatica& Dvo developer

Responsibilities:

• Lead the team for Dvo specific areas.
• Developed mappings, sessions and workflows based on requirement.
• Used various active, passive, Connected, Unconnected transformations to load data.
• Extensively used Pushdown optimization for performance.
• Created users and gave access permissions.
• Created short cuts for source and target strectures.
• Installed and configured Informatica, Dvo tools
• Extracted data from multiple files including csv, Xmlfiles.
• Extracted data from relational database applied business logic to load data to Teradata
• Created single table and table pair tests based on the requirements for validation of data
• Tests are added to check the value from source and target based on business logic.
• SqlViews are created to get data from multiple tables.
• LookupViews and JoinViews are created to match data from different sources.
• Different conditions are checked by creating the test scripts and parameterized.
• Folders are created and moved scripts from one user to another user.
• Reports are generated to track the status
• Generated tests from spread sheet.

Environment: InformaticaPowerCenter9.5.0,Dvo9.5.2,MicrosoftAccess,Teradata 13.10,SqlServer 2008 R2,Oracle11g,Windows and Quality center 11.00, Tortoise SVN 1.7.7

Confidential, Alpharetta, GA

Senior Software Engineer

Responsibilities:

• Responsible for Analysis, Design and Development of technical documentation.
• Lead the team and follow up's on the time lines
• Created source definitions, short cuts to objects using Power Center for Legacy systems.
• Involved in source analysis, Business requirement consolidation, design, and development and testing.
• Extracted data from multiple source systems including flat files, Teradata.
• Extensively used mapping and session parameters in ETL development..
• Extensively involved in performance tuning of the Informatica ETL mappings like increasing the caching size, overriding the existing SQL.
• Fine-tuning the loads by implementing bulk data load & used PL/SQL code.
• Created triggers on audit columns and oracle hints are used for performance.
• Used the command line program pmcmd to communicate with the Informatica Server.
• Made use of several features view the workflow log files and Session log files on the Informatica Server, which is on a Unix Server.
• Fast Export utility,Partitioning,sub partitioning,Less commit levels are used to increase the performance.
• Involved in Investigation of production issues and daily tasks to monitor workflows.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow
• Created mapplets,Worklets and reusable transformations that provide reusability
• Worked on performance issues and bottlenecks to reduce the load time and monitored the data loads.
• Work requests/estimates for internal/external clients.
• Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 8.6 to PowerCenter 9.1.

Environment: Informatica Power Center 9.1, Teradata,SqlServer,Oracle10g, PL/SQL, Windows XP, Unix and Quality center,Tivoli

Confidential, Atlanta,GA

Software Engineer

Responsibilities:

• Responsible for Analysis, Design and Development of Technical documentation.
• Created source definitions using Power Connect.
• Developed data mappings between source systems and warehouse components.
• Developed reusable Mapplets and Transformations.
• Created and monitored Workflows and sessions using Power Center Server.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Extensively used ETL to load data from flat files to Oracle database.
• Stored Procedure Transformation was used.
• Involved in analysis, Coding, testing, deployments and production support.
• Designed technical specifications.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplets, Transformations normal and reusable

Environment: Informatica 8.6.1, Teradata, Oracle, Unix

Confidential

Software Engineer

Responsibilities:

• Developed data mappings between source systems and targets.
• Developed lot of mappings, workflows and worklets..
• Involved in data extraction, Transform and Load from source to target system.
• Extensively worked with different transformations.
• Creation and modification of reusable transformtion.
• Testing the mappings, Workflow’s

Environment: Informatica 5.1, Unix, Sybase, SqlServer, Oracle

Confidential

Software Engineer

Responsibilities:

• Maintaining the modules Confidential site observing the user specific requirements.
• ERP applications and databases are used
• Training and implementing all the above modules Confidential site.
• Installation of Win9x, Oracle8 and Windows NT on PC’s.
• Analyze the work effort required to deploy the current application.
• Developed and designed Reports to meet the user needs.
• Add and modify all required Tables/Databases to support the requests from the System Analysts and the Systems Integrator and Provide daily Production Support for the operations of databases
• Involved in the project during analysis, design, coding stages and Defect raising. The system provides an excellent user interface
• Manual backup of server on day-to-day basis as well as Maintenance plan of database.
• Checking the size of Database.

Environment: VB, Windows 2000professional, SqlServer