SQL BI Lead
Resume:
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