We provide IT Staff Augmentation Services!

Senior Technical Lead Resume

New, JerseY

SUMMARY:

  • Having around 12.5 Years of IT Experience around Developing, Enhancement in Data warehousing and ETL .
  • Having strong development expertise in SAP Data Services 4.1/XI 3.2(SAP BODS) and Business Objects Data Integrator (BODI) 6.1.
  • Experience in Oracle PL/SQL development, Enhancement and maintaining applications in Oracle 11g
  • Hands on experience in Oracle cursors, triggers, functions and stored procedures
  • Experience in managing end to end data migration processes, creating data migration functional specifications, data flow, data mapping specs, data extraction, data transformation, data migration to SAP, Data archiving and system retirement.
  • Involved in data standards and procedures, warehousing, design and development of logical and physical data models and databases and information management functions.
  • Involved and provides tactical solution for high complexity issues when project meet in risks
  • Strong ability to optimize Jobs, Workflows and Data flows to improve SAP BODS Job performance.
  • Good experience in module estimation, integration and delivery. Expertise in developing scripts, testing, debugging, documenting and implementing complex Batch jobs and Real time jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations
  • Got trained and having good knowledge in SAP HANA
  • Worked as Sr Tech Lead / Team Lead and independent Team Member. Excellent problem solving and analytical skills with strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: SAP BO Data Services(BODS) XI 3.2/4.1, Informatica, Oracle Data Integrator, Data Stage, SAP Information Steward, Data Modelling

DataBases: Oracle 9i/11g, Sql Server 2008, DB2, TeraData

Languages: Oracle Sql, PL/SQL

Others: Oracle Forms 6.0/ Reports

Core Competencies: Software Development Functional testing Project & Test Plan Review UI Testing Team Management Client Coordination Metrics Gathering & Analysis

Domain Competencies: Media and Advertisement Manufacturing HealthCare

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Senior Technical Lead

Responsibilities:

  • As a Sr Technical lead at onsite, work with client manager to gather the requirement and work on the design
  • Allocate the requirement to offshore and clarify all the questionnaires.
  • Provides technical consulting and guidance to teams for developing highly critical ETL architecture.
  • Coordinates schedules, activities and staff across all project teams.
  • Plans and conducts Design calls with all the core teams.
  • Define and implement ETL development standards and procedures
  • Day to day co - ordination with offshore to make sure the delivery in place.
  • Involved in Module Estimation, module allocation to my team members
  • Prepare Source to Target mapping, process flow diagram, ETL architecture diagram and get the approval from client
  • Creating Jobs Based on STM/Business Rules.
  • Involved in Tuning activities and mentoring the team to reduce the Job Flow.
  • Sending Daily MoM and get it approve from project stakeholders
  • Review the BODS - Dataflow and workflows and provide the suggestions, comments to offshore team
  • Involved in Unit Testing and Client End to End Testing. Prepare the process flow report while End to End testing and share it to client managers.
  • Daily call with support team and analyze/provide solutions for pending tickets
  • Analyze the project tracks and provide the value adds to client.
  • Prepare the Play book and Run Book for Dev to SIT and prod deployments. Co-Ordinate with Support Team and deploy the code into Test, SIT and Prod environment.
  • Schedule and Monitor the jobs in SIT and Prod environments

Environment: Business Objects Data Services (BODS 4.1), Oracle 11g, XML, Flat files

Confidential, New Jersey

Sr Technical Lead

Responsibilities:

  • Follow-up with client by calls for get the source files for evaluation
  • Creating profiling rules based on the requirements
  • Validate the file names, data using by Sql/PL Sql scripts
  • Enhance the existing Data flows, Work flows and creating New Data Flows and Work Flows based on with business rules
  • Involving in Technical/Analytical/Tuning to my team make sure the on time delivery
  • Sending Daily MoM and get it approve from project stakeholders
  • Execute the BODS batch job and prepare the Site Action Report with Business Objects.
  • Validate the Site Action Report and analyze/compare the previous week report
  • Share the final Site Action Report to Client
  • Move the Backup data from Oracle to Sql Server
  • Verify the Site Action Report in UI

Environment: Business Objects Data Services (BODS 4.1), Oracle 11g, XML, Flat files, SAP Information Steward

Confidential

T ech Lead

Responsibilities:

  • As a Tech Lead in Offshore, schedule and join the daily calls with Onsite folks and assign the tasks to Team members
  • Created Data stores, defined definitions for flat files and excel files, and imported tables metadata into Data stores
  • Created customized functions, used build-in functions, and developed scripts and stored procedures to map source data to target tables
  • Preparing the Source to Target mapping document and prepare the Estimations for the ETL tracks
  • Develop the high complex the Dataflow and writing the challenging Sql/PL Sql scripts
  • Creating Jobs Based on STM/Business Rules
  • Analyzing the Work flows and Data Flows and provide the solution for good performance in source/Target and Data services.
  • Provide the solution to team members and support team how to implement the simplest way in complex data flows
  • Involved in Internal Code Review/Unit Testing.
  • Scheduled and monitored the jobs via Data Services Management Console
  • Providing Technical trainings to offshore and on site new comers

Environment: Business Objects Data Services (BODS XI 3.2), Flat files, SqlServer

Hire Now