We provide IT Staff Augmentation Services!

Lead Engineer Resume

5.00/5 (Submit Your Rating)

SUMMARY:

An analytical Technical Lead in software development with deep expertise in Data Warehouse, ETL, Informatica Powercenter, IDQ, IICS, SSIS, MSBI, MDM, Teradata, Unix, Python, Attunity Compose, SSRS, T - SQL, PL/SQL, MS SQL SERVER, Data Integration, Analysis, Data Tuning and Tableau BI possess 16.0 year’s hands on experience. Versed in Agile development techniques.

OBJECTIVE:

To work in a challenging and fast paced environment, leveraging my current knowledge and fostering creativity with many learning opportunities. I have ability to learn fast and manage multiple teams, and also good in interpersonal skills, communications, self-learning and will be good contributor on work, in a team or in an individual environment.

SUMMARY:

  • Extensive ETL development, Informatica PowerCenter, IDQ, MDM, SSIS ETL, & Attunity Compose.
  • Experience with SQL Server & Teradata development, stored procedures, triggers and packages.
  • Hands on experience on coding, troubleshooting and performance tuning SQL.
  • Python Scripting and Unix commands.
  • Data flow design from Source to staging layer and to Data Warehouse until Data mart.
  • Reporting in Tableau, SSRS and OLAP.
  • Deliver projects in fast-paced environment.
  • Capital Markets, Banking and Finances, Insurance Domain knowledge.

TECHNICAL SKILLS:

Primary Skills: ETL, Informatica PowerCenter, IDQ, IICS, MDM, SSIS ETL, & Attunity Compose, SQL, MSBI, Teradata, SSRS, SSAS, UNIX and Python Scripting.

Technologies: Data Warehouse, Business Intelligence, Data Integration, OOP, Data Management

Databases: SQL Server, Teradata, Oracle PL/SQL

Reporting Tools: Tableau, SSRS, SharePoint, Crystal Reports

O.S: Unix, Windows

PROFESSIONAL EXPERIENCE:

Confidential

Lead Engineer

Technologies: Informatica Powercenter, Informatica Data Quality, MDM, Python

Responsibilities:

  • Understanding the business requirements, design Informatica PowerCenter ETL and implementation of data loading strategies.
  • Design the DWH architecture and ensure the architectural integrity is maintained.
  • Developing automation Tool using Python Scripting. Bamboo CI/CD Deployment, GIT Bash Commands.
  • Integrated Data from multiple operational system to DWH using Informatica PowerCenter ETL.
  • Involve in development of SSIS packages to load the data from other source to the Data Warehouse and develop DataMart
  • Maintain Customer Data on MDM.
  • Enrich Reporting services, Tableau, MSBI
  • Preparing of Source to Target mapping of data in DW database.
  • Preparing High and Low level Technical/Documents.

Confidential

Lead Engineer

Technologies: Data Stage, Teradata, Unix, Oracle pl/sql

Responsibilities:

  • Understanding requirements from Business stakeholders creating ETL Packages in Datastage.
  • Writing Complex SQL to create dataset as per the business requirements .
  • Importing Source system file into Data Warehouse using Datastage ETL Jobs
  • Writing Unix commands to monitor the ETL jobs.
  • Documenting the data flow from multiple operational system to DWH and Data mart.
  • Creating SQL Code for Reports from datamart as per the business requirement.

Confidential

Technical Lead

Technologies: SSIS, SQL Server 2012, Attunity compose, Data warehouse

Responsibilities:

  • Understanding the business requirements, design, development, testing and implementation of data loading strategies.
  • Design the DWH architecture and ensure the architectural integrity is maintained
  • Integrated Data from multiple operational system to DWH using Attunity Compose.
  • Building Layers between operational systems, staging, ODS, Data warehouse and
  • Involve in development of SSIS packages to load the data from other source to the Data Warehouse and develop DataMart
  • Preparing of Source to Target mapping of data in DW database.
  • Preparing High and Low level Technical/Documents.
  • Implementing Confidential BI solutions implementation.

Confidential

Team Lead

Technologies: SQL Server 2012 (SSIS, SSRS), ASP.Net, Data warehouse, Oracle PL/SQL

Responsibilities:

  • Understanding user requirement and the functional document, distribute the work among the Team.
  • Handling Project new Requirements, enhancement on modules and also supporting existing system on Production environment. Coding SQL, SSIS and SSRS.
  • Major activities included re-design on code, and create new workflow and reducing manual man efforts.
  • Establishing standards for SQL maintenance, tuning, and coding standards.
  • Presenting SDR document to internal high level management on monthly basis.
  • Preparing resources assignment list and the output goals to be achieved.

Confidential

Project Lead

Technologies: Java, JSP, SQL Server 2008 (SSIS, SSRS, SSAS), VB.Net

Responsibilities:

  • Handling the team and user co-ordination.
  • Managing the project and new requirement.
  • Understanding functional document and dividing the work among the team member.
  • Designing User Interface, Testing, debugging and implementation
  • Major activities included coding, support, deployment, advanced performance tuning, database design, and capacity planning.
  • Establishing standards for SQL maintenance, tuning, and coding standards.
  • Established and wrote Performance Tuning guidelines to enhance quality of product.
  • Upgraded SQL Server 2000 to SQL Server 2008, without service interruption.

Confidential

Team Lead

Technologies: VB.Net, Java, SQL Server 2008 (SSIS, SSRS, SSAS)

Responsibilities:

  • Responsible for logical and physical design for application and database tuning.
  • Major activities included coding, support, deployment, advanced performance tuning, database design, and capacity planning.
  • Establishing standards for SQL maintenance, tuning, and coding standards.
  • Established and wrote Performance Tuning guidelines to enhance quality of product.
  • Upgraded SQL Server 2000 to SQL Server 2008, without service interruption.
  • Architected and implemented large volume of trading in Jan-07

Confidential

Team Lead

Technologies: Java, JSP, SQL Server 2008 (SSIS, SSRS, SSAS)

Responsibilities:

  • Handling the team and user co-ordination.
  • Managing the project and new requirement.
  • Major activities included coding, support, deployment, advanced performance tuning, database design, and capacity planning.
  • Understanding functional document and dividing the work among the team member.
  • Designing User Interface, Testing, debugging and implementation
  • Upgraded SQL Server 2000 to SQL Server 2008, without service interruption.

We'd love your feedback!