Technical Lead And Analyst Resume Profile USA

Reference Id: 83926     Posted on Sunday 20th September 2015      Software Engineer

Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

Technical Lead and Analyst           Resume Profile USA






Ø  6+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of OLTP and OLAP systems.

Ø  Currently working as a Technical Lead and Analyst.

Ø  Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP applications.

Ø  Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Ø  Experience on Logical & Physical Designing of Databases. Data Modeling, Conceptual Design & Data Architecture. Extensive use of Erwin as a modeling tool.

Ø  Involved in project planning, scheduling, System design, Functional Specification, Design specification, coding and system test plan.

Ø  4+ years of experience in using Informatica Powercenter (8.6/9.1) tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.

Ø  Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Ø  Experience with dimensional modeling using star schema and snowflake models.

Ø  Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

Ø  Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Ø  Proficiency in developing SQL with various relational databases like Oracle, SQL Server and Teradata.

Ø  Experience in development of Stored Procedures, Functions, Cursors, Triggers and Packages using PL/SQL.

Ø  Experience in development of database objects like tables, indexes, Materialized Views, Procedures and synonyms

Ø  Experience in RDBMS development including coding using SQL*Plus, PL/SQL Developer, SQL*Loader, TOAD and good understanding of Oracle data dictionary

Ø  Involved with migration of Database from 10g to 11g

Ø  Strong PL/SQL programming skills and expertise with bulk binding techniques.

Ø  Expertise in Query Optimization and Performance Tuning by using EXPLAIN_PLAN, SQL TRACE and TKPROF Utilities, Hints provided by Oracle.

Ø  Experienced in providing production support and investigating and resolving system defects and fixing bug.

Ø  Experience in UNIX shell scripting.

Ø  Experience in Database Administration (Oracle 10g & 11g) and Application Server Management.

Ø  Worked on development and enhancement of Content Management, Safety & Operations, and Health Safety & Environment and Financial applications.

Ø  Worked on BPM software like Pega.

Ø  Underwent CSA (Certified System Architect) Training on PRPC 6.2 and PRPC 6.2 Boot camp.

Ø  Developing control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.


Technical Skills

·   Software skills   Oracle PL/SQL, SQL, HTML, UNIX, XML, JavaScript, T SQL

·   Database            Oracle 9i, 10g, 11g, SQLSERVER 2005, Teradata

·   Data warehouse Tools  Informatica Powercenter 8.6/ 9.1

·   Tools                 Toad, MS Visio, Microsoft Visual SourceSafe, OEM, IIS




 Confidential, Technical Lead and Analyst                                                 


Project Summary

1.     Traction Tulsa Exit Migration: Traction is an incident management and action tracking tool used by   Confidential. The project involves the migration of all Traction Environments from TULSA to AMDC.

2.     Traction V5: This project is a major enhancement to   Confidential’s incident management tool Traction. This involved implementation of Operational management services, merging of MIA/HIPO application with the current system and implementation of S&OR module and migration of legacy data and managing the two different reporting databases. Data will be loaded into these databases from the Traction OLTP database in different frequencies. The entire ETL process consists of OLTP source system, staging area, a reporting environment.

3.     Traction T2 – Data migration:  Confidential is replacing its incident management system Traction with enhanced architecture. The Traction application replacement, T2 will transform the way customer manage and learn from incidents, which will help reduce risks. The project handles the migration of legacy Traction data into IDS database, including all necessary procedures for transferring and validating the data. Most of these processes will follow the standard ETL process. The entire ETL process consists of multiple OLTP source systems (Oracle and SQL Server), staging area, a Data warehouse, a Reporting environment and two datamarts.



Ø  Involved in project planning, scheduling, System design, Functional Specification, Design specification, coding and system test plan.

Ø  Responsible for architectural set up required for new enhancements in Traction Application.

Ø  Responsible for understand technical challenges and propose feasible solutions ensuring the integrity of Traction application.

Ø  Databasemigration from 10g to 11g

Ø  Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data

Ø  Created and reviewed Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, lookup, Stored Procedure, Filters, Sequence, Router, Union and Update Strategy. 
Ø  Developed and implemented Procedures and Functions in Oracle to meet the business requirements.
Ø  Preparation of design document as per client requirements
Ø  Preparation of Impact Analysis document as per the design document
Ø  Unit testing the PL/SQL blocks and Informatica mappings in different Environments.
Ø  Transformed data from various sources like excel and text files in to reporting database to design most analytical reporting system.
Ø  Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
Involved in Data Extraction from Oracle and Flat Files, XML Files using SQL Loader, Freehand SQL.
Ø  Created crontab to execute various jobs on database server. 
Ø  Created procedures and functions for enhancement of application. 
Ø  Created control files to upload data from flat files using SQLLDR. 
Ø  Involved with performance tuning of the application using EXPLAIN PLAN and SQL TRACE. 
Ø  Created Triggers and Materialized views. 


Software / Tools Used

Ø  Oracle PL/SQL, SQL, HTML, UNIX, XML, JavaScript, T-SQL, Informatica Powercenter 9.1, Toad, MS Visio, ERWIN, Microsoft Visual SourceSafe, IIS.


Ø  Oracle 10g/11g, SQL SERVER 2005







 Confidential Software Engineer                        




Project summary: Finacle Core Customization: Finacle is a universal banking solution developed by  Confidential It addresses the core banking, treasure, wealth management, consumer and corporate e banking and web based cash management requirements of universal banks worldwide. This project involves customization of core banking solution according to the client requirements, capturing different Customers, Policies, Products and financial related data from multiple OLTP Systems and Flat files. Extracted Transformed Loaded data in to data warehouse using Informatica Powercenter and generate various reports on a daily, weekly monthly and yearly basis.



Ø  Responsible for gathering requirements and preparation of requirement specific documents.

Ø  Created Tables, Synonyms, Sequences, Views and Stored procedures. 

Ø  Involved in Writing Procedures, Function & Packages in PL/SQL

Ø  Schedule jobs via oracle jobs

Ø  Created materialized views for faster query performance

Ø  Involved in writing PL/SQL packages and database triggers

Ø  Use of EXPLAIN PLAN, HINTS to tune queries for better performance and also Extensive Usage of Indexes

Ø  Preparation of Checklists, identification of Test Cases, preparing Test Plans.

Ø  Integrating and deploying in production.

Ø  Designing database using Erwin.

Ø  Preparation of low-level and high-level specifications

Ø  Data modeling, database design and creation of database using data modeling tools (Creation of Data Flow diagrams and Entity Relation Diagrams using Erwin).

Ø  Interaction with the Data warehouse team and helping them in building SQL queries and fine tune for better Performance.

Ø  Database design, E-R diagrams, Logical, Physical layout design using Erwin.

Ø  Thorough understanding of Data warehouse Concepts.

Ø  Created and reviewed Informatica Mappings to load data.

Ø  Created ETL processes to extract data from Oracle tables for loading into Teradata Datawarehouse.

Ø  Extracted data from various sources like Teradata and relational databases.

Ø  Created ETL processes to extract data from Teradata to load into datamarts.

Ø  Used predefined shell scripts to run jobs and data loads.

Ø  Involved in production support, Customer Support and troubleshooting Data Quality and Enhancement Issues.

Ø  Written UNIX shell scripts to update table and execute at the server level.

Ø  Performed unit testing for all the development activities and involved during the design phase of the project for requirement analysis


Ø  Software / Tools Used  Oracle PL/SQL, SQL, HTML, UNIX, XML, JavaScript, Informatica Powercenter 8.6, Toad, Microsoft Visual SourceSafe, OEM.


Ø  Database                  Oracle 9i, Teradata.







Search Resumes

Looking for I.T Professionals on a Contract basis?