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 teh client and understanding teh 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 noledge of Service Now and IT Service & Remediation Management process.
• Strong Data Architecture noledge, Data Integration, Data Analysis skills, ETL expertise, Data Modeling expertise, Data Governance concept, Big data noledge, Batch Processing, Object Oriented Programming, Data Masking, Data Mining & Development noledge, 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, Autosys,ServiceNow, 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 teh business intelligence processes.
• Developing raw and business data vault models for teh application requirement.
• Enforcing standards and guidelines are used to develop teh application and database design.
• Assisting data analysts and developers for application integration.
• Planning and execution of teh new BI architecture for teh entire organization through event driven process.
• Developing and enforcing data modeling standards and best practices.

Senior Data Architect

Confidential

Responsibilities:

• Organizing and managing teh technical DATA team of data architects, data modelers, engineers and providing leadership, guidance, and mentoring.
• Developing conceptual and logical information models within teh context of teh Enterprise and Line of Business Information Architecture.
• Ensuring that DW/BI standards and guidelines are used to develop teh 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 teh 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 teh requirements from teh 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 teh 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 teh data access in teh 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 noledge 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 teh client data sources using Oracle PL/SQL.
• Teh 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 halping in data extraction.
• Autosys 4.5 & r11 job enhancement and monitoring job alerts for Production support group.
• Mentored and Groomed junior developers during teh 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 teh data mart.

Onsite Tech Lead

Confidential

Responsibilities:

• Played teh roles of a Development Team leader and onsite SPOC for Data Architect role. Leading teh team for providing ETL solutions to client.
• Designed conceptual data model based on teh requirement, interacted with non-technical end users to understand teh business logics. Built teh 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 teh software component in time.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Oracle PL/SQL, shell script to extract teh data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to teh Staging area, EDW and then to teh 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 teh 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 teh 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 teh project.
• Responsible for effective communication between teh project team and teh customer. Provided day to day direction to teh project team and regular project status to teh 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 teh test plan and subsequently test teh assigned work.
• Modification of teh functional documentation and prepared HLD & DLD.
• Performance improvement, code review, daily application maintenance.

Module Lead

Confidential

Responsibilities:

• Responsible for leading teh corresponding module team and delivering solution to teh customer.
• Prepared, processed numerous customer input files; parsed and reformatted teh data to meet product requirements
• Executed data model using ERwin data modeling tool.
• Data model analysis for teh Logical model and giving solution for teh 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 teh requirement specification and designed teh solution and also implemented teh coding including teh integration.
• Co-ordinated and managed teh business communications by arranging and participating in regular client calls. Analysed most of teh DFS (Detailed Functional Specification) to come out a solution that client was looking for.
• Overall responsible for developing teh data LOADER program from staging database, which loads teh huge amount of data in Target Production environment using teh 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 teh test plan and subsequently test teh assigned work. Implemented teh entire test plan and captured teh output for next process.
• Maintained Defect Tracker in HPQC and update teh status for each of teh defects which are maintained their.
• Analysed teh data model and converted teh BOM (Business Object Model) to real world database objects.
• Engaged in data profiling to integrate data from different sources.
• Providing teh report of Entity relationship of teh Logical & Physical data model.
• Performed data analysis on teh production environment and adjusted solutions accordingly.

SQL Developer

Confidential

Responsibilities:

• Analysed teh data model and converted teh BOM (Business Object Model) to real world database objects.
• Engaged in data profiling to integrate data from different sources.
• Performed teh gap analysis and impact analysis.
• Responsible for mapping teh business objects to database objects and finding their relationships.
• Providing teh report of Entity relationship of teh Logical & Physical data model.
• Performed data analysis on teh 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 teh status for each of teh defects which are maintained their.