We provide IT Staff Augmentation Services!

Development Resume

4.00/5 (Submit Your Rating)

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • Result oriented professional offering 8 years of experience in IT.
  • Experienced in ETL (Extract, Transform and Load) processes utilizing Informatica power center 9.x/8.x/7.x/6.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
  • Experienced in business, system and data analysis.
  • Experienced in creating logical and physical data models.
  • Experienced in full lifecycle in Data warehousing projects with data analysis, data extraction, cleaning and loading.
  • Experienced in Data Migration and porting activities.
  • Implemented complex business rules in Informatica by creating re - usable transformations, robust mappings/mapplets.
  • Implemented performance tuning at various levels such as Source, Target, Mapping, Session, System and Partitioning.
  • Experienced in source systems analysis and data extraction from relational and non-relational sources like Flat files, VSAM, XML, and Oracle.
  • Experienced in using the Informatica command line utility pmcmd, pmrep to operate on workflows (start, stop suspend etc) and control sessions and tasks in non windows environment.
  • Experienced in programming using PL/SQL, SQL Loader, Unix Shell Programming/Scripting, Stored Procedures and Functions at backend.
  • Well versed and experienced in onsite-offshore co-ordination.
  • Preparing test plans, document test cases, reviews results of tests and identify gaps in testing process.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x

Programming: SQL, PL/SQL, UNIX Shell, Java.

Web Technologies: HTML, CSS, XML, XSD, SOAP, JavaScript.

Web/App-Servers: Jboss 4.1, Tomcat4.1, Web Logic, iPlanet, Sun One.

Tools: PL/SQL Developer, TOAD, Informatica, Cognos, BO (Business Objects), Eclipse, MS Office.

Database: Oracle 8i/9i/10g/11g, MS-Access.

Operating Systems: DOS, WINDOWS NT, 95/98, 2000.

Testing: Exposure to Topaz, Win Runner and Site scope testing tools

Architecture: Service Oriented Architecture, Model View Control.

Connectivity Tools: SSH Secure Shell, Putty, and WINSCP.

WORK EXPERIENCE:

Confidential, Los Angeles, CA

Development

Responsibilities:

  • Analyze requirements from business partners.
  • Assist in defining and documenting data requirement and provide data clarification and definition
  • Participate in business, functional and data requirement sessions.
  • Assist in project Architecture design.
  • Data modeling and DDL creation.
  • Analysis and design of mappings.
  • Development of ETL, Data Load and unit testing.

Confidential, Los Angeles, CA

Development

Responsibilities:

  • Participate in business, functional and data requirement sessions.
  • Analyze requirements from business partners.
  • Compose and discuss GAP Analysis findings.
  • Data modeling and DDL creation.
  • Analysis and design of mappings.
  • Development of ETL, Data Load and unit testing.
  • Development of Oracle SQL view/query.
  • Data Load Process documentation.

Confidential, Los Angeles, CA

Development

Responsibilities:

  • Participate in business, functional and data requirement sessions
  • Co-ordinate to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
  • Work with both project and support teams to understand existing systems and to help troubleshoot, optimize, and tune ETL processes as needed.
  • Contribute to improving automating the existing infrastructure and deployment process.
  • Data Load Process documentation.

Confidential, Overland Park, Kansas

Development and Production Support

Responsibilities:

  • Requirement gathering and design.
  • Implement reporting using Business Objects technology.
  • Developed mappings in Informatica to load the data from the source into the data mart, using different transformations.
  • Created and configured workflows, worklet and sessions to transport the data to target warehouse tables using Informatica workflow manager.
  • Perform Integration and Unit testing in development and testing environment.
  • Perform UAT and Production release after UAT sign-off received from the functional team
  • Post Production Support.

Confidential, Overland Park, Kansas.

Consultant /On-site Coordinator

Responsibilities:

  • Interacting with the customer to understand customer requirements, thereby analyzing and developing a solution approach
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
  • Created Interface between Legacy systems and Global SAP via Informatica.
  • Implemented complex business rules in Informatica by creating re-usable transformations, and robust mappings/mapplets.
  • Experience in performance tuning of sources, mappings, targets and sessions.

Confidential, Overland Park, Kansas

Development and Production Support

Responsibilities:

  • Used Informatica designer to create reusable transformations to be used in Informatica mappings and mapplets.
  • Developed mappings in Informatica to load the data from the source into the data warehouse, using different transformation like Source Qualifier, Expression, Lookup, Aggregator, update strategy, Filter transformations etc.
  • Created and configured workflows, worklets and sessions to transport the data to target warehouse tables using Informatica workflow manager.
  • Developed UNIX shell scripts.
  • Scheduled the sessions to extract, transform and load data into warehouse database as per Business requirements.
  • Post production support.

Confidential

Development and Production Support

Responsibilities:

  • Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
  • Developed mappings in Informatica to load the data from the source Into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Filter and Sequence Generator transformations.
  • Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
  • Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
  • Developed UNIX shell scripts.

Confidential

Developer

Responsibilities:

  • Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
  • Developed mappings in Informatica to load the data from the source Into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Filter and Sequence Generator transformations.
  • Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
  • Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
  • Developed UNIX shell scripts.

We'd love your feedback!