We provide IT Staff Augmentation Services!

Developer Resume

VirginiA

PROFESSIONAL SUMMARY:

  • Around 12+ years of IT consulting experience in analysis, design, coding, development, testing and maintenance of data warehouse systems. Hands on experience include developing Data Warehouses/Data Marts/ODS within Banking, Retail and Telecom.
  • Primary technical Skills: Informatica Power center ( 9.6/9.0.1/8.6/8.1 ), BMC Control M Schedular (6.3/6.4/7.0/8.0/9.0 ), SQL Server and Oracle (7.x to 11g).
  • Involved in full lifecycle implementation of multiple projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
  • Hands on experience in using Informatica (Power Center tools - Mapping Designer, Workflow Manager and Workflow Monitor, Repository Manager, Admin console).
  • Hands on experience of Data warehousing and Business Intelligence Concepts (Star Schema, Snowflake Schema and slowly changing dimensions) with emphasis on ETL implementations, making data readily available for reporting needs of end users.
  • Strong experience on Data migration, Data cleansing, Data Staging of operational sources, CDC using ETL.
  • Hands on experience in Performance tuning and Error Handling techniques and debugging ETL components using Informatica debugger.
  • Expertise in implementing complex business rules through transformations (Expression, Aggregator, Filter, Lookup, Router, Joiner, Update Strategy, Normalizer), reusable components (transformations, mapplets, sessions, worklets) in Informatica.
  • Expert in Data Extraction and integration of heterogeneous Data Sources such as Oracle, DB2, Teradata, MS SQL-Server, Salesforce.com, Siebel-CRM, Mainframes, Web Services, Flat files.
  • Having hands on experience on coding and fine-tuning SQL scripting, PL/SQL Stored Procedures
  • Excellent problem solving, communication, leadership, analytical and interpersonal skills working independently or as part of a team, highly effective at communicating with all levels of management and coworkers.
  • Experienced using SQL scripting, TSQL, Indexes, Functions, Procedures, Triggers and Cursors.
  • Experience in Performance Tuning in Informatica at sources, targets, mappings and sessions level.
  • Strong communication skills and excellent experience in working with small and big teams under stringent timelines.
  • Involved in unit level, integration and system testing.
  • Hands on experience in creating, Modifying and delete the Control M jobs
  • Providing the BAU Support when batch jobs issues, Control M agents issue.
  • Installing the Control M agents and providing the support when the agents is unavailable.
  • Having hands on experience on different versions of BMC Control M 6.4,7.0,8.0 and 9.
  • Working with the NEW day process in Control M. If any issues encountered during loading the batches needs to be resolved to meet the SLA

TECHNICAL EXPERTISE:

  • Data Warehousing & Database Administration
  • Data Conversion & Data Migration
  • Functional Requirements
  • Scripting & Documentation
  • Data Processing & Development
  • Performance Testing &Query Optimization
  • Technical & User Documentation
  • Data Modeling
  • BMC Control M Schedular
  • Informatica 9.1
  • SQL and Advanced SQL, Oracle SQL

TECHNICAL SKILLS:

Databases: Oracle 10g/9i/8i, MS-SQL Server

ETL Tools: Informatica Power Center 9.6/9.0.1/8.6/8.1 , Data Services

Data Modelling: Logical/Physical/Dimensional, Star/Snowflake/Extended-star schema, OLAP.

Scheduling Tools: BMC Control-M

Operating Systems: Sun Solaris 5.0/2.6/2.7/2.8/8.0 , Linux, Windows, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

Developer

Responsibilities:

  • Hands on experience working with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Having experience on creating PL/SQL, Stored Procedures, Database Triggers, Views, performance tuning and optimization.
  • Hands on experience working with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Having experience on creating PL/SQL, Stored Procedures, Database Triggers, Views, performance tuning and optimization.
  • Built mapplets and integrated with dashboard where the business users can see the fail records and pass records in bars and charts view based on each rule or field.
  • Created adaptors, flows, reports and dashboards to populate the reports using the Digital Fuel reporting tool.
  • Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, and IIF function.
  • Effectively communicated with the Business Partners and team members, the problem and the expected time resolution.
  • Responsible for providing timely feedback and necessary help/cooperation to meet client expectations
  • Documented existing mappings as per standards and developed template for mapping specification document.

Environment: Informatica, SQL Server, Oracle, Windows, UNIX/LINUX, Control-M Scheduling tool

Confidential

Developer

Responsibilities:

  • Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
  • Involved in requirement analysis, Extract, Transformation, loading data from the heterogeneous source systems like Oracle, flat files and loading into DataMart.
  • Creating the detailed design documents and one-one mapping documents.
  • Developed complex mapping logic using various transformations like Expression, Lookups Joiner, Filter, Sorter, Router, Update strategy and Sequence generator
  • Created complex Informatica mappings to implement Change Data Capture mechanism by using slowly changing dimensions Type-2 effective date and time logic.
  • Hands on experience working with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Having experience on creating PL/SQL, Stored Procedures, Database Triggers, Views, performance tuning and optimization.
  • Built mapplets and integrated with dashboard where the business users can see the fail records and pass records in bars and charts view based on each rule or field.
  • Created adaptors, flows, reports and dashboards to populate the reports using the Digital Fuel reporting tool.
  • Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, and IIF function.
  • Effectively communicated with the Business Partners and team members, the problem and the expected time resolution.
  • Responsible for providing timely feedback and necessary help/cooperation to meet client expectations
  • Documented existing mappings as per standards and developed template for mapping specification document.
  • Collaborated with tidal team in setting up dependencies on various mappings.
  • Preparing Rollout Plan to knowledge transfer the Production support team and support the application during the hyper care.

Environment: Informatica, BMC Control-M, Oracle, SQL, Windows, UNIX/LINUX

Confidential

Specialist

Responsibilities:

  • Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
  • Involved in requirement analysis, Extract, Transformation, loading data from the heterogeneous source systems like Oracle, flat files and loading into DataMart.
  • Creating the detailed design documents and one-one mapping documents.
  • Developed complex mapping logic using various transformations like Expression, Lookups Joiner, Filter, Sorter, Router, Update strategy and Sequence generator
  • Created complex Informatica mappings to implement Change Data Capture mechanism by using Slowly changing dimensions Type-2 effective date and time logic.
  • Hands on experience working with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Having experience on creating PL/SQL, Stored Procedures, Database Triggers, Views, performance tuning and optimization.
  • Built mapplets and integrated with dashboard where the business users can see the fail records and pass records in bars and charts view based on each rule or field.
  • Created adaptors, flows, reports and dashboards to populate the reports using the Digital Fuel reporting tool.
  • Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, and IIF function.
  • Effectively communicated with the Business Partners and team members, the problem and the expected time resolution.
  • Responsible for providing timely feedback and necessary help/cooperation to meet client expectations
  • Documented existing mappings as per standards and developed template for mapping specification document.
  • Collaborated with tidal team in setting up dependencies on various mappings.
  • Preparing Rollout Plan to knowledge transfer the Production support team and support the application during the hyper care.

Environment: Informatica, BMC Control-M, Oracle, SQL, Windows, UNIX/LINUX

Confidential

Software Engineer

Responsibilities:

  • Design and creation of detailed Technical Mapping document with information on implementation of business logic.
  • Prepare Unit and Integration test cases.
  • Extracted data from various source systems like Oracle and flat files as per the requirements.
  • To design Informatica mappings by using various basic transformations like filters, routers, source qualifiers, lookups etc. and advance transformations like aggregators, XML source qualifiers, sorters etc.
  • Building reusable components include reusable expression, mapplets, sessions and flows to facilitate flexible portfolios.
  • Worked extensively with aggregate functions like Min, Max, First, Last, and Count in the Aggregator Transformation.
  • Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
  • Hands on experience working on Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • Having experience on working with various re-usable tasks, workflows, mapplets, and re-usable transformations.
  • Working with Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer
  • Perform Unit and Integration testing. Reporting of bugs and bug fixing.

Confidential

Control M Engineer

Responsibilities:

  • Worked on problem determination, troubleshooting, backup & recovery on Control M agents, Node Groups,
  • Installing Control M agents on windows, Linux, Solaris, Unix and AIX boxes
  • Creating, modifying, deleting batch jobs based on the user request in the control M.
  • Providing the Control M access based on upon the request for Global users
  • Demising the control M agents and Upgrading Agents as per the global standards
  • Worked on Evergreening engineering upgrading the Control M versions
  • Troubleshooting the issues raised by users based up on the priority
  • Providing on call support on weekends and out of hours
  • Worked on Peoplesoft profile creations
  • Hands on experience working on Control M Configuration Manager

Confidential

Control M Engineer

Responsibilities:

  • Providing 24X7 production support and maintenance of Control M batch jobs to execute End of the Business within the SLA to provide users accessible for almost 47 countries
  • Trouble shooting, batch monitoring and ensuring the system online within the SLA's of countries
  • Contact appropriate teams for problems and support for Immediate bug fixing
  • Critical batch job monitoring and Ticket rising during failure, Raising and lowering priority on jobs
  • Provide ownership and priority of problems and Communication - inbound and outbound calls, e-mails etc.
  • Raising and lowering priority on jobs.
  • Critical batch job monitoring and Ticket rising during failure to the respective teams.
  • Incident documentation - opening, closing and updating tickets raised by the ATOS when the Jobs get failed.
  • Communication - inbound and outbound calls, e-mails etc.
  • Provide ownership and priority of problems
  • Provide Ad Hoc Run Request
  • Skipping the Jobs, Kill, Rerun the jobs, place jobs on hold/Release, Demand jobs as per Requests

Hire Now