SUMMARY

• 7.5 years of IT experience in Analysis, Design, Development, Implementation, Testing, Support of application, Migration and supporting of data migration and Data Integration Solutions using Informatica PowerCenter and data stage.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Strong experience in full cycle of development of application with Oracle PL/SQL and Shell scripting.
• Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 12c/11g, DB2 UDB and SQL Server 2008/2000.
• Have working experience in Oracle concepts like, table creation, Procedure creation, package creation, Indexes, Synonyms, Views, Triggers, Materialized view, Partitioning, etc.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target. Worked with Informatica Cloud to create Source /Target connections, monitor, and synchronize the data in application.
• Strong with relational database design concepts, data modelling, tuning and procedural queries.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Experience in integration of various data sources like Oracle, Mainframes, SQL server, XML, Flat files.
• Independently perform complex troubleshooting, root - cause analysis and solution development.
• Out of own interest and to grow my technical skills with various ETL tools, I have completed training and certification in Tableau hands-on from edureka.
• Successfully lead a team of maximum 15 associates and delivered project release within target date and without any Production Issue and successful implementation that ever done in past.
• Strong knowledge in Retail business such as Inbound, warehousing, outbound, shipping, Store layout & planogram, and Forecasting & Replenishment. Good knowledge in target business including third party vendor such as Witron, Swisslog and Fortna.
• Good domain knowledge in Unemployment Insurance (UI) in US.
• Have hands on experience on Perl, Mango DB.
• An effective communicator with strong analytical / logical/ interpersonal skills and ability to relate to people at any level of business and management.
• Commitment, result oriented and interested to learn new technologies.
• Flexibility in approach, good time management and confident with commitment in the work.
• Authorized to work in United States with H1B visa.
• Holding valid H1B Visa from Confidential owned petition for Jackson, Mississippi location.

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential

Responsibilities:

• Involved in requirement gathering, Design, testing, project coordination and migration.
• Project planning and scoping, facilitating meetings for project phases, deliverables, escalations and approval. Ensure adherence to SDLC and project plan.
• Analysed the business requirements and functional specifications provided by Data migration group.
• Extracted data from Oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica PowerCenter for extraction, transformation and load (ETL) of data in the data migration.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources like XML, .csv, Database and WebServices.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re - usability by designing and creating mapplets.
• Used Informatica PowerCenter Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run, enable and disable index.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the mappings and reporting logic.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side to review and correct the issues on their side.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica PowerCenter 10.1, IDQ 10.1, Oracle 12c, Webservice, MSSQL Server 2012, DB2, Erwin 9.2, DAC Scheduler, Putty, Shell Scripting, ClearCase, WinSCP, Notepad++, JIRA, Control-M V8, Clique View 9.1

Informatica Developer

Confidential

Responsibilities:

• Experience in integration of data sources like Oracle, SQL server and MS access and non - relational sources like flat files into staging area.
• Designing custom reports via SQL Reporting Services to align with requests from internal account teams and external Clients.
• extensively used mapplet, udf, reusable transformations and worklets to implement reusable like Data validation, Data quality, Reference check and data cleansing.
• used shortcuts for sources, targets, transformations, mapplets, and sessions to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Integrated Informatica Data Quality (IDQ) with Informatica PowerCenter and Created POC data quality mappings in Informatica Data Quality tool and imported them into Informatica PowerCenter as Mapping.
• Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer) and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst)
• Applied slowly changing Dimensions Type I and Type II on business requirements.
• extensively worked on performance tuning, enhanced readability and scalability.
• Worked extensively on .csv file, pdf and xml files and in isolating header and footer in single file.
• working with large amounts of data independently executing data analysis, utilizing appropriate tools and techniques (Interpreting results and presenting them to both internal and external client.
• Writing SQL queries to create end-user reports /Developing SQL Queries and stored procedures in support of ongoing work and application support.
• Designing and executing test scripts and test scenarios, reconciling data between multiple data sources and systems.
• Worked on Multidimensional Models and created Reports in Report Studio using Cubes as a data source.
• effectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
• Raised change requests, analysed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD.
• Perform analysis profiling on existing data and identify root causes for data inaccuracies, Impact Analysis and recommendation of Data Quality.
• precisely documented mappings to ETL Technical Specification document for all stages for future reference.
• Scheduled jobs for running daily, weekly and monthly loads through control-M for each workflow in a sequence with command and event tasks.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression, lookups (connected and unconnected), Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Responsible for studying the existing data base and working on migrating existing PL/SQL packages, stored procedures, triggers and functions to Informatica PowerCenter.
• Fine-tuned ETL processes by considering mapping and session performance issues.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Worked on DB2 SQL and Tuning.
• maintained the proper communication between other teams and client.

Environment: Informatica PowerCenter 9.6, SQL Server 2008, IDQ 8.6.1, Oracle 11g, PL/SQL, DB2, Putty, Autosys Scheduler, UNIX, ER Studio, ESP, WinSCP.

Oracle PL/SQL developer and Data stage Developer

Confidential

Responsibilities:

• Analysing Functional and Non Functional Requirement and Automation feasibility.
• Following up with Business Analyst on clarifications and suggesting improvements if any.
• Understanding the business requirement and preparing designs documents (HLD and LLD).
• Constructing the stored procedures/packages to meet business requirements and testing the same.
• Worked with WebSphere message broker, which is used in this project to flow the message(Information) from one interface to another interface to achieve a special business requirement.
• extensively worked on performance tuning, enhanced readability and scalability.
• Writing SQL queries and stored procedures in support of ongoing work and application support.
• Fine - tuned SQL queries in multiple stored procedures and packes by considering performance issues and application response time.
• Understanding the source data which is comming from difference sources like Main frame DB, Oracle DB, Flat files & CSV files.
• Understanding the target datatbase requiremnents and creatin g mapping documents.
• extensively used mapplet, udf, reusable transformations and worklets to implement reusable like Data validation, Data quality, Reference check and data cleansing.
• working with large amounts of data independently executing data analysis, utilizing appropriate tools and techniques (Interpreting results and presenting them to both internal and external client).
• Designed and developed Technical and Business Data Quality rules in IBM Infosphere data stage.
• Profiling the source data using IBM Infosphere quality Center tool.
• Handleing data stage adimistartive activities such as New user creation, New project creation and server maintanance.
• Designing and executing test scripts and test scenarios, reconciling data between multiple data sources and systems.
• Responsible for the overall project and timeliness of the deliverables.
• Providing support during UAT testing and coordinate with the customer and development team.
• Analyse problems to automate or improve existing systems and review computer system capabilities.
• Using BIRT reporting tool to generate reports for bussinees purpose.
• Raised change requests, analysed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD
• Delivered the project with 0 defctes in post implementatiopn and successfull implemenation for the first time in DPM history.
• Preparing for project internal and project external audits with in the organization.
• Leading a 15 memebrs of team successfully.

Environment: Oracle PL/SQL, ETL process, IBM Infosphere Datastage Designer, IBM websphere message Broker (WMB), Embarcadero ER/Studio tool, BIRT, Unix shell scripting, ProC, Perl and HTML.

JDA Support Executive

Confidential

Responsibilities:

• Work with bussiness to gather requirements to build the functionalities for user interface
• Prepare design document to address the flow that are observed from bussiness requirment document.
• Develop web based program in order5 to implement the functionality.
• work on coding and perfoming unit tersting for developined application
• Providing support post implementation in productuion for the chnages
• Incident management - Performing fault diagnosis for the user reported issues in the sanme application and provide nercessary technical solution to perform the bussines functions
• Event Manegement - Diagnouse the auotomated alerts generated due to faulty condition and provide proactive solutions befopre a user/Business flow is imapcted.
• Problem management - Providing perminant resolution for the issues identified as part of incident.Event management.
• Preparing for internal and external audits.

Environment: JDA, DataStage, ER Studio, ETL process, PL/SQL, Control-M, Unix, Proc, perl and Service Now.

Oracle PL/SQL Developer:

Confidential

Responsibilities:

• Analyzing Functional and Non Functional Requirement and Automation feasibilility
• Following up with Business Analyst on clarifications and suggesting improvements if any.
• Prepare HLD and LLD for Inbound module
• Preparing unti test cases and testing the onwed module along with other modules such as waving, Packing and outbound.
• Constructing the stored procedures/packages to meet business requirements and testing the same.
• Writing SQL queries and stored procedures in support of ongoing work and application support.
• Fine - tuned SQL queries in multiple stored procedures and packes by considering performance issues and application response time.
• Planing, Preparing test cases, execution and validation for Interface testing with third party vendor Witron.
• Supporting with team for emulation, 4-wall testing, and Onsite UAT.
• Participacited in successfully implememntation and supporting the application.
• Provide the application worrenty support and provide temporary fixe if required.
• Working on post implememntation defects
• Working on understanding the change requests(CR) requirements and implementing the chnanges with out deviating the existing behaviour of the application.
• Supporting post implementation if any issues and defects.

Environment: Oracle PL/SQL, Control-M, Unix, Proc, perl and Service Now.