SUMMARY

• Over 15 years’ experience as Consultant, DBA, Solution Architect, Data Architect, Data Warehouse Architect, Project Coordinator, Project Manager, Developer and (or) Analyst supported IT & Business initiatives.

TECHNICAL SKILLS

• SQL Server 2008/2012/2014/2016 & supporting tools (SSMS, SSIS, SSRS & SSAS), TFS, Informatica PowerCenter
• Data Modeling: Erwin
• MongoDB (NoSQL) Database, PostgreSQL, JavaScript
• VBA, Python and Microsoft Excel.
• Mainframe technologies (JCL, COBOL, IMS/DB, IMS/DC, CICS and DB2) and C language.
• Oracle & FoxPro
• MS Office, Visio & Power Point
• Agile/Waterfall
• Big Data Hadoop framework Foundation.
• MDM, Tableau, Task Factory, jQuery, HTML, CSS, JavaScript

PROFESSIONAL EXPERIENCE

BI SQL Architect

Confidential

Responsibilities:

• Over 1+ years’ experience as BI Architect/Consultant for Recruitment Data Warehouse
• Over 1.5 Years’ experience with leading IT Technology Organization ( Confidential - Confidential ) Converged Infrastructure Platform applications with a primary focused with DBA, Data Architecture & Database Developer using SQL Server and supporting tools (SSIS, SSRS, SSMS), PostgreSQL and MongoDB (NoSQL) Databases along with JSON/JavaScript.
• Over 0.5 Years’ experience with fortune 100 Global agribusiness Organization ( Confidential Inc.) with Data Analytics initiatives using SQL Server, BI Tools and Python.
• Over 5+ Years’ experience with Healthcare Recovery Audit Business Unit ( Confidential Inc.) for Center for Medicare & Medicaid Services initiatives with Data Warehouse and (or) .Net Projects using Microsoft Technologies and related Database tools (SSIS, SSMS & SSRS). Involved with Technical and Project coordination responsibilities.
• Having 10+ Years’ experience with CMM Level 5 IT Outsourcing Consulting Services as Developer/Project Coordinator using Legacy Mainframe Technology Systems using DB2 & IMS/DB Databases.
• Managed/Coordinated Outsourcing Initiatives as Project Coordinator.
• Over 9+ years’ experience with Leading Healthcare Payer Client Engagements ( Confidential, United Healthcare and Cigna Healthcare) - Developer, Data Architect, SQL Programming and (or) Data Analytics responsibilities
• Over 3 Years’ experience with one of the Leading Manufacturing Client Engagement (Caterpillar Inc.).
• Over 2+ Years’ experience with P&C Client Engagement.
• Worked with Waterfall and Agile (Kanban & Scrum) methodology Projects with Business and IT Organization in various roles and used Jira and Rally tools.
• Excellent Collaborative and Communication skills while working with Business and IT stakeholders.
• Over 10 Years’ experience in Relational Databases in Data Modeling and Architecture besides developing Queries/Scripts using T-SQL or SQL Programming using SQL Server, PostgreSQL, DB2 & Oracle.
• Designed and developed/enhanced OLTP & OLAP Systems.
• Database Design and documentation by collaboratively working with Enterprise Architecture Teams.
• Developed Data Models using Erwin.
• Developed Database Tables and Indexes.
• Developed Stored Procedures and Functions.
• Extensively involved in Query Optimization using SQL Server Profiler and Index Tuning Wizard tools.
• Having 5+ years’ experience with Data Warehouse Technologies, developing and (or) enhancing Dimensional Databases and related tools.
• Designed and Developed SSIS ETL Packages using Control Flow Elements and Data Flow Tasks.
• Used Aggregate, Conditional Split, Derived Column, Data Conversion, Merge, Merge Join, Multi Cast and other Transformations.
• Designed and Developed Reports using Reporting Services (or) SSRS.
• Over 7+ years of IT experience in Database Design and Development on Microsoft SQL Server 2014/2012/2008 .
• Sound knowledge of software development life cycle (SDLC) and experience in independently handling Requirements gathering, design, development, documentation and testing phases in a project environment.
• In the role of Database Administrator/DBA the following responsibilities fulfilled for SQL Databases.
• Managed PostgreSQL & mongoDB (NoSQL) databases on Linux Servers.
• As Database Developer
• Implemented Quality guidelines as per client requirements (CMM Level 5 / Six Sigma).
• Supported Product Systems and fulfilled Change Management Processes by working collaboratively with all concerned teams.
• Document processes and follow best practices
• Perform peer design and code reviews and provide feedback on areas that need improvement
• Associated with other team members and contractors to help increase their knowledge and ability within the organization
• Having Fair understanding about Hadoop and Big Data Technologies.
• Having hands on experience in programming using COBOL and C Languages.
• Having exposure to Java, node.JS

Confidential, Atlanta, GA

BI SQL Architect/Developer

Responsibilities:

• Data Warehouse Modeling and Development
• Collaborate with BA’s, DBA & Tableau developers working from global development Facilities
• Work with BA’s and Tableau’s developers and target to meet client expectation

Technologies: SQL Server2016, SSIS, Confluence, Management Studio, Tableau

Methodologies: Agile - Scrum & Kanban.

Confidential

BI Technical Architect/Consultant

Responsibilities:

• Hands on Data Warehouse Design and Enhancements
• Integration Services Packages Optimization
• Query Optimization
• SSIS Packages performance improvement initiatives.
• Trouble shooting the packages using logging mechanism by collaborating with DBA team.
• Capacity Planning by collaborating with DBA team.
• Test Bed creation for Performance Testing
• Troubleshooting and issue resolution
• Deployments for BI Solutions using TFS & Octopus.
• Collaborate with team and incorporate the best Practices
• Meet the expectations of the Product Owner by understanding the priorities and resource availability.
• Support Hiring Process and bring the new entries up to speed.
• Production Support and maintain the logs

Technologies: SQL Server2016, SSIS, SSRS, Task Factory, Erwin, TFS, Management Studio

Methodologies: Agile - Scrum & Kanban.

Confidential

Sr. DB Engineer/Consultant

Responsibilities:

• Strong Collaborative skills while working with Agile teams (Scrum & Kanban) as Scrum Master and (or) Team Player.
• Trained and Certified Scrum Master
• As Data Architect supported Scrum teams for Design and Modeling Systems.
• Developed Data Models using Erwin tool
• Master Data Management
• Addressed Business Requests and developed while Implementing Business Rules to UAT and Production Systems by converting to T-SQL scripts. Fulfilled the Change Management processes as required
• Hands on experience in writing SQL DDL & DML Scripts
• Coordinated with Change Management Teams to implement Change Requests to Production Systems.
• As DBA supported development teams.
• Database Backup & Restore initiatives
• Log Files Maintenance
• Users and Roles Maintenance
• Design and Implementation of DDL requirements
• Trouble shooting using SQL Server and other third party tools.
• Performance initiatives
• Access Requirements
• Supported ETL packages and other Reporting needs.
• Coordinating with Production Systems Teams
• Implementation of Reporting Databases with Replication methods for XACT & C3 Applications.
• Pre-prod Real Time Sync-up (In Progress)
• Re-Platform Initiatives and Server/VM Optimization.
• Supporting C3 Application that includes Database Admin, Survey-Design and Survey modules
• Design and Development of Data Models
• Development of T-SQL scripts using PostgreSQL which is a powerful, open source object-relational database system for Database Admin module.
• Developed JSON and Java Scripts to extract data from MongoDB No SQL Database.
• Trained in NoSQL Mongo DB and going to support a Production System from mid-February.

Technologies: SQL Server, SSAS, SSIS, SSRS, PostgreSQL, MongoDB NOSQL Database, Java, Javascript

Other Tools: SVN, GIT, Management Studio, Service-now, Rally & Jira, Erwin Data Modeling tool, Idera tools & Service-now tools

Methodologies: Agile - Scrum & Kanban.

Confidential, Atlanta, GA

Project Manager/Business Systems Analyst

Responsibilities:

• Coordinated/Managed IT Projects from Healthcare Business Unit using Agile Methodology.
• Developed/Enhanced/supported Data Warehouse Projects with end to end responsibilities for Healthcare Recovery Audit Business using SQL Server and related BI tools.
• Collaborated with DBA teams to load the monthly claims and provider data into Data Warehouse.
• Involved in the project from the very initial stages and worked on Planning, Defining and Understanding Customer requirement via interaction and provided documentation.
• Developed and (or) enhanced data warehouse environment with snow flake schema with Claims Data in fact tables.
• Involved in Preparing Technical Documentation for the project.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements
• Developed complex T-SQL code for data extraction.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Designed and developed SSIS Packages to import and export data from SQL Server 2008 and Flat files.
• Created Complex Package to import data from Excel Files with Multiple sheets to multiple destination tables.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created package configurations to deploy the packages through DEV, TEST and PROD Environments.
• Analyzed the Data quality, Data validations, Data mapping to migrate data to SQL server.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.

Environment: MS SQL Server Management Studio 2005/2008/2012 , Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services, Microsoft Visual source Safe, SharePoint MOSS, TFS, XML, ASP.Net, Windows 2003/2000

Confidential, Indianapolis, IN

Sr. Consultant/Solution Architect

Responsibilities:

• In the role of Engagement Manager coordinated Outsourcing Resources and associated with Relationship Management team.
• As Project Manager and Solution Architect role performed Enterprise Architecture Assessment for merger of two individual Healthcare Business Units.
• As solution Architect supported the below listed Projects.
• Reporting using BI tools (Hyperion, SSRS)
• IT Transformation Projects from Mainframe Platform to SOA
• IT Portfolio Roadmap with Enterprise Architecture Assessment for merger of two Health Insurance Businesses. - Solution Architect for Mainframe Technology Systems.
• Supported Data Analysis and Modeling initiatives.
• Assisted Broker Licensing Systems on Mainframe Technologies.
• Facilitated Seagull LegaSuite middleware Technology Competency development.
• Associated with Relationship/Account Management teams in the hiring process
• Assisted e-Gate integrator Project for Confidential client from Consulting end.

Environment: SQL Server 2005/2008, Informatica, TIBCO, Seagull LegaSuite middleware, Hyperion Reporting, Mainframe, COBOL, DB2.