We provide IT Staff Augmentation Services!

Technical Lead Resume

Tampa, FL

PROFILE SUMMARY:

  • ETL Lead with 12+ years of extensive experience; worked independently & led teams in the development, testing, implementation and maintenance of data processes of moderate - to-large size and complexity.
  • Sound knowledge of Risk & Compliance, Regulatory Reporting, BFS & Insurance domains and extensive experience as Lead ETL developer and designer primarily with Ab Initio toolset.
  • Proficient in design and development of all data warehousing components e.g. source system data analysis, ETL strategy, data staging and data migration strategy.
  • Excellent troubleshooting skills with demonstrable experience identifying bottlenecks in existing database / ETL processes.
  • Capable of looking across the entire business model to develop and promote a strategic vision of the data environment as well as deep-dive into detailed data analysis and data mapping / data profiling exercises.
  • Strong working knowledge of data-modelling skills, with a solid understanding of entities and relationships.
  • Extensive experience working with various databases: SQL Server 2007/2008, Oracle and Operating system UNIX. Exposure to data modelling tools: MS SQL Server databases & scheduling tools: Ab Initio Control Centre & Autosys.
  • NSE s’ in Financial Markets.
  • Self-starter, quick learner and comfortable in high intensity and challenging work environment.

SKILL:

ETL tools: Ab Initio (GDE V3-2-2/V3-1-7-4/V1-15-7/ V1-14-7, EME, Co-opsys) used with UNIX and Oracle.

Scheduling Tools: Ab Initio Control Center & Autosys

Databases: Oracle, SQL Server 2008

OS: LINUX/UNIX

Programming Languages: LINUX Shell scripting, SQL

PROFESSIONAL EXPERIENCE:

Technical Lead

Confidential, Tampa, FL

Responsibilities:

  • Working closely with the business users as an onsite SME to understand the business requirements and converting them into project level technical capabilities.
  • Performing application infrastructure requirement gathering, assessment & estimation of required resources for providing modern & efficient infrastructure services and execution of program.
  • Identifying opportunities in business processes, system capabilities and delivery methodologies for continuous improvement, culminating into direct cost savings.
  • Extensively working in performance tuning of program, ETL procedures and processes.
  • Designing and developing test plans for ETL unit testing and integration testing.
  • Updating the status and planning the releases through scrum meetings.
  • Coordinating with offshore team and providing inputs, conducting daily scrum calls, and resolving road-blocks.
  • Enforcing the quality standards and guidelines for project planning, execution, testing & configuration management.

Technical Lead

Confidential

Responsibilities:

  • Involved in full life cycle development including Design, ETL strategy, troubleshooting reporting, and identifying facts and dimensions.
  • Interact with Business Analysts to collect & understand requirement and to present the solution architecture, develop Ab- Initio graphs and plans based on the BRD (Business Requirement Documents)
  • Create Technical Design Document, release note and deployment steps for migration to SIT/PROD
  • Provide walkthrough to UAT team, create jobs in ‘Ab Initio Control-Centre’ and migrate to higher environments.
  • Write scripts to create reusable datasets, remove headers from the source files and move to landing directory.
  • Worked as a key member in On-site/Off-shore Team, mentored other ETL Developers.

Ab Initio Consultant

Confidential

Responsibilities:

  • Interacted with Business Analysts to gather, understand & refine requirement and presented the solution architecture, developed Ab Initio graphs & plans based on the BRDs.
  • Created technical design documents and provided walkthrough to client and testing team.
  • Graph development and enhancements, perform Unit testing using Autosys scheduler, creation of Autosys jobs and performing code reviews.
  • Created scripts to minimize the failures due to code synchronization issues among different open EME branches.
  • Converted huge SQLs that contains many unions and joins to Ab Initio graphs as part of performance improvement plan and to enhance readability and maintenance of code.
  • Actively promoted and participated in process improvement. Was part of ‘architecture review team’ and assisted in development of processes and applications.

Ab Initio Consultant

Confidential

Responsibilities:

  • Collaborated with the architects, solution designers, business analysts and company executives in order to determine the software's technical direction, system design and implementation plan.
  • Designed, developed and managed processes, tools and workflows using Ab Initio.
  • Conducted unit testing and provided support to testing teams.
  • Partnered with business resources to troubleshoot issues, manage capacity, and plan for optimization and expansion of environments.

Senior Software Engineer

Confidential

Responsibilities:

  • Served as technical SME in all phases of system life cycle (gap analysis, design, develop, implement)
  • Designed and developed extract, transform, and load (ETL) mappings, procedures, and schedules, following the standard development lifecycle.
  • Interacted with client business & IT stakeholders to understand, analyse and complete daily CRs, coded Ab Initio graphs, & monitored the jobs running on production & UAT through Autosys.

Analyst Programmer

Confidential

Responsibilities:

  • Served as project team liaison with business partners to analyse the impact of new requests and business process changes on existing systems and processes.
  • Interacted with source programmers for business understandings, test plan creation and data validation of various input data files through the generic conditioning graph.
  • Performed negative testing by tweaking the input data as per the transformations.

Hire Now