PRATHIMA

SR. SQL BI DEVELOPER

CERTIFICATIONS

**-*** ********* *** ****** 2005 – Implementation and Maintenance

AWARDS / RECOGNITIONS

Exceeded Goals/Expectations in Performance Review Blue Cross Blue Shield / HCSC

November 2014

ITG Spirit Award

Blue Cross Blue Shield / HCSC

November 2014

Star Player of 2015 Retail Renewal team

Exceeded Goals/Expectation in Performance Review

October 2015

Blue Cross Blue Shield / HCSC

ITG Spirit Award

Blue Cross Blue Shield / HCSC

November 2015

For tireless efforts to ensure renewal project testing occurs

2015 ITG 5-STAR Nomination

November 2015

Blue Cross Blue Shield / HCSC

Nominated for ITG Cross Functional Team 5 Star Award

ITG Spirit Award

Blue Cross Blue Shield / HCSC

In Recognition for Outstanding Team Achievement with in the Retail Renewal Project

December 2015

Proven track record with many awards for the productivity, ability to identify and resolve problems, and for the ability to lead the team.

Highly motivated, goal oriented, team player and met the project strict deadlines.

PROFESSIONAL EXPERIENCE

Over 9+ years of experience in SQL Server Development including writing T-SQL Programming, Database Design, SQL server suite of products SSIS, SSRS, SSAS.

Knowledge of Big Data platforms

Experience with development tools and tools platforms (i.e. PIG and HIVE)

Designing data queries against data in the HDFS using tools such as Apache Hive

Experience in Tableau visualization tool

Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS

Hands on Experience in installation, upgradation and configuration for various versions of MS SQL Servers.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing T-SQL Queries (DDL, DML) & Dynamic-queries

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008/ 2012)

Extensive experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages

Expert in implementing and planning Server Security and authentication and Database Normalization

Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008R2/2012

Experience in writing complex stored procedures, functions, Cursors, Indexed views and triggers for data consistency and manipulation

Experience in creating scheduling Jobs, sending Alerts

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals using SSRS 2005/2008R2/2012

Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.

Good experience and understanding of SSAS, OLAP cube and Architecture

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups & measures, cube dimensions & dimension relationships, calculations

Experience in creating MDX cubes and dimensions (SSAS)

Expert in performance tuning, query optimization and running database

Experience in creating Power BI dashboards/reports using tabular models

Experience in Maintaining and scheduling various reports in Power BI

Expert in database activities like Data Modeling, Data Staging, Data cleansing, Data scrubbing.

Experience in DBA activities such as backups, recovery, restore, replication and Linked servers etc.

Experience in database integrated application development using VB, VB .Net, C#.Net, Asp.Net

Experienced in design of logical and physical data modeling using Erwin data modeling tool.

Excellent in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Excellent communication and inter-personal skills with ability to work as a team player or independent player and ability to interact with clients.

Ability work in challenging and versatile environments and strive for excellence.

Flexible and versatile to adapt to any new environment and work.

Experience developing using an Agile and Water fall Methodology.

KEY TECHNICAL SKILLS

Database Tools

SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio (SSAS, SSIS and SSRS), Visual Studio

.NET 2005, SQL Server Enterprise Manager and T-SQL

Programming Languages

SQL, PL/SQL, C, C#.Net, VB.Net

Hadoop Eco System

Hadoop, Pig and Hive

Web Technologies

Asp.Net, HTML, DHTML, CSS, XML, XSL, XSLT

BI Suite

SSAS, ProClarity, SSRS, SSIS.

Databases

SQL Server 2000, 2005, 2008, 2012, 2014 MS Access, Oracle, MySQL.

ETL Tools

DTS, SSIS, Informatica, Talend (Data Integration)

Reporting Tools

SQL Server Reporting Services, Power BI,Tableau, Crystal Reports, MS Excel

Third party tools

Tidal, Zena, and windows Application server

Version Control Tools

Team Foundation Server (TFS) 2012/2010/ 2008/2005

Data Mining Tools

Microsoft Analysis Service (SSAS)

Data Modeling

ER-Win, Visio

Documentation Tools

MS Office (Including MS Project, VISIO)

Operating Systems

Windows 98/NT/2000/2003/XP/ Vista/7/8/10, Linux, UNIX

PROFESSIONAL EXPERIENCE

HEALTH CARE SERVICE CORPORATION (BCBS OF IL, TX, OK, NM & MT), CHICAGO, IL

Role: SQL BI Lead. JAN 2013 – PRESENT

Health Care Service Corporation (HCSC) is the largest customer-owned health insurance company in the United States. HCSC offers a wide variety of health and life insurance products and related services, through its operating divisions and subsidiaries; including Blue Cross and Blue Shield of Illinois, Blue Cross and Blue Shield of New Mexico, Blue Cross and Blue Shield of Oklahoma, and Blue Cross and Blue Shield of Texas, and Dearborn National.

Responsibilities:

Analysis of the specifications provided by the client

Provide leadership within the solution development team(s) acting as a mentor and/or advisor

Participate in configuration, deployment, and maintenance of the application development environment

Act as a technical lead for project teams during implementation phase

Deliver technical coaching to the development team

Take ownership of difficult components of a solution such as complex code design

Participate in solution definition and feasibility analysis to ensure delivery of business value

Assist with the selection and application of tools to improve the effectiveness of the development teams and other IT groups

Review new or modified programs, including documentation, diagram and flow charts to determine if the program will perform according to user requests and conform to specified guidelines

Recommend program improvements or corrections to programmers

Monitor program performance after implementation to prevent reoccurrence of program operating problems and ensure efficiency of operation

Interpret an extensive variety of technical instructions and deal with several abstract and concrete variable

Developed and created the new database objects including tables, views, indexes, stored procedures, UDF’s, views, cursors and triggers

Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum m efficiency and scalability.

Worked on performance tuning for better running of queries.

Designed and Implemented SSIS packages to load the data.

Created SSIS script task, look up transformations and data flow tasks.

Designed, Managed and Published various reports using SQL Server Reporting Services 2008

Created different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports

Created Cascading, Printable, interacted reports (drill-down and sorting functionality)

Designed reports based on query parameters and Report parameters

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Created Power BI visualizations and dashboards

Create Views for Power BI Report and retrieve those views to construct Dashboard report in Power BI

Created Power BI Visualizations and Dashboards as per the requirements.

Worked on modeling the data in Power BI involving creating measures, calculating columns, etc.

Worked on modeling the data in Power BI involving creating measures, calculating columns, etc.

Deployed reports in the solution explorer and opened through browser.

Implemented update strategy on target tables when a record already exits.

Involved in data migration and used SSIS to import and export data in to tables using SQL Server, creating tables, views and Store Procedures using SQL server.

Environment: SQL Server 2012 / 2014 Enterprise Edition, BIDS / SSDT, SSAS, SSIS, SSRS, Power BI,T-SQL, VB.Net, C#, Erwin, Visio, Hive, Pig,

HALLMARK SERVICES CORPORATION, CHICAGO, IL OCT 2012 – DEC 2012

Role: Software Engineer

Hallmark was acquired by Health Care Service Corporation (HCSC), currently the largest, customer-owned healthh insurer in the United States, and fourth largest overall. Hallmark operates as a wholly owned subsidiary of HCSC and acts as administrator for its individual, Under 65 and Medicare Supplement health insurance segment.

Responsibilities:

Involved in User Requirement Gathering and Technical Specification Documentation.

Involved in creating and managing schema objects such as tables, views, joins, indexes, functions,

Procedures, triggers & maintain Referential Integrity.

Responsible for Debugging reports using Stored Procedures.

Developed complex Stored Procedures and views to generate various reports using SSRS.

Developed SQL SSIS Packages to extract data from various data sources including Access database, Excel spreadsheets, and flat files into SQL server.

Developed and created stored procedures, advanced queries, triggers, views, indexes, and functions for databases.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities

Worked with different methods of logging in SSIS.

Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.

Tested, cleaned and standardized data meeting the business standards using fuzzy /exact lookups using SSIS tasks.

Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.

Enhancing and deploying the SSIS Packages from development server to production server.

Used Package configuration to export various package properties to make package environment independent.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.

Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Environment: SQL Server 2012 Enterprise Edition, BIDS, SSIS, SSRS, T-SQL, ETL, VB.Net, C#, Erwin.

HEIDRICK & STRUGGLES., CHICAGO, IL APR 2011 – SEP 2012

Role: Software Developer / SQL BI Developer

Hedrick & Struggles is a global Executive Search firm. It served as a launching pad for many top companies in the modern executive search industry

Responsibilities:

Installation and configuration of SQL Server 2008

Worked with T-SQL to create tables, views, Functions and Indexes.

Created and when required, modified already existing stored procedures, triggers, views.

Involved in Migration of SSRS 2005 to SSRS 2008.

Involved in data migration and used SSIS to import and export data into tables using SQL Server 2005/2008.

Created different type of reports including Cross-tab, Conditional, and Drill-down and Sub reports using SSRS.

Experience in creating ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.

Migrated DTS packages to SQL Server 2008 as SSIS Packages.

Created SSIS Packages using proper control flow and dataflow elements for transformation of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.

Used various transformations in SSIS like Multicast, Slowly Changing Dimensions and Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations

Created SSIS package to load data to SQL Server, from Flat files or excel spreadsheet.

Created reports and performed administrative tasks like backup and restore.

Extensively used SQL Server Reporting Services to generate various types of reports.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.

Experience in writing MDX queries for cubes and Performance optimization of MDX queries.

Defined calculations, which are Multidimensional Expressions (MDX) expressions or scripts. Calculated members, named sets, and execute other script commands to extend the capabilities of a Microsoft SQL Server Analysis Services (SSAS) cube.

Experience in Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).Created report snapshots to improve the performance of SSRS.

Used Report Manager to assign roles, permissions and to create report schedules.

Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.

Involved in developing logical and physical modeling of the database using Erwin.

Developed custom reports using SQL Server Reporting Services (SSRS) to review business trends based on the data from different branches.

Created subscriptions in SSRS to deliver reports.

Performed data analysis to generate various trend reports.

Environment: SQL Server 2005/2008 Enterprise Edition, TSQL, SSIS, SSRS, SSAS, MDX, MS SQL Server 2000/2005, Visual Studio (BI) Tool, Erwin, Oracle, Visual Studio 2005, .Net.

SYNOVATE, CHICAGO, IL OCT 2010 - MAR 2011

Role: Software Developer / SQL BI Developer

Synovate was a market research firm. It has a number of different divisions, such as Synovate Healthcare, Synovate Customer Experience and Motor research.

Responsibilities:

Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

Configured and maintained MS SQL Server 2008.

Developed Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.

Experience in creating ad hoc reports Using Report Builder 1.0 and Report Builder 2.0.

Involved in Migration of SSRS 2005 to SSRS 2008.

Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.

Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.

Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.

Developing and extending the cubes with around 35 dimensions, about 10 measures, and 25 calculated members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Experience in executing MDX queries for cubes and performance optimization of MDX queries.

Worked on ProClarity to create OLAP datasets and queries are created directly from the Unified Dimensional Model.

Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.

Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Build.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.

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 SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Created Data warehouse environment for OLAP & Data mining in SSAS

Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS 2007 (Share Point), Business Scorecard Manager, Dashboards, Performance Point Server.

Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX,

Data Mining Models, developing reports using MDX and SQL

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service(SSRS)

Created data driven subscriptions for different users using Report Manager.

Data migration (import & export – BCP) from Text to SQL Server.

Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.

Developing complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the

OLAP reporting needs

Developing backup/restore and recovery procedures, performing weekly backup databases by using SQL Server 2005 and restoring these databases in different server.

Environment: SQL Server 2005/2008 Enterprise, Windows Enterprise Server 2003, SSAS, SSIS, SSRS, Server 2004, Share Point Portal Server 2007 (MOSS 2007), MDX, IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008, ASP.Net 3.5, VB.Net, MDX, OLAP, OLTP, SFTP, JAVA, J2EE

GUARANTEE TRUST LIFE INSURANCE, GLENVIEW, IL FEB 2010 – SEP 2010

Role: SQL BI Developer

Guarantee Trust Life Insurance Company is a legal mutual reserve company located in Glenview, Illinois, which provides a portfolio of competitive health, accident, and life and special risk insurance programs.

Responsibilities:

Involved in User Requirement Gathering and Technical Specification Documentation.

Involved in creating and managing schema objects such as tables, views, joins, clusters, indexes, functions,

Procedures, triggers & maintain Referential Integrity.

Identified and defined the Datasets for the report generation and wrote the queries for the drilldown reports, sub-reports.

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu

option using SSRS.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.

Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Created different chart reports helped in analyzing performance.

Developed complex Stored Procedures and views to generate various reports using SSRS.

Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.

Responsible for scheduling the subscription reports with the subscription report wizard.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.

Created linked reports.

Developed SQL SSIS Packages to extract data from various data sources including Access database, Excel spreadsheets, and flat files into SQL server.

Developed and created stored procedures, advanced queries, triggers, views, indexes, and functions for databases.

Designed high level ETL architecture for overall data transfer from the OLTP to OLAP using SSIS.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results

Worked with different methods of logging in SSIS.

Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.

Tested, cleaned and standardized data meeting the business standards using fuzzy /exact lookups using SSIS tasks.

Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.

Enhancing and deploying the SSIS Packages from development server to production server.

Used Package configuration to export various package properties to make package environment independent.

Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Environment: SQL Server 2005/2008 Enterprise Edition, BIDS, SSAS, SSIS, SSRS, T-SQL, MDX, ETL, VB.Net, ASP.Net, C#, Oracle 9i, Erwin.

LUCID TECHNOLOGIES, ARLINGTON, TX FEB 2008 – FEB 2010

Role: Software Developer

Lucid Technologies, Inc. is a leading information technology consulting firm. It serves clients globally.

Responsibilities:

Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,

Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Developed Cubes using SQL Analysis Services (SSAS).

Involved in creating Named calculations and named queries.

Refreshing cubes to get the latest information updated.

Configured SSRS with MOSS 2007 for directly deploying the report in SharePoint 2007.

Generation of reports from cubes by connecting to Analysis server from SSRS.

Scheduled the DTS package for migration of data from old system to MS SQL 2005.

Performed maintenance of Stored Procedures to improve Performance of different front end Applications.

Developed SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.

Created different reports using SSRS for the analysis.

Involved in the SSAS storage, Aggregations, and calculation of queries with MDX, developing reports using MDX and SQL.

Involved in enhancing the functionality of OLAP Cube by creating KPI.

Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.

Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports (SSRS)

Experience in Developing and Extending OLAP Cubes, Dimensions and data source view

Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to users

Involved in developing logical and physical modeling of the database using Erwin.

Build database queries and test cases for the testing team to test the reports

Environment: SQL Server 2005/2008, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007,

T SQL, Oracle9i, Erwin, MDX, ProClarity, MS Excel, Visual Studio.Net.

MEDINOVA HOSPITAL LTD, HYDERABAD, INDIA MAY 2005 – FEB 2006

Role: SQL Server Developer/DBA

Medinova is one of the best hospitals in India offering quality service to the people. It gives emphasis on providing best quality services and is equipped with latest diagnostic equipment from the world-renowned suppliers. Medinova has already served 3 million people in India.

Responsibilities:

Review, develop and designs data models, in conjunction with the application development team.

Translates requirements into physical database structures that integrate with existing or proposed database structures.

Work with databases to optimize database performance and resource usage

Performs database performance monitoring and implements efficiency improvements including capacity planning.

Assists development staff with the application design to facilitate effective use of database languages, methodologies and established standards.

Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.

Created various reports using MS Reporting Services. And deploy public reports in dynamic web portal.

Loading data from various data sources using MS Data Transformation Services (DTS).

Interacted with team members on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.

Environment: SQL Server 2000, VBScript, ASP, Excel, MS Access, Visual Basic 6.0, and Windows 2000/NT 4.0

EDUCATION

B. Tech in Electronics and Communication Systems, JNTU, India – 2005

Master of Science in Computers and Information Systems, Tennessee State University, USA – 2008

RESEARCH

Published research paper in Artificial Intelligence

Contact this candidate