SUMMARY

• 12 years of IT industry experience encompassing wide range of skill sets, roles and industry verticals. Currently Canadian PR card holder & looking for challenging opportunities.
• Experience in Onsite lead and co - ordination. Communicating with the client and understanding the requirements and providing solutions to optimize business.
• Experience in working Waterfall & Agile methodology and represented as Team Lead in scrum meetings.
• Extensive experience with analysis, design, development, CI/CD implementation, customizations and implementation of software applications including Batch Processing, Client Server, Application Automation etc.
• Proficient in analysing and translating business requirements into technical requirements.
• Expertise knowledge of Service Now and IT Service & Remediation Management process.
• Strong Data Architecture knowledge, Data Integration, Data Analysis skills, ETL expertise, Data Modeling expertise, Data Governance concept, Big data knowledge, Batch Processing, Object Oriented Programming, Data Masking, Data Mining & Development knowledge, Script (shell, python) language expertise, Data Cleansing expertise, NoSQL database concepts, BI Tools exposure, AI/ML techniques.
• Experience in Onsite Co-ordination and Client handling, Requirements analysis and provide a solution, interactions with cross-functional groups (DevOps, Quality Engineering, Business Analysts etc.).
• Experience in leading and managing teams. Handled multiple roles - Data Architect, Team Leader, Module Leader, Team Member and Developer. Lead multi-million-dollar projects.
• Executed software projects for various domains from Banking & Financial Services, Insurance (Auto, P&C), Information & Media, Life Sciences, Travel & Hospitality and Retail.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player, tech savvy.
• Strong data management, man management and time management skills.

TECHNICAL SKILLS

Platform/OS: UNIX, IBM AIX, Windows, Linux, Microsoft Azure

Languages: SQL, PL/SQL, UNIX Shell Scripting, Python, PL/PgSQL, XML

Databases: Oracle, DB2 UDB, Greenplum, Sybase, MS SQL, MS Access, PostgreSQL

Programming Tools: Erwin, Enterprise Architect, ODI, SQL Developer, DBArtisan, Toad, UCD, AutosysServiceNow, Putty, C D, Jenkins, Winscp

Network Communication Tools: Citrix (VPN)

Version Control Tool: Subversion, Integrity Client, HP Quality Center, Perforce, JIRA, SharePoint

Web Technologies: HTML, JS

Application Server: IBM Websphere, Oracle 9i/10g/11g/12c Application Server

Applications: MS Office Suite

BI Tools: Tableau, Cognos

PROFESSIONAL EXPERIENCE

Data Modeler/Architect

Confidential

Responsibilities:

• Creating data vault model for the business intelligence processes.
• Developing raw and business data vault models for the application requirement.
• Enforcing standards and guidelines are used to develop the application and database design.
• Assisting data analysts and developers for application integration.
• Planning and execution of the new BI architecture for the entire organization through event driven process.
• Developing and enforcing data modeling standards and best practices.

Senior Data Architect

Confidential

Responsibilities:

• Organizing and managing the technical DATA team of data architects, data modelers, engineers and providing leadership, guidance, and mentoring.
• Developing conceptual and logical information models within the context of the Enterprise and Line of Business Information Architecture.
• Ensuring that DW/BI standards and guidelines are used to develop the information models and database designs.
• Works with Data Engineers, DBA’s as part of Database Design and Development.
• Develop and maintain Enterprise Data Models for Enterprise Class Data Initiatives.
• Developing and enforcing data modeling standards and best practices.
• Implemented Change data capture (CDC) concept for staging database.

Senior Data Consultant/Data Architect

Confidential

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analysed database requirements in detail with the project stakeholders by conducting joint requirements development sessions.
• Developed Data Vault modelusing Erwin based on requirements analysis.
• Created and modified logical and physical data models using a variety of data modeling philosophies and techniques including Inmon or Kimball.
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for loyalty applications.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Performs data analysis and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using Erwin.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed and implemented measurements for various marketing campaigns.
• Defined the data governance policies and strategy and also worked on data security.
• Assisted junior developers in data profiling for each subject area of data mart.
• Created notebooks for the data access in the azure data lake. Define ETL framework for azure cloud.

Data Consultant/Data Architect

Confidential

Responsibilities:

• Preparation of Database designing of various model such as Conceptual, Logical, Physical.
• Integrated multiple logical data models into a single data model. Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Created 3NF dimensional modelling structure for datawarehouse application for downstream BI solution.
• Created data integration plan and implemented data-centric project methodology.
• Expertise knowledge of Service Now and IT Service Management process (Incident, Change).
• Created various design and application document on SharePoint for business users.
• Defining data flow across systems and developing new application w.r.t current business requirements.
• Data warehouse extracted datatransformation for target financial hub as per customer requirement.
• Plan and Design of Data mart and ODS repositories.
• Designed & developed data migration plan for Greenplum and Python based platform.
• Performed data quality analysis through SQL based profiling (column profiling, single table and cross table analysis) for the client data sources using Oracle PL/SQL.
• The solution included DB2 configuration, data modeling, and identification of trusted data sources, database creation, and ETL processes in PL/SQL & PL/pgSQL.
• AssistedDataHubArchitect in data model enhancement and gap analysis.Designed LDAP schemas for enterprise.
• Created intermediate data model for Tableau backend for ease of data pipeline.
• Assisted BI developers in designing Tableau dashboard and helping in data extraction.
• Autosys 4.5 & r11 job enhancement and monitoring job alerts for Production support group.
• Mentored and Groomed junior developers during the development phase. Helping and guiding developers in python and PL/pgSQL development.
• Assisted AI/ML team to implement data profiling, gap analysis, anomaly detection out of the data mart.

Onsite Tech Lead

Confidential

Responsibilities:

• Played the roles of a Development Team leader and onsite SPOC for Data Architect role. Leading the team for providing ETL solutions to client.
• Designed conceptual data model based on the requirement, interacted with non-technical end users to understand the business logics. Built the logical & physical data model for customer review and approval.
• Worked in Agile framework and worked as Team Lead. Participated in daily scrum meetings to discuss and resolve day to day incidents & delivered the software component in time.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Oracle PL/SQL, shell script to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
• Chair weekly meetings with clients, managers and vendors to report, discuss progress and resolve issues.
• Identify gaps and impact analysis and document them. Attend to and resolving high priority issues which impact business. Often explaining and guiding offshore team members through resolution.
• Lead teams in multiple complex development activities and closely worked with managers to track project health and development progress.
• Automated various client application using Unix shell scripting, Python, SQL, PL/SQL, Autosys etc.
• Implemented data masking feature for multiple application in client system for data security purpose.
• Performed lead role for database upgrade from Oracle 11g to 12c PDB. Impact analysis and post migration validation using batch jobs and shell programming.
• Performed the role of subject matter expert, mentor, technical lead and trained new team member on real time systems.
• Provided Effort estimates, scope Analysis, and managed migration risks for critical applications. Also implemented quality assurance processes of the organization.
• Delivered new and complex high-quality solutions to clients in response to varying business needs using PL/SQL, Shell scripting & Python scripting.
• Responsible for managing scope, planning, defect tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provided day to day direction to the project team and regular project status to the customer.
• Migrated FTP jobs from ftp to IBM Connect:Direct solution. Active directory setup for enterprise solution.
• Development and production release of code, custodian for each monthly Production code release.
• Preparation of the test plan and subsequently test the assigned work.
• Modification of the functional documentation and prepared HLD & DLD.
• Performance improvement, code review, daily application maintenance.

Module Lead

Confidential

Responsibilities:

• Responsible for leading the corresponding module team and delivering solution to the customer.
• Prepared, processed numerous customer input files; parsed and reformatted the data to meet product requirements
• Executed data model using ERwin data modeling tool.
• Data model analysis for the Logical model and giving solution for the actual requirement.
• Data load implementation using PL/SQL. Scheduling batch jobs using Linux environment.
• Integrated data quality plans as a part of ETL processes.
• Debugged existing ETL processes and did performance tuning to fix bugs.
• Delivered new and complex high-quality solutions to client in response to varying business requirements.
• Responsible for providing support to data loading modules. Analysed the requirement specification and designed the solution and also implemented the coding including the integration.
• Co-ordinated and managed the business communications by arranging and participating in regular client calls. Analysed most of the DFS (Detailed Functional Specification) to come out a solution that client was looking for.
• Overall responsible for developing the data LOADER program from staging database, which loads the huge amount of data in Target Production environment using the ODI tool.
• Onsite Co-ordination and Client handling, Requirements analysis and provide a solution analysis, interactions with cross-functional groups.
• Very much involved in Deployment activities for ODI and database change/developed code. Development and UAT release of code written in SQL & PL/SQL.
• Preparation of the test plan and subsequently test the assigned work. Implemented the entire test plan and captured the output for next process.
• Maintained Defect Tracker in HPQC and update the status for each of the defects which are maintained there.
• Analysed the data model and converted the BOM (Business Object Model) to real world database objects.
• Engaged in data profiling to integrate data from different sources.
• Providing the report of Entity relationship of the Logical & Physical data model.
• Performed data analysis on the production environment and adjusted solutions accordingly.

SQL Developer

Confidential

Responsibilities:

• Analysed the data model and converted the BOM (Business Object Model) to real world database objects.
• Engaged in data profiling to integrate data from different sources.
• Performed the gap analysis and impact analysis.
• Responsible for mapping the business objects to database objects and finding their relationships.
• Providing the report of Entity relationship of the Logical & Physical data model.
• Performed data analysis on the production environment and adjusted solutions accordingly.
• Developed and tested extraction, transformation, and load (ETL) processes.
• Importing & exporting user schema from one to another.
• Testing, deployment and day to day project management.
• Maintained Defect Tracker in company portal and updated the status for each of the defects which are maintained there.