SUMMARY:

• Overall, 20 years of experience in Enterprise Data Warehouse Development with proven expertise in system development activities including requirement analysis, design, coding, testing and deployment in ETL, Reporting/Dashboarding and Data Analytics Programs.
• Over 12 Years’ experience in Program/Project and Team management with global customer and relationship management skills
• Well - versed in developing Data Models for different Enterprise Data Warehousing implementations and has a thorough understanding of the entire lifecycle process for a Data Warehouse project executed in Agile, Iterative Waterfall and Dev-ops models.
• Extensive experience in working on cloud platforms (Azure, AWS) working on multiple ETL Services like Data factory, NIFI, SQOOP Frameworks, working on Notebooks written in Python, Databricks and Storage Solutions like S3, SQL MI, Snowflake and reporting Solutions like Power BI, Tableau
• Conversant with quality procedures, while executing his projects and has good knowledge of Manufacturing, Banking & Financial, Automobile, and Retail marketing Applications.
• Proficient in working with IT/Business managers to effectively prioritize activities and achieve defined objectives.
• Extensive familiarity with Cloud Implementation using platforms like AWS and Continuous Integration using Bamboo, Jenkins and Delivery Setup using JIRA/Confluence
• Results-oriented IT leader with experience in creating technology delivery teams and leading large-scale, complex technology implementations.
• Collaborated with client business leaders, executives, SMEs in IT and business stakeholders on full life cycle engagements.
• Successful in consistently translating business requirements into IT solutions. Creative and innovative thinker, bringing energy, enthusiasm and leadership to problem resolution.
• Respected Program Manager with a demonstrated ability to train and motivate geographically dispersed teams to exceed established goals. Highly skilled at interfacing with the customer and resolving their issues with a quick turnaround time.
• Demonstrated success many times under aggressive project schedules and deadlines. Flexible, result-oriented and adapts to the environment quickly to meet the goals of the product and organization.
• Very hard working, enthusiastic and highly committed to the growth and success of the organization. Possesses a good work ethic and high level of integrity and has experimented with new technologies and routines to increase efficiency and cost savings for the customer.
• Involved in Managing project scope, budget and schedule, interacting with various business users, Estimation and Planning, Setup of Program milestones, High-level System design, offshore team management, Scorecard preparation and tracking for senior management review.

Technical Skill

LANGUAGES: JAVA, VISUAL STUDIO. NET, PL SQL, PYTHON, SCALA

Databases: MSSQL, Oracle, Big Data, Hadoop, MongoDB, Exadata, Snowflake

GUI: Visual Studio, Swing, Eclipse, Salesforce

Web Related: ASP, HTML, PHP, Cold fusion, Perl, JAVA, Servlets, COM, ASP.NET, VB.NET., JSP, AJAX, Angular JS, Node JS, React Framework.

DW Tools & Utilities: DB2, SQL Server, Informatica, Business Objects, WebSphere Studio, ERWIN, Cognos Suite including power play, TM1 and Executive ViewerOracle BI Enterprise Suite, QlikView, Vertica, Tableau, Greenplum, ARE, Motio CI

Domain Knowledge: Finance, Manufacturing, Insurance and Automotive, Marketing, Media, Telecom

Project Management: Agile, Iterative and Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Manager - Technical Delivery

Responsibilities:

• Involved in the Implementing the Road map for Data Governance, Data Quality Framework in Rogers by setting up DQ/DG Tools like IDQ/BDM/EDC and Axon.
• Piloted the Cloud Migration Program on Premise Hadoop/Exadata environment to AWS/Azure Cloud.
• Managed Multiple Vendors to support the Solaris Ignite Program which brought DQ Checks around IPTV, Household Experience Metrics and Home Monitoring Solutions into Rogers Enterprise Datawarehouse.
• Manage a team of 50 Members onsite and offshore including new proposals, Budget Estimation, Resource Capacity Planning and Risk Management.
• Involved in SAFE Agile Practices and was part of Multiple PI Sessions to define quarter-wide Program Increment Objectives and collaborating with multiple business teams to set the business value and priority.
• Managed External Enterprise QA and Defect management teams to Triage and work on multiple bugs/enhancements and coordinate with other business partners from Comcast, Bell, Shaw etc.
• Involved in building Cross- platforms to ensure KT/Backup plans thereby enhancing team efficiency so that Team/Vendor churns do not impact Sprint Velocity.
• Worked on Multiple scrums at the same time to prioritize User stories and ensure the optimum scrum velocity was maintained.
• Constantly reviewed the technology stack and frameworks to ensure the right tools that provide optimum business solutions were used in the currently running projects.

Confidential

Technical Architect/Technical Delivery Manager.

Responsibilities:

• Involved in the Migration of Migration of DataStage, TM1 Environments from On-premises to AWS Cloud Environment.
• Manage a team of 20 Members onsite and offshore including new proposals, Budget Estimation, Resource Capacity Planning and Risk Management.
• Supported the team in the Design and Development of the complete architecture starting from the sources down to the extracts needed for the downstream systems which included the MapR Staging layers, and the PDL DataMart layer built on Netezza, TM1 Models and the Cognos Semantic Layer.
• Design and Development of the ETL Mappings that would support the load of MapR Staging layer and PDL DataMart load activities.
• Design and Build Scripts that would support landing and curation of Source data in MapR big data layer and build Apache Drill views to query and transform large sets of data.
• Design and build TM1 Models and Cognos Semantic Layer to support Analytical and reporting needs which include Core Reports, Merchandise Planning reports, Inventory Build Reports and Store Patterning Reports.
• Support/Coordinate in the Global rollout of the Platform and cloning of architecture in the Western Region.
• Implement Data Governance and Data Strategy frameworks to adhere to global data requirements.
• Introduction of more streamlined project management methodologies.
• Manage Iterative Project management model interfacing with various teams which included Business Analysts, ETL/TM1/Cognos developers, QA Analysts, Performance Engineers and testers and UAT testers. JIRA and Confluence was used to Create/Review of Project documentation and Kanban boards for tracking the progress of projects.
• Setup Capacity and resource management calls to bring transparency on resource utilization.

Confidential

Technical Architect

Responsibilities:

• Directly report to the CFO of the Organization providing strategy, Roadmap for the IT/Analytical Department
• Manage a team of 15 Members onsite and offshore including new proposals, Budget Estimation, Resource Capacity Planning and Risk Management.
• Supported the team in the Design and Development of Salesforce ODS and Datamart built-in MS SQLServer that would handle all the Adhoc reporting needs of the sales customer.
• Design and Development of the ETL Mappings that would support Stage to ODS and ODS to Datamart Data load activities.
• Design of additional interfaces that would support the integration of ESB systems like Mule soft to the Stage layer and provide automated data load at near real-time frequencies.

Confidential

Engagement Manager/Technical Architect.

Responsibilities:

• Directly report to the CTO, CIO of the Organization providing strategy, Roadmap for the IT/Analytical Department
• Manage and support a team of Designers and Developers to build an end-to-end Analytical Platform and conduct workshops to finalize the requirements with the stakeholders and provide a strategic vision of the tools to be used.
• Review the cloud architecture and identify security vulnerabilities and provide recommendations.
• Design, build and Support Data models, ETL Mappings and Dashboards to support the complex requirements of the platform which included Descriptive and Predictive Reporting needs.
• Support in the Global rollout of the Platform and cloning of architecture in various global AWS regions.
• Implement Data Governance and Data Strategy frameworks to adhere to global data requirements.
• Share capabilities around Big Data Analytics by bringing in Social listeners to enhance the accuracy of the Predictive models.
• The Following Skills were used in this project
• Worked as a Scrum Master/Program Manager for multiple projects which included Analytical, Mobile and Web Platform development.
• Managed Multiple global vendors to handle multiple areas of the project functions including Testing, Development.
• Participated in multiple Resource recruitment drives to find the right talent from Canada to run various programs for Cognizant Canada
• Architect/Design/Develop web applications using Technologies like Angular JS/NodeJS/React and Testing frameworks like Mocha/Chai.
• Architect/Design/Develop Mobile Apps using React Native Framework which is compliant with both IOS and Android platforms.
• Build ETL Mappings using RedPoint Data Manager Tools and implement Customer matching logic.
• Build dashboards using Tableau and Data analytics using SAS, Python and R with data residing on Hadoop, Spark.
• Proposed global AWS Architecture recommendations including Firewall evaluations.
• Involved in the Splunk implementation for SOC Setup
• Involved in Designing and implementing the AWS Continuous Integration Deployment/Delivery Architecture/Process.
• Designed and Architected the Data Science Lab and Refinery in AWS Cloud Infrastructure.
• Migrated Legacy Servers by integrating and upgrading Software that was not compliant on the Windows 2012 R2 Platform.
• Implemented the global rollout of the AWS Cloud infrastructure to various regions including Asia and Europe.

Confidential

Program Manager/Technical Architect

Responsibilities:

• Played a key role in architecting the Meta data-driven Data warehousing model which was key to the success of the program. Also, played the role of Reporting Architect managing the QlikView/Cognos Teams in building a Semantic Layer that supported Cross context reporting and Self Service Analytical BI Platform.
• Worked on building the team from 5 Members to a 50 Member team in the span of 3 months also was spearheading initiatives to reduce the defect leakage in QA by introducing concepts like Bug bash, Fisheye Integration for Code reviews and imposing better change management processes in place using SVN/ALM and Confluence.
• Involved in creating multiple dashboards for Audit Trail and Data Quality Tracking which provided capabilities for generating metrics around Data Accuracy and completeness which in turn supported many regulatory requirements like BCBS 239.
• Built Data Reconciliation frameworks to support data validations across Source/Landing Zone, Data warehouses and DataMart’s. POCs were performed in Lavastorm, ARE and Query Surge.
• Defining the overall structure of the program acting as the project manager, overseeing various streams of activities, and ensuring all parts of the project run smoothly.
• Participating as a solution architect in requirements gathering; recommending ETL solution designs and building of data integration/Reporting/Analytics platforms.
• Modifying/developing data access processes by client policies, procedures, and security standards.
• Working closely with the business functional areas, technical teams, and clients to define systems/project priorities, scope, approach, resource requirements, timing deliverables and funding.
• Developing project plans specifying goals, strategy, dependencies, staffing, scheduling, contingency plans, and allocation of resources.
• Identifying and scheduling project deliverables, milestones, and required tasks.
• Assigning tasks, and responsibilities and driving accountability to project team members in a matrix environment.
• Managing/Co-coordinating with partners/Stakeholders and working groups engaged in project work. Liaising with, and updating progress to, project board/senior management.
• As a technical architect was involved in the end-to-end architecture of Reporting frameworks built using Cognos and QlikView. Was involved in creating/reviewing and enhancing reports built-in Cognos 10 Report Studio and Workspace advanced.
• Participated in Tool evaluation exercise building/showcasing reporting capabilities of Jaspersoft as a low-cost viable option for Risk Reporting and Dashboarding requirements.