Lead Engineer Resume
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.
