SUMMARY:

• 8 Years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2/2005/2000 in Development, Test and Production Environments with various business domains.Migration of SSRS reports from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
• Developing reports on SSAS&SSRS on SQL Server (2005/2008/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Hands on experience working with Hadoop, Hive, MAP Reduce, Big Data, Oracle, PL/SQL
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Strong knowledge in TERADATA and DB2LUW.
• Worked on data warehouse environment for validating data among different stages using Teradata database.
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data (ETL)from multiple sources into Data warehouse usingInformatica and DataStage.
• Customized Mercury Quality Center to suit the requirements of testing effort
• Reported defects using Mercury Quality Center and followed up with developers
• Analyzed reports and graphs in Mercury Quality Center
• Good experience on Qlikview Business Intelligence reporting tool for developing dynamic reports.
• Proficient experience in different Databases like Oracle, SQL Server and DB2, Teradata.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
• Experience in handling Master Data Management (MDM) services and setting up the Master Data Services (MDS) to integrate and maintain various entities
• Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008 and Transformation
• Used MDX to interact with theOLAP Services.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Extensive experience with data modeling techniques, logical and physical database design.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008
• Executed Daily, Intraday and special batches using Autosys, troubleshooting failed batch jobs as necessary. Verified the functionalities of different jobs in stack and validated the result of the data after the batch completion.
• Sound Knowledge on WebSphere Authentication and Curam Login Modules
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience on high performance data integration solution: MS SQL SERVER Integration Service (SSIS), including Extraction, Transformation, and Load (ETL) packages for data warehouse. Extract/organize/migrate data from SQL SERVER to B, from MS ACCESS to SQL SERVER.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Expert ETL design.
• Experience working with Unit Test Framework.
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS.
• Good understanding in Oracle9i/10g Database.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX& improving the performance of the queries.
• Developed a dashboard solution for analyzing STD statistics by building SSAS 2008 cubes and Tableau
• Worked Extensively on ETL process using SSIS package.
• Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T-SQL Scripts in MS SQL 2012/2008/2005/2000.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple table inner and outer joins, stored procedures.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

SQL Database Developer/BI Developer

Responsibilities:

• Involved in migration of SQL Server 2008/2012 to 2014/2016.
• Address all the aspect of the Claim Processing Life Cycle starting from identifying a claim right up to the closure under HIPAA compliance.
• Successfully strategized project scope, specification documents, deliverables, timelines and project roadmap Implemented Claims adjudication module facets in line with EMR/EHR in compliance with HIPPA approved transactions such as claim filing (837), Claim Remittance (835), and Health plan Eligibility (270/271)
• Wrote SQL Server Stored Procedures, Triggers, Functions and Indexes of the database.
• Developed User defined functions and Triggers.
• Involved in writing C# classes and used LLBLGEN Pro as an entity framework for the manipulation of data in the database.
• Worked in ASP.NET Web forms, State management and Caching feature.
• Identified and documented all the reports, tables (subject areas) and ETL for each Business units.
• Documented the current and Gap Analysis across all the business units for ETL, Reports and Data.
• Identified the underline reports tables which are touching non- replicated tables.
• Developed reports and deployed them into SharePoint.
• Developed a dashboard solution for analyzing STD statistics by building SSAS 2012 cubes and Tableau
• Created data masking mappings to mask the sensitive data between production and test environment.
• Expert in creating Star schema cubes using SSAS .
• Created and Managed OLAP Cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Create Naming standards and Data dictionary for EDW Phase.
• Create the EDW server with project plan
• Create Data mart/ Dashboard/ KPI server with project plan.
• Good experience on Qlikview Business Intelligence reporting tool for developing dynamic reports.
• Wrote C#,VB.NET Code for Script Task in SSIS 2008
• Hands on experience in developing QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.
• Implemented logical and physical modeling using ERWIN data modeler
• Documenting the processes and having fair knowledge of sharepoint.
• Extensively used Data Structures like stacks, queues and linked-lists
• Incorporated analytical functions to implement different data logic and data masking process.
• Closely working with category for implementation master data management (MDM) of new products, customers and vendors.
• As per business requirement, validating the source and target data using Teradata.
• Developed Scripts in Teradata using bteq, mload, fexp, fastload
• Provided backup and recovery strategies for DB2 LUW.
• Involved in various HIPAA and HL7 testing and validation for EDI transactions using 820, 834, 835, 837, 270/271, 267/277, 278
• Creating test case scripts in Teradata to validate different stages.
• Develop, validate and maintain HiveQL queries and Analyzed data with Hive and Pig.
• Reporting and verifying the bugs in Mercury Quality Center.
• Participated in various meetings and discussed Enhancement and Modification requests.
• Executed Daily, Intraday and special batches using Autosys, troubleshooting failed batch jobs as necessary. Verified the functionalities of different jobs in stack and validated the result of the data after the batch completion.
• Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression (MDX).
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the data models.
• Installed and configured Oracle 10g enterprise edition.
• Created database and database objects such as tables, views, indexes, triggers.
• Successfully migrate data from SQL SERVER database to Oracle database using T-SQL, BCP, SSIS, Oracle SQL*Loader, and Oracle SQL Developer Migration Tool.
• Performance tuning and Optimization of large database for fast accessing data and reports Ms Excel, Unix, Oracle, Teradata being used for data transformation.
• Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
• Involved in migration of large amount of data developed application using ASP.NET 4.0, C#, ADO.NET, AJAX, SQL Server 2016/2014/ 20 12
• Wrote complex SQL override scripts at source qualifier level to avoidInformaticajoiners and Look-ups to improve the performance, as the volume of the data was heavy.
• Generated different reports using MS SQL Reporting Services and Crystal Reports.
• Successfully generated variety of business reports using SQL scripts, advanced SQL like multi table join, group function, single row function, sub-query, index, view and set operation, MS EXCEL 2007/2010 Dashboard with charts, Pivot Table, Macro, PowerPivot, Data Mining, Vlookup, Power View and etc..
• Good experience in creating pivot tables and charts in Excel using data sources SQL Server, SSAS cubes, Access and power pivot
• Scheduled the reports using Info View to run at specific times in Crystal Reports.
• Created various Tabular and Matrix Reports using SSRS.
• Preparing campaign in UNICA, scheduling and executing the same.
• Created reports to retrieve data using Stored Procedures that accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports
• Used Informatica for ETL process.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Strong Experience in developing reports using Query Studio & Report Studio.
• Used TFSas a source control for version controlling.
• Developed some codes to work on Visual Studio 2008 and Team foundation server (TFS) also used the same code in SSRS to generate Reports.
• Designed and developed customized Cognos reports for the client: Impromptu, Power Play Cube, Ad-hoc and Cognos queries using Cognos 7.4 Reporting platform.
• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence.
• Build and execute data masking algorithms to ensure data privacy in reference data
• Involved in using Informatica transformations for loading data from source to destination.
• Experience working with Unit Test Framework, involved in Unit testing and have created unit test cases
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created Stored Procedures, used complex queries involving join and union of multiple tables.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.
• Adapted agile process and Scrum techniques as the key environment for the development of the application and designed a hot fix process.

Environment: SQL Server 2016/2014Enterprise Edition, C#, SSAS, SSIS, T-SQL, SSRS, UNICA, Windows Server, Oracle 9i, Crystal Reports, .Net, Performance Point Server 2007, Power View, Power pivot,Informatica Power Center 8.6.1/8.1.1/ 7.1, Excel, SVN,Teradata, Cognos 8.4/8.2, Framework Manager.

Confidential, Charlotte, NC

SQL Database Developer/BI Developer

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment.
• Installation and configuration of SQL Server 2012/2014.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Functions, User Defined Data-Types, Rules, And Defaults.
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the data models.
• Analyzed the data from multiple sources such as Microsoft (MS) SQL Server, MS Access, Legacy systems, Mainframes, DB2, SalesForce Automation (SFA / SaaS), Microstrategy (MSTR), Tableau.
• Good experience in creating pivot tables and charts in Excel using data sources SQL Server, SSAS cubes, Access.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Used TFS for Version Control.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Customized Mercury Quality Center to suit the requirements of testing effort
• Reported defects using Mercury Quality Center and followed up with developers
• Analyzed reports and graphs in Mercury Quality Center
• Hands on experience in developing QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.
• Created and customized SharePoint KPI lists and WebPages for key business metrics using SharePoint designer. Tuned performance, optimized databases, managed system securities, tracked logs and issues.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Used master data management (MDM) to define reference data
• Designed Web-based ASP.NET and C# Internet applications linked to firm wide SQL Databases.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Involved in using Informatica transformations for loading data from source to destination.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in Migration of SSRS 2005 to SSRS 2008 R2.
• Good understanding of Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Used Informatica for ETL process.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Developed loading scripts using Teradata Utilities (bteq, mload, fexp, fastload) .
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Environment: MS SQL Server 2012/2014, T-SQL, .Net, SSRS, SSAS, C#, SSIS Packages, SSRS, MDX, ETL, Erwin, Informatica, Excel, MDX, OLAP, OLTP, Access, Windows 2003 Server.

Confidential, Chicago, IL

SQL Database Engineer/Data Warehouse Engineer

Responsibilities:

• Gathered requirement from Business Analyst & Internal Users.
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Involved in writing C# classes and used LLBLGEN Pro as an entity framework for the manipulation of data in the database.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like Session Partitioning, setting DTM Buffer Size and Cache Calculation (Data/Index cache) to manage very large volume of data.
• Involved in integration of SSRS Reports using various web parts into SharePoint and Performance Point and Dashboards.
• Performance tuning and Optimization of large database for fast accessing data and reports Ms Excel, Unix, Oracle, Teradata being used for data transformation.
• Wrote C#,VB.NET Code for Script Task in SSIS.
• Exported data from Teradata into various files by using MS Excel, MS Access and SAS.
• Implemented logical and physical modeling using ERWIN data modeler
• As part of Data Masking / Data Privacy performing the Reverse engineering on the Data model to identifying the Schemas based on requirements.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008/2012 Enterprise Edition, .Net, C#, SQL BI Suite (SSAS, SSIS, SSRS), ProClarity Server, Crystal Reports, XML, MS PowerPoint, MS Access 2003 & UNIX, Shell Scripting, Oracle.

Confidential, Seattle, WA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PL/SQL to create Tables, Views, and triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects.
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters
• Reporting and verifying the bugs in Mercury Quality Center.
• Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Responsible for SQL Server 2000 database development, database modeling, database program, database administrator
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server Database.
• Maintain and implement the database using SQL Server 2000 back-end tools and DTS.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation,
• Upgrade enhancements, maintenance, production support and bug fixing for the product.

Environment: T-SQL, SQL Server 2008, OLAP Services, C#, Windows 2000 Server, Query Analyzer, DTS,MS Access 2000, Oracle, Erwin Data Modeler.