SUMMARY:

• 8 + years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008 /2008 R2/2012.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• EMR contains the standard medical and clinical data gathered in one provider’s office. Electronic health records (EHRs) go beyond the data collected in the provider’s office and include a more comprehensive patient history.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Generated reports from Analysis Services cube by using ProClarity tool. Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#,ASP (.NET ), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2014,2012,2008R2,2008,2005, 2000

DWH / BI Tools: SQL Server Integration Services ( SSIS ), SQL Server Reporting Services ( SSRS ), SQL Server Analysis Services ( SSAS ), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Cognos, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniquesKimball &Inmon Methodologies Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Netezza, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office(MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential,Dallas,Texas

Reports Developer

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• C reated efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions .
• Created Bash scripts for getting the files from Linux server and used ftp tasks using bash script.
• Worked on Database Compression for different databases to save space across different environments

Confidential

Software Engineering Team Lead

• Worked with Manhattan Supply Chain Execution system and involved in gathering the requirements.
• Created the Functional Specifications documents.
• Create Hive external tables on the map reduce output before partitioning, bucketing is applied on top of it and Datameer is used to represent the data to business users.
• Responsible for building scalable distributed data solutions using Hadoop.
• Developed Pig Latin scripts to extract the data from the web server output files to load into HDFS.
• Developed the Pig UDF'S to pre-process the data for analysis.
• Implemented multiple Map Reduce Jobs in java for data cleansing and pre-processing.
• Experienced in loading data from UNIX file system to HDFS.
• Developed job workflow in Oozie to automate the tasks of loading the data into HDFS.
• Responsible for creating Hive tables, loading data and writing Hive queries.
• Effectively involved in creating the partitioned tables in Hive.
• Handled importing of data from various data sources, performed transformations using Hive, Map Reduce, loaded data into HDFS and extracted data from Teradata into HDFS using Sqoop.
• Worked extensively with Sqoop for importing metadata from Oracle.
• Configured Sqoop and developed scripts to extract data from SQL Server into HDFS.
• Expertise in exporting analyzed data to relational databases using Sqoop.
• Import and export data between the environments like MySQL, HDFS and Unit testing and Deploying for internal usage monitoring performance of solution.

Environment: Hive, Sqoop, Oracle 11g, pig and Hortonworks Hadoop Ecosystem and Microsoft SourceSafe, SAP HANA. Tableau

Confidential, Dallas Texas

Senior Developer

• Migrated and resolved conversion errors for Performance Point Server reports to Share P oint 2010 Business Intelligence platform.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Developed the flow charts and diagrams as well as translation of the detailed designs with Lotus Notes application.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• C reated efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Handled Tableau admin activities granting access, managing extracts and Installations
• B uilt connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions .
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services(SSAS).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Repaired/recreated PPS reports damaged in the conversion process.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.
• Created bash scripts and used python scripts for loading the files.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Windows2003 Advanced Server, ODBC, bash script,OBIEE, MS SQL Server 2005/2008/2012, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008, SharePoint 2007/2010, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

Confidential,Dallas Texas

Senior ETL Developer

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• C reated efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions .
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Migrated and resolved conversion errors for Performance Point Server reports to Sh ar eP oint 2010 Business Intelligence platform.
• Repaired/recreated PPS reports damaged in the conversion process.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Debugging and implementing the system using IBM Debug tools .
• Strong ETL/Data warehouse experience using IBM Data Stage Components like Data Stage Designer.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential, Alexandria,Virginia

Senior Developer

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• EMR contains the standard medical and clinical data gathered in one provider’s office. Electronic health records (EHRs) go beyond the data collected in the provider’s office and include a more comprehensive patient history.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET
• Used EDI tools to verify mapping to X12 format.
• Recommend changes for system design, methods, procedures, policies and workflows affecting
• Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards ANSI.
• Analyze HIPAA EDI transactions in X12 responses and of 837,834, 835, 277CA and 999 and looked for defects.
• Do data analysis for various version changes of EDI messages on different sub-systems.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential,Dallas,Texas

SQL Server Developer

• Reading and parsing of multiple flat files for (BLIT and BLAT) Invoices and Adjustments data from Telegence. These would be files related to "unbillable chargeback" and "positive confirmation".
• Loading these files into a temporary store in an Oracle DB
• Executing procedures to process this data based on the given business logic and move it to transaction tables.
• Implementation/Extension of the status workflow based on the parsed data.
• Developed custom reports based on this data (viz. Monthly reconciliation, Unbillable, Invoices, Adjustments)
• Developed Reporting Requirement Document for the Report Automation.
• Developed the Reporting and Functional Requirement Document for the Business Intelligence Team for the EMI Project.
• Developed the Reporting QA Test Document for the QA Testers for testing the Reports.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for different reports.
• Developed Complex Queries, Joins and Sub queries in SQL Server 2005.
• Created Linked Servers for the Test, Development, Production Database Servers and assigning the Permissions for the Users based on the Requirement.
• Used SSIS to create ETL packages to validate, extract, transform and load data to staging, Archiving and Processing Databases.
• Experience in creating Clusters, Indexes in SQL Server
• Developed various Reports like tabular, Matrix, Sub Reports, Charts based on the Business Requirement.
• Developed Sub Reports in SQL Server Reporting Services (SSRS) with URL Link option to jump to another Report.
• Experience in developing Adhoc Reports using SSRS
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed SSIS package and assigned SSIS as Dataset in SSRS to load the file to the File share.
• Deployed RDL file to the Reporting Server and assigned Roles and permissions for various Reporting Users.
• Developed Cubes using SQL Server Analysis Services (SSAS).
• Developed MDX queries in SQL Server 2005.
• Developed Data models for data mapping and relations between the relational tables.
• Developed Star Schema and Snowflake Schemas for EDW Database.
• Developed EDW Database for maintaining the Fact, Dimensional and Aggregated data for reporting.
• Responsible for Replication Services for moving and copying the data from one database to another database.
• Used Snapshot Replication for copying the snapshot data from billing Database to Reporting Database.
• Experience in creating the New Subscription for Reports to render them to the Recipients through email or File share.
• Developed SSIS Packages from SQL DB Source to CSV File destination and scheduling the packages to render the File using SQL Mail Agent.
• Used Report Viewer Controls for calling the Reports from Asp.NET.
• Scheduled SQL Agent Jobs for the Stored Procedures to load the huge data to the tables.
• Dealt with Fine-tuning Stored Procedures to improve performance.
• Used Performance Point Designer for designing the Daily Sales Scorecards and Graphs using Performance Point Server.
• Performed Unit, Functional, Database and Performance Testing for Various Reports.
• Responsible for developing the Business Intelligence SharePoint Portal by Adding Reporting links and Reporting Project status on the SharePoint Server.
• Developed the Database Architectural Diagram in Microsoft Visio for the Call Process Flow.

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Performance Point Server 2007, Informatica, .Net Framework, Microsoft SharePoint Server 2003, Visual Source Safe, MS Visio 2003, Windows 2003.

Confidential, Bentonville Arkansas

SQL Server Developer/Admin

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source data base and loading on to the target data base.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data into SQL Server RDBMS (relational database).
• Also designed and developed PL/SQL scripts for loading data into the Relational Oracle Database (RDBMS).
• Worked on BIDS for improving the cube efficiency making it more programmable.
• Maintained the table performance by following the tuning tips like Normalization and Creating Indexes.
• Involved in creating report specification by Tele-conferencing with end users
• Implemented SSAS to build cubes which were made available to business users who can browse the data using a variety of tools, making ad hoc analysis an interactive and analytical process rather than a development effort.
• Implemented Power Designer for analysis of the extracted data prior to loading of data into destination staging area.
• Tracked the deployments and proceedings of their status through MS SharePoint.
• Modified the existing SQL Server SSIS packages to meet the changes specified by the users.
• Scheduled jobs for executing the stored SQL Server SSIS packages which were developed to update the database on daily basis.
• Designed, Developed and Deployed reports in MS SQL Server 2008 environment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SQL Server SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated various reports using SSRS 2005.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Generated necessary documentation through MS Word and Flow charts with MS Visio.
• Generated SQL for views from query subjects in Framework model.
• Designed and implemented Stored Procedures for automating tasks.

Environment: MS SQL Server 2000/2005/2008, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.