Data Sql Server

Business Intelligence /Data warehouse Developer

Monalisa Rout

Ph.: +1-480-***-****

****.***.**@*****.***

Experience Summary:

•10 years of experience in Architecting and implementing enterprise, business & OLAP/OLTP solutions in Healthcare /Insurance/Banking Domains

•Designing and development in the field of Data Warehousing, management and Business Intelligence Technology and have performed multiple roles including Dev Lead, ETL Designer/Developer and Quality Analyst.

•Experience in Development and Deployment of DTS, SSIS packages from MS-Access, Excel and usage of multi-environment sources of Oracle10g,Oracle9i,SQL server, Teradata, DB2, mainframe, SFTP, Sybase and formation of UNIX shell Scripts .

•Management and implementation of database models, data flow diagrams, database schemas, dB scripts,DTD schemas to support a robust data management

•Experienced in programming tasks-Stored Procedures, Triggers, Indexed Views, User Defined Functions and Cursors using SQL Server 2008/2012 with T-SQL.

•Have extensive knowledge of RDBMS components such as usage of cursors and their importance in creation of automated Stored Procedures and generating Trigger.

•Operational Knowledge of Informix IDS v 10,Abinitio,Informix XPS and data integrator

•10 years of extensive experience of working in SQL Server 2008 R2/2014,Parallel Data Warehousing,

•7 years of extensive experience in ETL Design, development using SSIS/Informatica/Ab-Initio, designing/modelling using SSAS,creating reports with SSRS,Business Objects and Tableau

•Involved in migration of SSIS Packages 2012 CU5 and troubleshoot migration issues.

•Have experience of working with SharePoint, SharePoint Designer, Visual Studio, and SQL Reporting Services, ASP.Net, and C #, C++, Adobe Photo Shop, PowerBuilder, Oracle, XML, Microsoft SQL, Microsoft Excel (creating reports, VBA, macros, ODBC), Access (running queries) and PowerPoint (create basic decks) and Sever, Crystal Reports.

•Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models and E-R Diagrams.

•Experience with tracking defects and testing unit test cases with HP quality center

•Also proficient in Installation, Configuration and Updates of SQL Server and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.

•Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

•Experience in writing functional requirements, Design documents, ETL specifications, Unit Test Cases and System Test cases.

•Experience in writing Quality Center scripts for Unit testing, Functional testing, IQ (Installation Qualification).

•Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

•Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.

•Possess strong interpersonal skills, skilled problem solver and an efficient team player with excellent communication.

•Proven technical leadership to manage global delivery with large teams in an onshore-offshore model.

•Experience in handling teams across US and India under multivendor platform.

Technical Skills:

ETL Tools: MSBI (SSIS, SSAS, SSRS), Informatica Power center 9.5, Ab-initio (3.16)

Databases:SQLserver2008R2,MySQL,Oracle11g,Teradata16.0,Sybase,DB2

Data modeling Tools: Microsoft Visual basic C++, Microsoft Visio 2003, SSAS (OLAP), MS-Excel, SharePoint, Hive, Pig and Hadoop Streaming, MapReduce

Languages: PL/SQL, T-SQL, I-SQL, C#, Unix/Perl Scripting, XML

Reporting Tools: SSRS, Tableau, Business Objects

Methodologies:SDLC

OS: Windows server 2003, UNIX, Windows NT/XP/2000/Vista/7

Other Tools: DWH Concepts Dimension modeling, star schema, snow flake schema

Innovations (Tools) Implemented:

Data Mover:

•Designed an in built tool in Teradata for a requirement in project involving data transfer from Production to test environment to set up the environment for Unit and Systems Integration Testing, resulting in performance improvement by 80%

•Also converted Sybase procedures to Teradata procedures with performance tuning and proper unique indexes.

Scheduler:

•Developed a scheduler for OLAP database backup with scripts using SQL SERVER agent job.

ACHIEVEMENTS:

•Succeeded in implementations of the project leading to promotion and fresh assignments from client.

•Received appreciations for bringing delight to customers in the projects I have worked.

•Awarded best Employee of the Year award in Infosys.

•Received performance awards for successful and before time deliverables in project.

Education:

Bachelor of Engineering, (2006-2010)

Silicon Institute of Technology, Bhubaneswar (Biju Patnaik University of Technology, Rourkela)

ExperienceSummary:

Employer: - JACKSON HEALTH SYSTEMS: - (Aug 2014 – Till Date) – Miami, Florida

Title: Senior SQL Server Developer

Project (Knowledge Management):-

Architecting and implementing enterprise & business segment BI solutions.

Defining, designing,developing and optimizing ETL processes for enterprise data warehouse 24*7 support

Working with Cerner and development and analysis of SSRS report of Healthcare Data.

Primary work comprises of T-SQL programming and creating data marts as data repository for creation of data models and ETL Development

Also have experience of working with PDW, SSIS, SSAS, SSMS and Windows.

Deal with around 400TB of data and handling a team of 4.

We manage and develop SSIS packages and SSRS reports for OR Dashboard, Surg net and First Net.

Have SSIS Packages to get data from Cerner to localized databases under SQL Server 2012.

Working on PDW control Nodes and Landing Zone creation, to migrate the tables to PDW from SQL Server using BCPs through DW loader scripts.

Maintaining EHR (Electronic health records) data and Cerner.

Efficient in forming MDX queries and formation of Charts and Pivot table/Chart creation.

It includes creation of Dashboards, Pivot charts and MDX queries.

Involves usage of T-SQL, stored procedures, cursors and functions. Error & Exception Handling.

Create data models using SSAS out of the healthcare Cerner data deposited in EDW.

Mainly Encounters, Diagnosis & Procedure facts with Dimensions: - Dim Date, DimICD9, and Dim Location etc.

Proficient in usage of loops (while, for and cursors)

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.

Created Dashboards to present critical company data in a single report.

Helped creating a Big Data framework and deploying tools to capture, transform, analyze and store terabytes of structured and unstructured healthcare data.

Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.

Configured SQL database to store Hive metadata.

Loaded unstructured data into Hadoop File System (HDFS).

Created reports and dashboards using structured and unstructured data.

Created cubes and dimensions for diagnosis Hierarchy using Tableau and also replicated it in Business objects.

Tools: - Visual studio 2008/2013, SSIS, SSRS/Tableau/Business Objects, SSAS, PDW, UNIX, Windows & Power-shell scripts.

Cognos 8 & 10 BI, Cognos Connection, Cognos office Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, DB2, SQL,XML and Windows NT/4.0.

Infosys Technologies Limited

American Express,Phoenix,USA (IDN-Information Delivery Network) (2012-2014)

Project: Global Corporate Payments (B2B)

Global Corporate Payments for B2B operations, this project involved calculating line of credit (automatic line increase and decrease) and sharing the data with downstream applications as per requirement. It involved development of procedures, code walkthrough, resolving technical and design issues, performance tuning of code and performing independent unit testing and integration testing. Besides my responsibilities also covered understanding the application architecture document and seek inputs from the architecture /design team to understand the overall architecture in order to provide deliverables that are in line with architectural requirement.

Responsibilities:

•Worked as onsite lead coordinator for a team of 20, acting as a liaison between the offshore team and the client.

•Efficiently adhered and implemented SDLC (System Development Life Cycle).

•Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.

•Created Mapping Specification document as per requirements.

•Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.

•Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.

•Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.

•Migration of DTS packages to SSIS packages

•Interacted with different system groups for analysis of systems.

•Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.

•Developed automated stored procedures for calculating line of credit and risk in US and Non-US markets.

•Operated in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.

•Complete end to end involvement in migration of database from SQL server 2005 to SQL server 2008.

•Completely involved in monitoring and carrying out daily code drops and archives on the production databases during maintenance windows.

•Developed automated scripts for migration of data from Sybase to Teradata and vice versa through UNIX.

•Generated scripts for OLAP database backup and developed a scheduler using SQL server agent job.

•Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.

•Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels

•Performed Database Refresh tasks from production to Development and Staging Servers

•Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

•Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues

•Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

•Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.

•Handled Scheduled backups and restore operations with lite speed 5.0 and monitored the Tasks, Maintenance plans.

•Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks

•Created database artifacts in Teradata, according to the requirements.

•Worked on MS SQL Server database to create tables, views, Insert scripts, Merge scripts.

•Used Teradata utilities like Multi-load, T-pump, and Fast Load to load data into Teradata data warehouse from Sybase and also created a tool for data movement between development, test and production environment of Teradata.

•Solved Various Defects in QC.

•Played a major role in setting up different environments - Testing, Integration, Performance and Production environment

•Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.

•Created Informatica workflows to balance load time keeping in consideration the sequence of load as per business requirements.

•Performance Tuning of sources, Targets, mappings and SQL queries in transformations.

•Developed unit test plans and involved in system testing.

•Wrote Build plan with steps to implement the code in multiple environments.

•Functional testing and Unit testing on tables loaded in Teradata. Preparation of test results report to ensure Quality

•Preparation of process related documents as required throughout the SDLC lifecycle such as System requirement detail specification document, ETL Specification Documents, Test specification documents, Performance Document, capacity plan document, traceability Matrix, Teradata estimate document.

Projects AET2 (BASEL-II):

•BASEL AET-II work stream deals with sourcing and maintaining Institutional data which is then modelled to calculate Exposure at Default, Loss Given Default and assign Probability of Default for the clients. The work stream is also responsible for classifying a client as wholesale or retail to American Express.

Responsibilities:-

•Extracted data from sources like text files, SQL Server 2008, .CSV, Excel from client server (sometimes mainframe) and through FTP or directly from UNIX.

•Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modelling process.

•Leading the effort for creating Data Quality check (DQ on Hops) process (DQC and Event Engine Nodes) and automated process run through an internal scheduler(event-engine)for Card(Global corporate payments and OPEN) and Non Card Portfolios,Amex internal tool for validating the data quality coming from the source as an additional check before performing load to target tables.

•Leading the effort for code release from offshore involving development, testing and till package formation for production implementation.

•Gap Analysis for Corporate tables for production defects/ data mismatches between Sybase IQA5 and TD Amex5 and SQL Server (Source and Target).

•Transferring data from Amex 5 to Amex 3 for creating suitable test environment, to carry out UAT and SIT, using automated script when the source was Teradata.

•Involved in creation of ETL SSIS packages and deployment of the same in SQL Server 2008.

•Involved in Installation, Configuration and Deployment of SSRS Reports.

•Performed security tasks like GRANT, REVOKE permissions for security tasks.

•Also framed performance tuned SQL-Queries and Stored Procedures in addition to user defined functions to decrease CPU usage time and avoid Deadlocks between transactions...

Environment: SQL SERVER 2008 R2, UNIX, Teradata, Oracle, Sybase, Windows Server 2003.

Projects B2B (Merchant Finance):

•The B2B Capability team under IDN is responsible for delivering new capabilities that build on the existing framework for B2B: Merchant Risk, Corporate Risk, Merchant Finance and Serve/Enterprise Growth. Among them Merchant Financing deals with calculating the credit risks between Amex and non-AMEX payees.

Responsibilities:

•Participated in understanding and preparation of High Level Design Document.

•Prepared Low Level Design document, Release Notes, Deployment Guide and Unit Test Results.

•Developed procedures, various feeds and loaded data through MDF process and automated the process

•Developed SQL queries for automating the whole process in both Sybase and Teradata environment. Documented/prepared best practices, performance tuning queries and improving test practices.

2) Aetna Health Insurances - (2010-2012) Infosys Technologies LTd

Project: MCM Data mart

It involved creation of an automated process which would do the calculation and retain the generated information in data warehouse for required time period. It covered preparation of detail design, development, code walkthrough, resolving technical and design issues and performing independent unit testing.

Responsibilities:

•Worked as a Senior Programmer and Dev Lead Gathering requirements, analyzing and designing ETL Specifications.

•Wrote scripts to Create Database, Roles, User Accounts, establish Relationship between database, roles, user accounts, grant access scripts based on requirements.

•Currently working on extracting data from various sources like Sybase, Teradata and Oracle, Excel and flat files from client server through SQL server 2008(SSIS)

•Have handled performance tuning and optimization on SSIS and MDX with strong analytical and troubleshooting skills for quick issue resolution in large scale production environments located globally.

•Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in data management, database design process and data modelling process.

•Created data-driven process with complete flow in SSIS.

•The packages created included variety of transformations, for example slowly changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy lookup, Multicast and Data Conversion.

•Reviewed and tested packages in SSIS 2008 Business intelligence Development Studio.

•Studied existing OLAP system and created FACTS, Dimensions, and Star Schema representation for MCM Data mart and warehouse systems.

•End to End involvement in analyzing and designing using SSAS 2008 cubes and setting up attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

•Created staging partitions, cubes etc. for SSAS 2008 OLAP databases.

•Initially created and implemented Ab-initio graphs with DB2 as the database and UNIX as co-operating system.

•Framed and implemented test queries to support the graphs in ab-initio in different sandboxes, according to the requirements.

•Involved in complete SDLC (System Development Life Cycle).

•Wrote Pre-Installation, Installation, Verification, Post Installation Scripts in QC.

•Expertise in performance tuning the user queries. Execution of frequently used SQL operations and improve the performance.

•Solved Various Defects in QC.

•Played a major role in setting up different environments - Testing, Integration, Performance, Break fix and Production environment.

•Developed graphs and created Ab-into maps to balance load time keeping in consideration the sequence of load and amount of data as per business requirements.

•Performance Tuning of sources, Targets, mappings and SQL queries in DB2 environment for check on the target.

•Also framed various Perl and shell scripts in UNIX for paralleling processing of graphs in backend, to support the run of graphs when session times out.

•Developed unit test plans and involved in system testing.

•Functional testing and Unit testing on tables loaded in Teradata. Preparation of test results report to ensure Quality

•Preparation of process related documents as required throughout the SDLC lifecycle such as System requirement detail specification document, ETL Specification Documents, Test specification documents, Performance Document, capacity plan document, traceability Matrix, Teradata estimate document.

Environment: - SQL Server 2008, SSIS, SSAS, SSRS, T-SQL, FTP tools, UNIX, MS access, Visual Studio C++,Interactive SQL, DB2

Contact this candidate