SUMMARY

• Over 7+ Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL/Business Intelligence Developer with expertise in SQL Server Integration Services, Analytics, Reporting and Self Service BI
• Expert in working with teh Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experienced in writing complex T - SQL queries using Inner, Outer and Cross Joins.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up teh SQL Server Performance.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Having strong experience in MDX SVN, GitHub.
• Having strong experience in scheduling all teh T-SQL jobs to run at particular times.
• Good knowledge in Normalizing and De-normalizing teh tables and maintaining Integrity using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Proficient in OLTP, OLAP and Data warehousing Design concepts.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Implemented teh business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from teh tables.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Experienced in Data Masking and security of PII data (IBM OPTIM), Testing, Debugging, Validation and Reporting
• Having strong experience in all Test Driven Development and Continuous Integration.
• Very good experience in writing expressions in SSRS.
• Review, validate and cleanse claims data towards preparation of teh final data set for claims analysis
• Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts.
• Developed reports using global variables, expressions and functions using SSRS.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.
• Proven understanding of Hadoop SQL base tools such as Hive & Impala and Experienced in running query using Impala and used BI tools to run ad-hoc queries directly on Hadoop.

TECHNICAL SKILLS

Business Intelligence Tools: Microsoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer), Qlikview Self Service BI

ETL Tools: SSIS, Informatica Power Center 7.x, Ascential Data Stage 7.5, SAP - Business Warehouse, Power Query

Database Systems: MS-SQL Server 2000/2005/2008/ R2/012, Oracle 10g/11g, DB2, MS Access, IBM Data Studio

Database Management Tools: SQL Query Analyzer, SQL Profiler, DTA, SQL Server Activity Monitor, SQL Server Logs, Toad, Hue

Programming Languages: T-SQL, PL/SQL, .Net, MDX, DAX, HTML

Operating Systems: Windows 98/ME/2000/NT/XP/2003/7, MS DOS, Linux, IIS 5, 6,IBM

Project Management: Microsoft Project/Office 2003,2007, 2010, 2013, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Oakbrook, IL

SQL BI Analyst

Responsibilities:

• Develop ad-hoc reports using MS SQL Server, SQL Reporting Services, SQL Server Integration Services and Power BI.
• Solid understanding of relational database, modeling concepts and Power BI Dashboard Reporting.
• Understands how to prioritize reports according to business need, regulatory requirements, urgency and / or other key business factors.
• Coordinates data and analyses from MHI and / or Health Plans as needed.
• Modifies reports in response to error identification and / or approved change requests; understand teh balance between responsiveness to business requests for enhancements versus department needs to complete work efficiently and timely.
• Analyzing, requirements gathering, documentations, coding like stored procedures and packages, Query optimizing, testing, bug fixing, designing reports usingSSRS and SQL server 2005.
• Writing SQL server stored procedures and create / maintain SQL Server Development Database objects in teh data warehousing environment
• Conduct data mapping, design, develop, and implement extract / transform / load processes using custom ETL based on SSIS technology.
• Help Optimization of queries and performance tuning to make teh queries to run fast from tables with millions of records using PL/SQL codes.
• Creating adhoc reports and automate reports as and when needed using SSRS and Power BI
• Participated in team meetings and got involved in technical design/ planning of middle ware database to combine data from various sources.
• Responsible for developing business centric reports, dashboards, data requests, metrics, and other tools using teh Microsoft Business Intelligence framework. Represent teh department in fostering and developing relationships with other business units requesting business intelligence services. SSAS, SSIS and SSRS
• Develop data extraction, wrote SQL queries, stored procedures, and packages, and manage data integrity for teh data used in teh reporting projects.
• Working on migrating SQL code to Data Lake Impala. Creating dynamic SQL parameters in SSRS when using Data Lake as a source.
• Working on importing data into data lake sandbox and Queried both Managed and External tables created by Hive using Impala.
• Working experience in various kinds of data sources such as Teradata and Oracle. Successfully loaded files to HDFS from Teradata, and load files from hdfs to hive and impala.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server reporting services (SSRS), T-SQL and MDX, Power BI, Toad Workbook 5.2, Hue Editor.

Confidential, Chicago IL

SQL Server BI Developer

Responsibilities:

• Involved with business analysts in creating/reviewing business requirement documents
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Created tables for loading Provider and claim data in SQL server 2016
• Developed high performance views/ stored procedures for generating extracts for Provider and Claim data.
• Developed new ETL architecture for loading data using SSIS instead of Data Stage
• Developed various SSIS packages for loading teh Provider, Claims and Membership data into a data warehouse.
• Created complex Packages in SSIS 2016 as part of automating teh extract Process.
• Teh packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SSDT 2016.
• Generated different SSRS reports for different providers and provided subscriptions on daily, weekly, Bi-weekly, monthly, Quarterly and yearly basis
• Loading Data into different environments based upon teh requests.
• Analyzed teh data models to document teh tables & their relationships.
• Worked on different data sources (xml source, excel, csv, flat file, web service) to pull, parse and load data into client servers.
• Optimized SQL queries and procedures for efficiency and to reduce time duration of data load.
• Created teh store procedures and Data Modeling to back up teh production data.
• Create database objects such as tables, views, stored procedures, Triggers, User Defined Functions, linked server queries for extracts from db2 and MySQL.
• Created teh SSIS package to filter teh physician data according to Vendors and Hospital Management requirement.
• Also created teh SSRS package to generate teh Reports for Financial team.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), T-SQL and MDX, SVN. Continuous Integration

Confidential, Memphis, TN

MS SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on teh requirements using SSRS 2012,2014
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand teh Business requirements.
• Extensively involved in designing teh SSIS packages to export data from flat file source to SQL Server database.
• Experience in creating XML files by designing teh SSIS packages and SQL server.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per teh requirement.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within teh report.
• Designed, Build teh Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Rendering teh reports to PDF formats as per teh requirement and printing all teh reports in a batch process for Monthly Statements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)
• Scheduling teh SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.
• Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from teh Data Warehouse. Periodically developed a Report to be used by teh Senior Management utilizing SSRS.
• Developed SAS Macros for data cleaning, reporting and to support routine.
• Develop and Debug T-SQL scripts in a complex relational database system (RDBMS).
• Worked on Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 by using MDX And generated teh Reports using SSRS and Power BI tools for vendors.
• Built teh whole new Data Base with table’s, views, triggers, indexes and store procedures to avoid teh use of Access Data Base. And created teh SSIS package to send teh data to vendors.
• Created teh optimized SQL query’s to get teh data from DWHS to avoid teh use of Adhocs.
• Worked on teh optimization and performance tuning of SQL Server using Profiler

Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, GitHub and SVN and Continuous Integration.

Confidential, Atlanta, GA

SQL Server/ BI Developer/SSIS/SSRS

Responsibilities:

• Interact with Business Analysts and Developers in identifying teh requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
• Used Framework Manager to build models, packages and publish packages to Cognos Connection.
• Implemented OBIEE solution for ‘Sales’ subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and tan loaded teh data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Worked on IBM Data Masking tool - Optim, to ensure teh state PII data is not exposed on teh wire and security.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes. Designed T-SQL scripts to identify long running queries and blocking sessions.
• Extensive experience working in an Agile development environment
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Performed incremental data load packages in SSIS
• Used Teradata utilities fast load, multi load, to load data
• OLAP design (SSAS 2008R2) for different cloud services and service items. Implemented OLAP cube and connecting using Excel Power Pivot.
• Created Complex dashboards and published to Cognos Connection portal.
• Wrote, tested and implemented Teradata Fast load, Multi load and Bteq scripts, DML and DDL.
• Used TOAD,PL/SQL developer tools for faster application design and developments
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
• Created Metadata Modeling by using multiple data sources in Cognos 8 BI Modeling.
• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
• Development of .NET batch applications which processes high volume of data.
• Extensively used Korn Shell Scripts for doing manipulations of teh flat files, given by teh share brokers.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Bursting and scheduling teh Reports using Cognos connection.
• Involved with testing and exploring tools using Query Studio and Report Studio.
• Developed modules of teh application in ASP.NET, Silverlight and involved in writing C# classes.
• Used UTL JOB to automate teh PL/SQL procedures and packages
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed, tested, debugged and documented Oracle PL/SQL packages and types in accordance with company policies, company standards and industry best practices.
• Assisted in teh conversion of existing PowerBuilder code to PL/SQL and Java to support a new Flex application.
• Tested coding modifications and assisted with application and system testing to minimize errors and downtime.
• Written PL/SQL Procedures, Functions, Packages, and SQL ScriptsusingOracle SQL and PL/SQL.
• Developed data model,PL/SQL Queries, SQL Query tuning process,andSchemas.
• Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Formulated SQL queries, functions and processes as per requirement.
• Worked with developers to repair and enhance current base ofPL/SQL packagesto fix testing issues.
• Created and maintained PL/SQL scripts and stored procedures.
• Huge experience in developing Oracle PL/SQL packages and object types
• Solid understanding of inheriting PL/SQL object types, casting PL/SQL object types into descendant types, converting PL/SQL object collections into a result set, bulk operations and pipelined functions
• Built new functionality and improve processing time throughcode optimizations and indexes.
• Handled errors usingException Handlingextensively for teh ease of debugging and displaying teh error messages in teh application.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages.
• Experience working with Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index Organized Tables, Partitions, Objects/Collections, Execute Immediate etc.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Written packages, triggers, stored procedure and functions for Solvency project which involved retrieving data using FTP, scheduling through AUTOSYS, extracting and loading using ETL (Data Stage) and PL/SQL.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• Improved teh performance of teh application by rewriting theSQL queries.
• UsedSQL*Loaderas an ETL tool to load data into teh staging tables.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQL Collections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Used principals of Normalization to improve teh performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• Involved in teh continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformationandload packagesfordata ware housing.Extracted data from theXMLfile and loaded it into thedatabase.
• Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
• Defect tracking through JIRA and defect summary reporting.
• Proficiency with SCCS and Clear case version control systems.
• Worked on agile and test driven environment, participated on daily scrum meeting, and discussions.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, SQL*Plus, PL/SQL, Oracle Designer 2000,Windows 2000, Toad.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Teh project is designed in two phase’s data gathering and reporting, teh data gathering part is done using SQL Server Integration Services (SSIS) and teh reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files
• Developed a .NET batch application responsible for processing Medicare enrollee information from Voyager into FACETS.
• Extensive experience working in an waterfall development environment
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Managed teh metadata associated with teh ETL processes used to populate teh data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations
• Analyzed and designed new .NET Web, Batch and WCF application from design to completion stage.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Granted permissions to logins, groups to particular database or to a server depending on teh requirement.
• Regularly monitored database sizes and disk space.
• Arranged meetings with teh developers and other DBA’s to discuss teh current and new policies which can be established.
• Developed web parts using C# and SharePoint object model.
• Created indexes to speed teh execution of data retrieval queries, rebuilding them if necessary and often checked for any outdated statistics
• Scheduled teh backups for Databases and performed restoration operations when needed.
• Used log shipping for synchronization of databases and documented every change.
• Designed & developed teh various SSIS packages for teh daily, Hourly, Weekly & Monthly Loads
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute Sql flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts formerly in Cognos reports and SAP BO
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• On teh required reports, identified various data sources and established teh connections using SSIS and constructed data source view

Environment: MS SQL Server 2008, DB2, Teradata, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, Team Foundation Server, MS Visio, ff Scrum Methodology, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS