We provide IT Staff Augmentation Services!

Technical Lead - Contractor Resume

SUMMARY

  • Over 17 years of extensive experience reflecting strong technical and leadership qualities coupled with "Hands - On" experience implementing solutions across the technology spectrum.
  • Extensive experience in managing the projects including motivating and mentoring on site and offshore developers and ability to multi-task and leverage excellent team-building skills.
  • Involved with all aspects of SDLC (Architecture, development, migrations, quality assurance and upgrades of the software.) Support and interact with business users in a team lead capacity.
  • Experience in designing, developing and implementing Enterprise Data Warehouse (Informatica and Microsoft SQL Server BI) using Informatica and SSIS.
  • Experience in Design and development of Logical and Physical Data model.
  • Experience in creating and managing a large data set migration to data warehouse - loading production data, manipulating, SCD and reconciling data etc.
  • Expertise in designing and deploying creating mappings, sessions and work flows with Informatica.
  • Extensive experience in upgrading SQL Server 2000 to SQL Server 2005, 2008, 2008 R2, 2016 and implementing the Data partition technique with Automatic sliding window.
  • Experience in Production Support with effective User Interaction. Experience in managing the batch process with large number of dependencies.
  • Experience in Writing and Tuning T-SQL, Stored Procedures to improve the performance and availability.
  • Exposure of working in Insurance and financial domain (managed Global Data Warehouse Worked on Portfolio Management, Trade Reconciliation tool, Confirmation (which supports different language - French/English) etc
  • Excellent written and verbal communication, documentation skills, ability to work across organizations to achieve results with minimal hand holding.

TECHNICAL SKILLS

Databases: MS-SQL Server 2016, 2012, 2008 R2, 2008, 2005, 2000, Sybase.

ETL Tools: SSIS, Informatica Power Center 9.6.1

Data Modelling: Erwin, ERStudio

Database Utilities: MS SQL Profiler, Query Analyzer, Index Analyzer, SQL Agents, RedGate

Reporting Tools: SSRS, Power BI, SAP Business Objects, Crystal Report

Scripting Language: Bitbucket, TFS, Perforce, VSS, SVN, BMC Control-M, Autosys, MS Project

Other Tools: Perl, Shell Scripting, Power shell, Batch files, JavaScript, VB Scripts etc.

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead - Contractor

Responsibilities:

  • Work with business owners and analysts on designing applications including data mapping, data integration jobs, database design, data architecture (Staging, Warehouse, Data Mart, etc.), implementation of business rules/calculations (stored procedures)
  • Analysis, design, build, test and documentation of the complex Data Conversion and Integration solutions
  • Design, develop, and testing ETL code using Microsoft SSIS ETL tool for the definition, development and testing of the processes and programs necessary to extract data from the various data sources
  • Prepare and maintain technical documentation, such as run books and ticket documentation, providing information to support organizations such as the help desk and QA teams
  • Oversee delivery and support based on current data warehouse best practices
  • Provide primary day-to-day support for operational data warehouse and related systems
  • Worked with offshore team and deliver project successfully
  • Use Hana connector to pull engagement, utilization, hr, fna, expense etc data from SAP HANA.
  • Worked with team in automating the deployment and release validation process.
  • Developed data models using ERStudio
  • JIRA was used for issues and release tracking.
  • Bit Bucket (GIT) and TFS used for source control
  • Red Gate used for database object check-in in source control and other functionality
  • Use Altryx to get distance detail for expenses.

Environment: MS SQL Server 2016, SSIS, Altryx, Hana Studio, PowerShell, Red Gate, Jira, Bit Bucket, TFS, ERStudio, Concur

Confidential

Senior Principal Consultant

Responsibilities:

  • Responsible for Project Management & Tracking.
  • Responsible for interface with CIT PMO.
  • Responsible to own end-to-end software design, development, testing and implementation of Enrichment Hub and related applications/process.
  • Responsible for analyzing and gathering non-functional requirements and User stories.
  • Responsible to setup Daily Scrums meeting to discuss the progress and next step
  • Responsible to ensure that CIT compliance/ process are followed.
  • Responsible to discuss with CIT Product owner to plan release/sprint.
  • Responsible to conduct and support UAT and Prod release.
  • Responsible for ETL development (SSIS) to process and archive template files
  • Responsible for SSIS development for integration with Centralize Rule Engine and MDM system.
  • Responsible to design database and present it to client data modeling team.
  • Responsible to provide Production support during EST hrs.

Environment: MS SQL Server 2012, SSIS, .Net, Control-M, Microsoft Project

Confidential

Senior Principal Consultant

Responsibilities:

  • Responsible for the management, maintenance, and development of Concur-Oracle Cloud Fusion Interface.
  • Responsible for supporting daily Concur to Oracle fusion load.
  • Responsible for Bug fixes, enhancement and automation.
  • Responsible to provide support to users and resolve their queries.
  • Responsible to develop ETL process in SSIS to download encrypted expense detail from concur.
  • Responsible to develop ETL process in SSIS to send the expense detail to Oracle Cloud Fusion system
  • Responsible to develop ETL process in SSIS to send encrypted payment detail to US/UK banks.
  • Responsible to develop ETL process in SSIS reconcile the payment detail sent and acknowledgement received from bank

Environment : MS SQL Server 2012, SSIS, Autosys, Microsoft Project

Hire Now