SUMMARY:

• Extensive experience in the Information Technology industry with expertise in Data Modelling for Data warehouse development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/ Business Intelligence (BI) Applications
• Exposure in overall SDLC including requirement management, client interactions, application and database design, development, testing, deployment, and support
• Experience of involving in various projects related to Data modelling, Data Analysis, Database Design, and development for both OLTP and Data warehousing environments
• Proficient experience in working on Conceptual, Logical and Physical database models in compliance with enterprise standards using Data Modelling tools such as Erwin R9 and MS Visio for both OLAP and OLTP applications
• Practical understanding of Data Modelling (Dimensional and Relational) concepts such as Star Schema, Snowflake Schema while designing Facts and Dimensions
• Good understanding of views, synonyms, functions, procedures, packages, cursors, triggers, indexes, joins, partitioning, and query tuning for better database performance
• Strong knowledge of RDBMS such as SQL Server 2008 R2/2014, Oracle, IBM DB2 and database languages SQL and PL/SQL
• Good experience in Extracting, Transforming, And Loading (ETL) data using SQL Server Integration Services (SSIS), Informatica PowerCenter as well as using Shell Scripting
• Comprehensive knowledge and experience in process improvement, normalization/de - normalization, data extraction, data cleansing, data manipulation
• Experience in implementing Slowly Changing Dimensions - Type I and II in Dimension tables as per the requirements
• Experience in establishing and maintaining comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships
• Experience in developing mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, domain definitions and corporate metadata definitions
• Experience working on C, C++, and Core Java development projects
• Result oriented software developer with excellent track record of successful completion of projects, project milestones and quality standards
• Proficient in problem solving and self-motivated and driven professional, able to work with minimal supervision, and able to exercise good judgment to keep critical systems operational
• Experience in mentoring the junior developers and resolving their difficulties also conducting sessions for junior developers for their better understanding of various topics
• Ability to work within a fast-paced environment, and interact supportively within a team

TECHNICAL SKILLS:

• Databases: MS SQL Server 2008 R2/ 2014, Oracle 10g/ 9i, IBM DB2 9, MS Access 2000
• ETL Tools: SQL Server Integration Services (SSIS), Informatica PowerCenter
• Data Modeling Tools: Erwin R9, MS Visio
• Scripting: UNIX Shell Scripting, Perl Scripting
• Database Languages: SQL, PL/SQL
• Programming Languages: C, C++, Java, Pro*C
• Scheduler Tools: AutoSys 11.1, Crontab
• Software Engineering Tools: GitHub, JIRA, MS TFS, CA SCM, Visual SourceSafe, SVN
• Other Tools: Oracle TOAD 12, Azure Cloud, PuTTY, WinSCP, Eclipse Helios, Beyond Compare, Notepad++
• Other Technologies/ Skills: XML, HTML
• Operating Systems: Linux, UNIX (AIX), MS Windows XP/ Vista/ 7.0
• BNFS (Banking, Corporate Treasury, Cards and Payments sub - domain), Retail, Gaming

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler / Lead ETL Solution Designer

Responsibilities:

• Collaborated with Business teams, Technology Manager, Technical team and Architecture team to convert functional and technical specification to a high-level design from technical perspective
• Developed a Conceptual and Logical model using Erwin based on requirements analysis
• Created dimensional data model for Credit reporting application by identifying dimensions and facts using Erwin tool and conducted data model reviews with Project Architecture and Technology Manager
• Designed ETL solution to bring data from different SOD sources to populate staging tables
• Created data loading processes by using SQL Server Management Studio, ETL jobs using SSIS tool, SQL Server development
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Involved in SQL performance tuning, job optimization, creating and refactoring ETL packages to transfer data from source to Corporate Treasury data mart using Microsoft SSIS, SQL Stored Procedure and Autosys scheduling
• Used reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Worked closely with system of records partners, subject matter experts, and business owners to understand the data requirements, carry out data analysis and subsequently help with design of the data mart
• Involved in planning and scheduling assignments with his team on a daily basis
• Worked on source control tool like GitHub, TFS/SVN in order to integrate the development work with that of rest of the team and help in production deployment activities
• Was responsible for creating scripts for application deployments to different environments like DEV/SIT/QA/UAT/PFIX. These scripts involve writing database queries, database release scripts and other database related activities required for application development

Environment: MS SQL Server 2016/ 2014, SSIS, SSMS v17, Visual Studio 2015, Azure Cloud, Erwin r9.3, MS Visio 2016

Confidential

Database Programmer/ ETL Developer / Data Modeler

Responsibilities:

• Collaborated with Data Architect and BSA team to understand aggregation logic and other project requirements
• Conducted an analysis of current Securities data systems and information resources
• Used ETL (SSIS) to develop jobs for extracting data from files received from various SORs, cleaning, transforming and loading data into Confidential database
• Created data model using MS Visio and conducted data model reviews with project team members
• Involved in creating multiple parameterized Stored Procedures, which were used by the User Interface team to show on screens
• Set up proper folder structure in Team Foundation Server (TFS) system and checked in code to it
• Created AutoSys jobs to schedule various ETL packages that extracts data from various SOR files
• Deployed code to cloud using TFS and Enterprise Cloud Management Portal
• Set up NDM tunnel by requesting DMT requests to NDM and DTS teams and worked with them
• Optimized SQL queries to reduce the run time
• Performed index optimization wherever required
• Reviewed codes and test cases prepared by team

Environment: MS SQL Server 2016/ 2014, SSIS, SSMS v17, Visual Studio 2015, MS Visio, Azure Cloud

Confidential

Database Programmer / ETL Developer

Responsibilities:

• Collaborated with production support and development team to understand current issues in monthly load process
• Performed analysis of the existing Confidential system and identified potential issues that could cause long running monthly load process
• Designed an advanced Logging Framework to capture end-to-end system activities that will help Client’s Consumer Lending team to track their monthly load process for Confidential system and shared it with client for approval
• Drafted a high-level detailed document based on system analysis and solution provided
• Conducted design reviews with project team members and resolved their queries
• Coordinated with offshore team on daily tasks and JIRAs assigned to track the schedule and assured the quality of deliverable
• Modified existing jobs, Stored Procedures, and SSIS packages to add new logging framework
• Analyzed and documented newer available SQL Server versions 2012 and 2014 to help client to migrate database to newer version
• Analyzed and documented Side-By-Side upgrade Vs. In-Place Upgrade methodology for SQL Server and helped Confidential team in choosing better approach
• Actively participated on setting up software and configurations on new Confidential environments for SQL Server migration project

Environment: MS SQL Server 2008 R2/ 2014, SSIS, SSMS, Visual Studio 2010/ 2015

Confidential

Data Modeler/ ETL Developer

Responsibilities:

• Collaborate with data architect and BSA to gather business requirements and based on that define reporting requirements
• Analysis of the business requirements in detail with the project stakeholders and identification of gaps in the requirements
• Identified, formulated and documented detailed business rules based on requirements analysis
• Responsible for writing the functional specifications of reports, mapping of reporting requirements to the database attributes
• Develop a Conceptual model using CA ERwin based on requirements analysis
• Conduct data model reviews with project team members
• Capture technical metadata through data modeling tools
• Prepare data objects (DDL) script using forward engineering functionality of Data modeling tool (ERwin)
• Designed and developed an ETL solution that extracts Gift Card transaction data from various systems across the enterprise, transform according to business requirements and load into data warehouse repository
• Create and maintain High level design, Requirement traceability matrix to capture all requirements
• Enforce standards and best practices around data modeling efforts
• Optimization of SQL queries to reduce the run time. Performed index optimization.
• Share task to offshore on weekly basis, resolve their queries and get it completed
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures

Environment: Oracle 11g, UNIX, Informatica PowerCenter, Erwin R9, SQL, PL/SQL, Shell Scripting, Perl Scripting, AutoSys 11.1