SUMMARY:

• Over 11+ years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Database and Data warehouse Software Applications
• Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development using modern programming languages.
• Strong Knowledge in Data Warehousing concepts
• 3+ years of experience using Informatica Power center 10.x/9.x, Data warehousing experience with Informatica cloud.
• Proficient in using Informatica PowerCenter tools Repository Manager, Designer, Workflow Manager, Workflow Monitor to create, schedule and control workflows, tasks, and sessions
• Actively
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling using Workflow Manager.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) to eliminate bottlenecks.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly Changing Dimensions.
• Experience in writing user guides, technical specifications and design documentation for application.
• Implement performance tuning on a variety of Informatica maps to improve their throughput.
• Developed Web Forms and Win Forms applications with .NET Framework 4.5/4.0/3.5 and Visual Studio 2012/2010/2008.
• Expertise in providing Business Integration and N tier Application solutions.
• Strong knowledge in JavaScript, HTML, CSS, and Angular JS.
• Experience in working with RDBMS database, MS SQL Server and Oracle.
• Experience in integration of various data sources Multiple Relational Databases like Oracle, SQL Server, MS Access, DB2 and Worked on integrating data from flat files, XML files.
• Possess Excellent Communication (both verbal and written) and Interpersonal skills
• Team player, Result - Oriented with strong Problem Solving skills
• Ability to adapt to new technologies quickly
• Ability to work under stringent deadlines with teams as well as individual.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.x/9.5/9.1

Middle Ware/Database: EDI/ DB2, MS SQL Server 2012, Oracle 11g, PL/SQL,T-SQL

Languages/Scripting languages: Cobol, CICS, HTML, CSS, Unix Shell Scripting

Scheduling: Control M, Autosys

Other Tool: MS Office, Service Now, Peregrine Service Center, JIRA

.Net Technologies: ASP.Net 3.0/3.5/4.0, C#, ADO.Net, MVC, WEB API, Web API

Web Technologies: Web Services, XML, SOAP, Angular JS,DOM, CSS, Java Script, HTML, AJAX, JQuery and JSON

Source Control: Visio, TFS and Git

Methodologies: Waterfall model, Agile

Data Modeling: E/R Modeling, Dimensional Modeling (Star, Snowflakes Schema Modeling).

Environment: Amazon cloud(AWS), Salesforce.com

EDI Tools/Standards: Axway B2Bi, IBM Websphere Data Interchange/ ANSI X12, EDIFACT

PROFESSIONAL EXPERIENCE:

Confidential - Herndon, VA

Environment: Informatica Power Center 10.x/9.x, Control-M, IDQ, Oracle11, SQL Server, Flat files, SQL, PL/SQL, Windows XP, UNIX Shell Scripts, Salesforce.com

ETL Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Worked with Informatica Cloud to create Source /Target connections, monitor and synchronize the data.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extracted data from various data sources such as Oracle, Flat file, XML.
• Worked with Informatica power exchange and Informatica cloud to integrate Salesforce and load the data from Salesforce to Oracle db.
• Provide oversight/consultancy to tenants for Salesforce Platform that are deploying new workloads/solutions and participate to architecture governance process.
• Develop and maintain controls on data quality, interoperability and sources to effectively manage corporate risk.
• Created and implemented ER models and dimensional models (star schemas).
• Involved in data cleansing and data profiling.
• Debugged mappings for failed sessions.
• Configured and ran the debugger from within the mapping designer to troubleshoot the mapping before normal run of the workflow
• Involved in Performance tuning for sources, targets, mappings, and sessions
• Involved in writing the Unit Test Cases and scripts for comparing source and target

Confidential - Kansas City, MO

Environment: Informatica 9.5.1, IDQ, Oracle11, SQL Server, Flat files, SQL, PL/SQL, Windows XP, UNIX Shell Scripts, T-SQL

ETL Developer

Responsibilities:

• Worked with business process owners, stakeholders to understand and document the requirements
• Provide architectural and technical leadership to improve and scale existing warehouse capabilities
• Interacted with the manager to understand the business requirements and implemented the business rules to design data flows
• Analyzed the data model to fit in ETL to load data, as this was already an ongoing process.
• Source system analysis and documentation of source-to-target mappings, data dictionaries and dB design.
• Extracted data from source systems like flat files as per the requirements and loaded it to Database based on requirements.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter
• Extensively used Mapping Variables & Parameters, Workflow Variables and Session Parameters
• Worked on troubleshooting the mappings to improve the performance by identifying bottlenecks
• Configured and ran the debugger from within the mapping designer to troubleshoot the mapping before normal run of the workflow
• Also used SQL override instead of lookup in order to improve performance by extracting data into staging
• Worked with Variables and Parameters in the mappings to pass the values between sessions
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor
• Involved in Performance tuning for sources, targets, mappings, and sessions
• Used workflow monitor to monitor the job, reviewed error logs that were generated for each session in the session log file, rectified the cause of failure and restarted them
• Involved in writing the Unit Test Cases and scripts for comparing source and target
• New understanding documents were prepared and modified the existing ones with changes for future reference.

Confidential - Kansas City, MO

Environment: HTML5, CSS3, AngularJs, Java Script, ASP.NET (3.5/4.0), C#, IIS, HTML, SQL Server 2012 R2, JavaScript, Visual Studio 2008/2010/2012, Web API, RESTful Service

.Net Developer

Responsibilities:

• Self-driven in agile methodology
• Designing and Coding of the Forms using Visual Studio.NET IDE
• Testing and debugging of the system.
• Database designing, wrote views, store procedures, functions and design patterns.
• Created Views and Indexes for improving performance
• Created DB links to access / modify the cross schema data.
• Extensively used ADO.NET for database connectivity. Datasets, Data Adapters are used.
• Involved in unit Testing, Debugging, Bug fixing, Performance Tuning, and Code optimization
• Used Team Foundation Server (TFS) 2010 for safe check out and check in of the files.
• Developed web pages for the application using Asp.Net MVC, Asp.Net Web API, JavaScript, CSS, HTML 5
• Used Master Pages to have a uniform template design for entire application.
• Used Linq to SQL queries to make changes to the entity sets.
• Web APIs designed in Restful services in .Net to facilitate vendors to access the HMK data.
• Created and consumed web services, Web API and REST services.
• Involved in Requirements gathering, design, coding, testing and documentation.
• Developer worked on coding, testing.
• Unit testing, integration testing and user acceptance testing

Confidential

Environment: IBM Mainframes, UNIX, COBOL, JCL,CYCLONE, WDI, CONTROL M, MICROFOCUS, Axway

Developer

Responsibilities:

• Involved in Requirements gathering, design, coding, testing and documentation, KM Prime and Configuration Controller of the Project.
• Lead a team of six for coding of mapping of various EDI interfaces for TPs using IBM WDI; coordinated with Business Teams at client locations to implement business rules during User Acceptance Testing and cyclone system for the transmission and monitoring of files.
• Development of COBOL programs and JCLs to translate the maps and to generate the various REMADV and ORDERS reports and mail to the respective trading partners.
• When a Production incident comes, a ticket would be created. Would be responsible to resolve the incident, Impact of the incident, find the root cause and bring the issue to closure.
• Constant monitoring of the Cyclone system for transmission and monitoring of files and Control M for monitoring of the system.
• Required to translate maps, set up the environment, and send files across interface using JCLs and write COBOL programs to generate reports for pre-post processing of the data. Currently we are working on re-hosting from Mainframes to Microfocus COBOL and related technologies.

Confidential

Environment: Non Stop Tandem, ACI Base24, Pathway, TAL, TACL, Enscribe, Inspect, ILFScan, PTLFScan, POSTA

Senior Developer

Responsibilities:

• When a Production incident comes, TBS will be paged. As a member of TBS I would be responsible to resolve the incident, Impact of the incident, find the root cause and bring the issue to closure.
• If the severity of the incident is high need to join a bridge line and contact the merchant directly for immediate resolution.
• Verified program logic by overseeing the preparation of test data, testing and debugging of programs. Participated in overall systems testing
• Involved in Pre-Prod Migration and Mock Prod Migration test Activity
• Developed tools for increasing the productivity and making work much easier and simpler

Confidential

Environment: MainFrames, Cobol, Assembly,PLI

Mainframe Developer

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Actively involved in gathering requirements from the end users
• Design and development of required enhancements formulating test strategy for the requirement and testing the same under various conditions
• Fixing bugs, Verifying and updating CM Plan, CM Audits
• Implemented error handling logic that involves testing of incorrect input values for the mappings and the means of handling those errors
• Fixed bugs, Verified and updated CM Plan, CM Audits

Confidential

Environment: HTML5, CSS3, JAVA, Java Script

Software Developer

Responsibilities:

• Involved in Requirements gathering, design, coding, testing and documentation.
• Developer worked on coding, testing.
• Unit testing, integration testing and user acceptance testing
• Troubleshoot and fixed bugs by analyzing/investigating about the bug
• Created Implementation plan document
• Mentoring resources in the team
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings