SUMMARY

• Over 20 years of experience in IT primarily in OLTP, Data warehousing and BI projects using Microsoft BI stack of Technologies.
• Experience with architecting various projects in Healthcare industries for both OLTP and OLAP.
• Adept at all stages of project lifecycle, from gathering business requirements and writing system requirements to development, testing, production support, and completion.
• Expertise in developing BI Roadmap to provide better reporting solutions and help perform advanced predictive and responsive analysis on existing OLTPs.
• Experience in designing PoC’s using QlikSense, QlikView, Tableau and Power BI
• Experience in designing PoC’s for Metadata Management and Data Governance.
• Significant experience in Data modeling across wide spectrum of industries like Judiciary, Finance, Healthcare, Public Welfare, Entertainment and Insurance using Power Designer, Rational Rose, Erwin and Visio
• Excellent understanding/knowledge of Big Data/Hadoop architecture and various components such as HDFS, JobTracker, TaskTracker, NameNode, DataNode and MapReduce programming paradigm.
• In depth understanding of major components in Hadoop Ecosystem like Hadoop Map Reduce, HDFS, HIVE, PIG, HBase, Sqoop, Oozie and Flume.
• Extensive experience in Data Warehousing, Data modeling, Database Administration, System Analysis, Design, Development and Support of Sybase, MS SQL Server 2005, MS SQL Server 2000, 7.0 in Production, Test, Development and Replication Environments.
• Experience in Multidimensional database design skills on SQL Server 2012/2014
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Good SQL Server Administration skills using various backup recovery, Model (simple, Bulk and full), database maintenance plan, user (NT/SQL) security authorizations.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Good understanding of Master Data Management (MDM) using CRUD (Create, Read, Update, Delete) Cycle.

TECHNICAL SKILLS

ETL tools: Informatica Power Center 7.2/6.1, SSIS

BI tools: QlikSense, QlikView, Tableau, Power BI,Business Objects XI R2

Reporting Tools: Crystal Reports, SSRS

Data Modeling Tools: ERWIN, Visio, Rational Rose, Power Designer 10

Languages: T - SQL, PL/SQL, XML, HTML Script, VB script, Java, J2EE

Databases: Oracle 9i/10g, MS SQL Server 2012/2014,Sybasen15.0.2, Sybase IQ, Parallel Data Warehouse(PDW)

Version Control Tools: Visual Source Safe, Team Foundation Server

Operating Systems: Windows 2003 Enterprise Server, 2000 Advanced Server, Windows NT

OtherTools/Languages: Embarcadero DBArtisan/RapidSQL 8.5,VS.net, BMC Remedy User, SharePoint

ERP Packages: SAP CRM 4.0, BAAN

Financial Package: CODA Financials

NoSQL: Hbase, MongoDB

Big Data Technologies: Hadoop, Sqoop, Pig, Hive, Flume, Oozie, Zookeeper, Cloudera, Hortonworks

PROFESSIONAL EXPERIENCE

Confidential, Louisville KY

Senior Technical/BI Architect

Responsibilities:

• Designed and Enhanced data integration process for Optum ETG product by 25%. Worked on innovative solution to automate the data integration process for Optum reports.
• Understanding the data requirements and provided custom reporting solution needs for Customer Experience area for detail analysis well under the SLA
• Developed strategic roadmaps and project plans for Long term and Short term solutions for the Data Warehousing, Data Governance and Analytics Projects.
• Provided Data Mining solution using SQL for fraudulent claims to be used for Predictive Modelling
• Worked on Provider Data integrity and Data Quality during transition of new contract
• Involved in tool selection for self-service BI and Data Visualization. Designed POCs using QlikSense, QlikView, Tableau and Power BI
• Involved in tool selection for Data Governance and MDM. Worked directly with vendors for POCs and Presentation for the C-level executives
• Frequent communication via periodic updates as well as focused presentations to senior management and the BI community.
• Recommend and decide technology solutions and perform mapping of the business requirements to systems/technical requirements to ensure they are in line with the enterprise architectural plan.
• Identify opportunities for value addition to for effective use of BI applications, Lead aspects of proposal development process, scope out effort and cost of solution, develop statement of work

Confidential, Mechanicsburg, PA

Senior Database Architect

Responsibilities:

• Direct the design, development, review, documentation, and implementation of data models for relational database applications with a special emphasis on assuring data integrity and access between major applications.
• Used Power Designer as the data modeling tool.
• Used Sybase Adaptive Server 15.0.2 and SQL Server 2005/2008.
• Responsible for maintaining the Master Data for the entire CP Case Management system.
• Coordinate data models, dictionaries and other database documentation across multiple enterprise applications
• Day-to-day responsibilities include analysis of data requirements and translation of these requirements into data models. Other responsibilities include developing modeling and naming standards, writing modeling guidelines, developing power-user training materials, loading master data and transaction data across client project teams.
• Create new database logical and physical design to fit new business requirements, and implement new design using Power Designer.
• Extensively used BCP Utility, SSIS and XML for data migration and replication.
• Created various reports using SQL Server Reporting Services (SSRS).
• Write scripts and performs data fixes, tests and schedules appropriately.
• Designed, developed and implemented data interfaces for various state agencies.
• Extensively used T-SQL for county customization and writing stored procedures.
• Determines the need for database modifications; writes and maintains database specifications.
• Integrate the Master data with the Lower court business process for the appropriate case upload from Lower court to Common Pleas court.
• Configure the Master data to send appropriate messages to JNET when certain events happen on a case.
• Involved with the application developers and IT management team as needed in developing design improvements to the underlying databases.
• Validated change requests and made appropriate recommendations.
• Use Remedy User and TFS to track and resolve end user issues.
• Create complex Stored Procedures, triggers, cursors, tables and security views.
• Analyze long running slow queries and tune the same to optimize application and system performance.

Confidential, Harrisburg PA

Senor Database Architect/Developer

Responsibilities:

• Designed and Created databases, tables, views, stored procedures and triggers.
• Monitored and scheduled existing/new jobs on production environment.
• Experience in Extracting, Transforming and Loading (ETL) data using SSIS which is latest in 2005 also implemented DTS Import/Export utility
• Imported data from text files and excel spread sheets into SQL Server 2000 database using DTS package.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Responsible for incorporating database changes for the new enhancements.
• Created reports from Data Warehouse using SQL Server Reporting Services (SSRS).
• Perform the integration testing for newly added functionalities.
• Extract data from different environments and provide as needed reports according to the request from different users.

Confidential, Harrisburg PA

Database Administrator/Modeler

Environment: SQL Server 2000/ASP.Net/Crystal Enterprise/Win 2000 Advanced Server/ Erwin 4.0

Responsibilities:

• Plan, install, configure, and upgrade installations of Microsoft SQL Server.
• Worked as a Data Modeler for various projects.
• Responsible for creating schema objects like tables, views and indexes.
• Involved in the Database Architecture for various projects using Visio Professional.
• Created numerous DTS Packages for transferring and manipulating data from heterogeneous DBMS using various connections, workflows and tasks.
• Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Configured various Publishers and Subscribers for Transactional replications.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Performed database health checks using SQL profiler, SQL performance monitor and performance counters.
• Created Database Maintenance Plans for the Performance of SQL Server which covers DBCC CHECKDB, re-indexing etc.

Confidential, Harrisburg PA

Senior Database Architect

Environment: SQL Server 2000/Rational Rose 2000/ Windows 2000 Advanced Server, Rational Rose

Responsibilities:

• Worked as a Data Architect for the LIHEAP project.
• Used Rational Rose and UML as the data modeling tool.
• Good working knowledge with Use Cases, Activity diagrams and Sequence Diagrams.
• Responsible for data dictionary generation.
• Creation of the Logical model of the database.
• Experience in the migration of Legacy data in the DMS to the new SQL server Database.
• Physical implementation of the database.
• Identify different database objects such as stored procedures, triggers and views needed for the entire application.
• Developed and used SQL Scripts to maintain consistency between different databases and responsible for moving data files from one to other servers.
• Monitored and improved database performance by creating efficient database design, creation of necessary indexes and table partitioning. Completed documentation of database structures and processes used to move data in and out of database for future development and expansion of database.
• Day-to-day responsibilities include analysis of data requirements and translation of these requirements into data models. Other responsibilities include developing modeling and naming standards, writing modeling guidelines, developing power-user training materials, loading master data and transaction data across client project teams
• Responsible for importing the legacy data to the redesigned database.

Confidential, Portland, OR

SQL Server DBA

Environment: SQL Server 2000/Windows 2000 Server

Responsibilities:

• Performance tuning and testing on stored procedures, indexes, and triggers
• Creation of database triggers.
• Established backup and recovery procedures for databases and implemented automated jobs for backup.
• Scheduling of the jobs for Data transformation and routine processes.
• Assist the development staff with best practices for SQL Server including but not limited to code optimization.
• Developing Security administration, DDL Script generating and maintenance.
• Extensively used SQL Server BCP Utility, DTS Import/ Export to load the database from text files received from different applications.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc. Automating Jobs and Creating Alerts.
• Automated consistency check of the database (DBCC) for SQL Server.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Monitoring the data file, transaction log and temp DB growth.

Confidential, Los Angeles, CA

Database Administrator/Modeler

Environment: SQL Server 2000/ SQL Server 7.0

Responsibilities:

• Worked as a Data Architect in various projects.
• Extensively used Erwin as the Data modeling tool.
• Plan, install, configure, and upgrade installations of Microsoft SQL Server.
• Experience in the migration of SQL Server 7.0 to SQL Server 2000
• Review and enhance existing SQL stored procedures and write new stored procedures
• Design, develop, and maintain the development, test and production database architectures, including database management, configuration, optimization, security, replication, maintenance, and support.
• Developing Backup plan and performing timely data and transaction backup and recovery of data.
• Creation and monitoring extract, transformation and loading scripts
• Restoring the back up at the time of database mark suspect or corrupt.

Confidential, Simi Valley, CA

Programmer Analyst

Environment: Visual Basic 6.0/DB2 400 V4R4

Responsibilities:

• Involved in the system design.
• Generated DFD’s, ERD’s and System Flow Charts for the entire system.
• Incorporated in Data modeling using Visio Professional.
• Used Client Access as the database connectivity tool.
• Created the User Interface Design for the entire application.
• Developed by using VB 6.0 as the front-end and DB2/400 V4R4 as the database under Windows NT environment.