We provide IT Staff Augmentation Services!

Senior Technical Lead Resume

SUMMARY:

Extensive hands on experience in Healthcare, Finance, Sourcing, HR, Sales, Insurance and Retail Industries Data using Informatica, Snowflake, Teradata, Oracle, Sybase Business Objects, Cognos and Hadoop Technologies in the area of Data Warehouse, Data Integration, Master Data Management, Data Migrations, Data Conversions, Solution Architecture, Requirement Analysis, Business Intelligence, Big Data and Analytics from collection of Business Requirements to Deliver the complex projects/products by using with an overall 16 years of experience in Software Consultancy with valuable experience of working with International clients.

SKILL:

System Design & Development: Requirements Gathering and Analysis, Solution Design, Development, Testing (SIT and UAT) and Implementation in Production environment

Languages and Software: Informatica Power Center, ICS, Power Exchange, BDM, Hadoop, Business Objects, Cronacle, VS Cobol II, Visam, JCL, Maestro, Control - M

RDBMS: SNOWFLAKE, Teradata V2R5, Oracle, Sybase and SQL Server

Project Management: Project Planning, Estimations, Coordination, Quality Assurance, Client Liaison, User Assistance

Operating Systems: Windows 10 Enterprise, NT/2000, XP and UNIX

Business Areas: Healthcare, Finance (Private Bank, Retail Bank and Card Payments), Sourcing (HR and Supply Chain), Insurance, Sales and Retail

CAREER PROFILE:

Confidential

Senior Technical Lead

Responsibilities:

  • Derived technical requirements and come up with detailed Architectural model to deliver enhanced business analytics for USI data.
  • Working collaboratively with SME’s across business functions and articulate the Design in both Business and Technical terms.
  • Identify & articulate benefits and drawbacks of different technologies and approaches for the large-scale management
  • Working on quality controls and distribution of data across the project landscape.
  • Provided support for the development teams documented the strategies of IT target state
  • Working with technical team on explaining the various data integrations and helping them on technical solutions
  • Team co-ordination, work delegation with in team and follow up with daily activities
  • Come up with estimations and aligned with strategic group standards and initiatives
  • Highly collaboration between the Business and IT teams on handling with business requirements and solution strategies
  • Working on data analysis of various source systems like Salesforce, MDM, PRD, AUM, Morningstar, Sales Connect Workday, Goal sheet and documented use cases, solutions and recommendations.
  • Working on POC’s for new strategies and coordinating with technical teams on ongoing development of the project

Confidential

Business Solution Consultant &Technical Lead

Responsibilities:

  • Working with Confidential Business SME’s and understanding the business requirements, documenting them and creating of data sets and preparing data previews by using DBM.
  • Working on Intelligent data lakes and publish data into CASSANDRA on Hadoop framework once data sets are built.
  • Working with Confidential HRBT business users across 25 global locations which include US, Canada, CALA, EMEA and APAC regions and walk-through of previewing of data with combining of multiple worksheets from data assets.
  • Working with Global HR business team on understanding of CAAMS (Criterion Affirmative Action Management System) analytical process and come up with Business Requirements and Solution Strategies from various stages of recruitment to hiring process and continuous track of colleague’s events and performance life cycle
  • Working with technical team on explaining the data lakes and helping them on technical solutions
  • Involved in estimations starting from requirements gathering to until the SIT executions
  • Onsite and Offshore team co-ordination, work delegation with in team and follow up with daily activities
  • Involved in the strategies for historical data integration from PeopleSoft and ongoing data integration from Workday
  • Highly collaboration between the Business and IT teams on handling with business requirements and solution strategies
  • Managing the team of 25 (onsite 5 and offshore 20) and helping the team on familiar with Informatica and helping technical guidance where it required
  • Working on weekly and monthly status reports and presenting to IT stakeholders
  • Working with test leads during SIT support and reviewing of SIT scenarios, test executions and working with development team to fixing the defects if any
  • Working with Business teams during UAT support and explain the scenarios and get the sign-off process done from across the HRBT global users

Confidential, OR

Technical Architect/Manager/Lead

Responsibilities:

  • Involved in new diligence activities from CSC
  • Understand Requirements from KP business team and come up with multiple approaches data integration between across all sources within KP (Enrollments & Utilizations) and integrating into 3Rs program
  • Involved in high level design documentation and work with team to follow the build according to the design
  • Involved in estimations for each individual projects
  • Offshore team co-ordination, work delegation with in team and follow up with daily activities
  • Involved in the strategies for historical and incremental data integration design
  • Come up with solutions for Audit frameworks and exception handling frameworks
  • Come up with solutions for custom variable functionality which is an collaboration between the Business and IT teams on handling of multiple scenarios of the data
  • Managing the team of 20 (onsite 5 and offshore 15)
  • Working with test managers during SIT support on each project/identifying the right defects and working with DEV team to fixing of them
  • Working with Business team during UAT support and explain the scenarios and get the sign-off process
  • Working with DBA team to get the environments setup
  • Co-ordinate with ETL admin team for approvals for various scenarios and strategies
  • Involved in production deployments and handing over responsibilities to support team

Confidential, AZ

Project Manager/Technical Architect

Responsibilities:

  • Involved in new diligence activities from Syntel
  • Understand Requirements from Amex SME’s and come up with multiple approaches data integration between Sybase and Teradata
  • Prepare test strategy document for ELT and Data migration approaches
  • Involved in estimations for testing of 2000 tables
  • Offshore team co-ordination, work delegation with in team and follow up with daily activities
  • Involved in historical data testing between Sybase and Teradata
  • Come up with solutions for handling ongoing data in production environment as part of ETL approach
  • Involved weekly status and monthly review meetings with customer
  • Daily status meetings with in team
  • Involved in creation of test cases
  • Create defects in Quality Center tool and follow up with development team to address the defects
  • Providing technical solutions to team for any issues

Confidential, IL

Project Manager/Architect

Responsibilities:

  • Understand Requirements from onsite Business Analyst team and come up with multiple approaches on how to integrate data
  • Create and Design Technical Architect document for integrating OneBeacon historical data
  • Provided estimations for development, Unit Test and Data Loads
  • Provided ETL solutions to team where it required
  • Closely working with onsite PM to update on day to day activities of the project status updates from team on day to day basis weekly status reports to customer
  • Involved in internal audits (Equip)

Confidential

ETL Architect, Technical Lead and Analyst

Responsibilities:

  • Project life cycle (SDLC) - from analysis to production implementation, with emphasis on ETL design, development, Unit testing and handover the IDWH application to Production support team
  • Proposing solutions and giving multiple scenarios for the requirements
  • Provided estimations for PC mappings development and Unit Test cases along with Data Loads
  • Working with Business Engineering team and collect requirements
  • Involved in creation of ETL standards documentation
  • Involved in creation of Design documentation and define ETL approach.
  • Involved in creation of low level design documents for ETL mappings
  • Involved in creation of Unit Test documents for testing results
  • Provide ETL solutions to team where it required
  • Trouble shoot and problem solving for data issues and technical issues from end to end
  • Working as senior ETL developer for develop Informatica mappings based on Business Specifications
  • Analyze mapping specifications for fit in current requirements
  • Analyze data related issues and provide solutions
  • Involved in preparation of SIT, UAT and PROD release documents
  • Coordinating with QA and PROD team for all releases and where it required
  • Provide monthly review reports and present with management
  • Coordinating with QA and PROD team
  • Verifying and controlling the quality of services
  • Prepare test data for execute requirements in development and SIT environments if required
  • Provide test data with Business Engineers to validate
  • Performance Tuning
  • Informatica code migrations from one environment to other environment

Confidential, WA

ETL Tech Lead and Onsite Coordinator

Responsibilities:

  • Production support and Maintenance
  • Prepare documentations for support and maintenance manuals
  • Interact with Business users to define current and future application requirements
  • Provide monthly review reports and present them to customer
  • Prepare documentation for ETL load schedule window and checklist
  • Coordinating with Development and QA team
  • Verifying and controlling the quality of services
  • Initiate and execute Offshore positions
  • Prepare test data for execute requirements in SIT and UAT environment
  • Provide test data with Business users to validate
  • Performance Tuning
  • Servers maintenance and upgrading patches
  • Migrations from one environment to other environment
  • Informatica maintenance on weekly basis

Confidential, Seattle, WA

ETL Tech Lead/Onsite Coordinator

Responsibilities:

  • Onsite - Offshore Coordination
  • Prepare dataflow diagrams for execution of project
  • Prepare design documentation
  • Provide test data for business validation and sign off
  • Provide Informatica training to other team members
  • Initiate and Assign activities to Offshore team
  • Verifying and controlling the quality of services
  • Establishing Development Standards
  • Performance Tuning

Confidential, CA

ETL Technical Architect/Onsite Coordinator

Responsibilities:

  • Project Planning
  • Costing and Resource Scheduling
  • Onsite - Offshore Coordination
  • Working an Architect for Integrating Retail Cost data from CATMAN data
  • Working an Architect for Integrating Promotions from SIEBEL
  • Project Management and Task Allocation to the team
  • Effort Estimation
  • Verifying and controlling the quality of services
  • Team Building
  • Establishing standards and methodologies
  • Performance Tuning

Confidential, Milwaukee, WI

ETL Tech Lead - ETL Developer and Designer

Responsibilities:

  • Working with Business users (sourcing users and financiers) and Data Architect to understand the Business flow.
  • Design ETL Transformation specifications and data analysis.
  • Design BTEQ scripts in Teradata environment for improve performance.
  • Creations and modifications of ETL Maps using Informatica with Dragon technical team.
  • Prepare the Unit test plans with the sample data for user sign off and migrate into QA environment with co-ordination of QA team.
  • Analyze, extract the incoming Source data from Oracle Apps, Legacy systems for loading into EDW environment with cleaned and summarized information.
  • Dragon GEN 1 technical support and data validation with tech team and explain the reasons raised by Business Users if they have any queries.
  • Scheduling the jobs on production environment per the convenience of Business and dependency on other EDW loads.
  • Created our own Dragon specific X and Y combination of tables on Teradata environment for integrating the Sourcing data into EDW environment.
  • Design and Developed Flight Deck mappings and reports for high level sourcing business users and financiers by the co-ordination with web team.

Confidential, Milwaukee, WI

ETL Tech Lead - ETL Developer and Designer

Responsibilities:

  • Working an ETL Architect for Integration of Amersham sites into Dragon Datamart.
  • Creations and modifications of ETL Maps using Informatica according to specifications.
  • Modification of Shell scripts for extracting the data for Amersham sites
  • Interact with Business users and their technical team members for providing the Dragon format of data.
  • Communicated with Business users and their Tec team and asset them in understand the Dragon Source system.

Confidential, Milwaukee, WI

ETL Developer and Designer

Responsibilities:

  • Preparing Service Level Agreement documents for sourcing Applications.
  • Create MTR web related maps for Manual Price agreements and Forecast Applications of Global Supply Chain users.
  • Involved Regression testing for Oracle Apps Applications to extract the sourcing data.
  • Preparing ETL Transformation specification.
  • Creations and modifications of ETL Maps using Informatica.
  • Writing and modifying Shell scripts to support the loading.
  • Created the staging area (to avoid individual site loading) this keeps all sites information across the Globe.

Hire Now