Senior Consultant (Project Lead) Resume Kansas City, MO - Hire IT People

SUMMARY

Over all 11+ years of experience in IT Industry.
6 years onsite experience in Client handling, Onsite offshore co - ordination and Deployment activities.
Experience in design and development of Data Warehousing solution using IBM InfoSphere DataStage 11.7.
Experience in Data Warehouse Architecture & Technology including Data mart, Dimension Modeling (Star Schema / Snow Flake Schema).
My experience also includes Designing, Development, Testing, Implementation and Support on DataStage.
Facilitate and plan for GO-LIVE activities for the Squad.
Experience in Autosys and Control-M scheduling tools.
Experience in Shell Scripting, Qlik Data Catalyst (ETL tool for data lake).
Technical expertise in Data warehousing and ETL concepts.
Extensively involved in Unit Testing, Integration Testing, System Testing and User Acceptance Testing.
Experience in working and Interacting with client/BA for system study, requirements gathering and analysis.
Worked with the developers to ensure that best practices are implemented in leveraging the code to make best use of it.
Experience in the post production support of the application developed and provided 24x7 supports for the production issues and resolved critical issues within the SLA during warranty period.
Possess knowledge of Mainframe Cobol and CICS web services.
Possesses knowledge of Big Data and AWS.
Ability to learn new tools and software quickly.
Certified AWS Solution Architect associate.
Certified Tableau desktop specialist.

TECHNICAL SKILLS

Technology: InfoSphere DataStage 11.3,11.7, AWS

Database: Oracle, SQL Server, HDFS

Operating System: Windows 10/7/2000 and UNIX, ZOS

Programming Language: SQL, PL/SQL, shell scripting, COBOL, CICS, XML

Software Products: JIRA, ServiceNow, SOAP UI, BugZero

Scheduling Tool: BMC Control-M Automation 8.0 and Autosys

ETL Tools: DataStage 11.3, 11.7, Qlik Data Catalyst

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Senior Consultant (Project Lead)

Environment: UNIX and Windows.

Responsibilities:

Working closely with client in application migration and merger projects impacting Data warehouse and its interfaces.
Working with the Business Architects, providing subject matter expertise and consultation that drive the analysis and design of quality technical solutions to Sun Life.
Creating of Unit test plans and test data.
Creating data ingestion jobs and workflows in Qlik Data Catalyst, a ETL tool to load data from oracle, SQL, Flat files into Data lake.
Designing/Development of the ETL jobs using the various DataStage Stages, depending on the scenario.
System testing support, defect fixing, data loading support and User acceptance testing support.
Designing ISD web services for projects involving real time results from oracle, DB2 and VSAM datasets
Preparing and maintaining application overview documents.
Providing project baselines, estimations, schedules and delivering project objectives on time with quality
Managing the offshore team, providing them with directions, delegating tasks, demand and capacity management.
Working on POC’s and converting them into projects for the organization.

Confidential

Senior Software Engineer (Mainframe Developer)

Environment: Mainframe Z/OS, Windows and UNIX.

Responsibilities:

Owned the Multiple Project Modules build, ST/UAT testing as per requirement provided by Data Science Architect and Business.
Working on service tickets assigned by team lead.
Creating design documents for service requests.
Resolving aborts, abort fixing and daily status reporting to onshore lead.
Prototyping, designing, coding and unit testing the code and providing support after production deployment.
Creating UTCs and test completion reports
Creating and validation of mainframe packages.