SUMMARY:

• Over 7 years of MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management, domains with expertise in MSSQL Server 2008/2012/2014/ 2016 and over 5 years of experience in Microsoft’s Business intelligence stack products like SSIS and SSRS.
• Expert in TSQL - DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Experienced in debugging and performance tuning of sources, targets and mappings.
• Developing reports on SSAS&SSRS on SQL Server ( 2008/2012/2014/ 2016 ).
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Creating and deploying parameterized reports using Power BI
• Worked in SDLC(Systems Development Life Cycle) for developing systems/Software
• Implemented error handling and roll back process in ETL load.
• Good experience working with Tableau.
• Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Hands on Experience in Domo which specializes in business intelligence tools and data visualization .
• Experience with T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity
• Expertise in creating Cell Level Security in cubes using SSAS.
• Worked with Financial companies for application related pricing and security applications
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Experience using recent versions of Microsoft Visual Studio 2008/2012.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS
• Developed Reports using efficient data retrieval techniques
• Experience in Tuning SQL queries and T-SQL queries, MDX& improving the performance of the queries.
• Used Epicor which provides enterprise resource planning (ERP). Epicor also provides customer relationship management (CRM), supply chain management (SCM), and human capital management (HCM) software to business customers in both Software as a Service (SaaS) and On-Premises deployment models .
• Extending an existing business workflow to push key data into a Power BI dashboard.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using Multidimensional Expression (MDX).
• Experience with Windows Communication Foundation (WCF) is a framework for building service-oriented applications.
• Research denials to identify and implement changes needed to our systems in order to meet payor requirements around claim formatting, billing and submission guideline.
• Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Developed and designed reports with SSRS and ETL processes using SSIS .
• Developed data interface layer using ASP.NET and C# for data access.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Successfully deployed reports in various sources like XML, Web browser and PDF
• Experience in MS Business Intelligence tools like SQL Server Integration Services, Analysis Services and Reporting Services.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), SQL Server Query Analyzer, SQL Server Agent,: SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server 2008/2012/2014/ 2016 Integration Services (SSIS), SQL Server 2008/2012/2014/2016, MS Visual studios 2008/12: Reporting Services (SSRS),Power BI,DBCC, BCP, MDX, SQL Server Profiler.

ETL: DTS, SSIS 2008 R 2/2012/2014/2016, Hadoop

Reporting Tool: SSRS, Business Objects, Tableau.

Programming Languages: T-SQL, C, C++, C#,.Net, JAVA, ASP.Net

Databases: MS SQL Server 2008 R2/2012,2014/2016, Oracle 9i/10g/11g, SQL, MySQL & MS Access MS Access 2000/2003, Teradata12.

Data Modeling Tool: Erwin, Microsoft Visio 2000/2003

Operating System: Microsoft Windows 95/98/2000/2002/ Vista/Windows 7,Linux

Backup Tools: LiteSpeed, Veritas.

Enterprise Scheduler s: Tidal

Methodologies: Agile, SDLC, Waterfall.

Versioning System: TFS, GIT

PROFESSIONAL EXPERIENCE:

Confidential, MA

SQL Server BI (SSAS, SSRS, SSIS) Developer

Responsibilities:

• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008/2005 (SSAS)
• Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.
• Designed, Build the 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.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Business intelligence/data warehousing technology skills with proven expertise in Visual Studios 2008/2012.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Created Tableau Dashborads with interactive views, trends and drill downs along with user level security.
• Identify updates and/or changes to payor requirements prior to implementation and work with applicable Revenue Operations teams to ensure those changes are accurately reflected in all systems.
• Developed/run SQL queries to analyze system data in order to clearly identify scope of changes needed, and to evaluate needed business decisions and approvals before changes can be made in the system.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Worked on Exposing a workflow implemented using Windows Workflow Foundation as a WCF service.
• Worked on Payor (Provider) and Payer (Member/Insurance Company) source files and processed them and load.
• Scheduling the SSIS packages and Jobs.
• Experience in designing Database Models using MS Visio and ER-Win.
• Good Knowledge on data visualization tools Power BI and Power Pivot.
• Creating and deploying parameterized reports using power BI and Tableau.
• Implemented entire ETL job plan through Informatica Scheduler.
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Excellent report creation skills using Microsoft SQL Server 2012/2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
• Involved in partitioning of cubes in order to increase the performance of cubes ( SSAS ).
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Experience in creating ASP.Net User Controls and Components to reduce the complexity of user interface design.
• Strong understanding of advanced Tableau features including calculated fields, parameters, tables calculations, row-level security, joins and dashboards actions.
• Implementation of Ajax feature for improved performance
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: SQL Server 2012/2014 Enterprise Edition,Payor,WCF,ASP.net SSAS, SSIS, SSRS, T-SQL, Power BI Windows Server 2008, Ms excel 2003,Tableau, Microsoft Visual Studio 2008/2012/2016.

Confidential, CA

SQL Server BI (SSAS, SSRS, SSIS) Developer

Responsibilities:

• Designed ad-hoc reports, grouping and sorting using SSRS .
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources .
• Developed Complex SSRS Reports involving Sub Reports ( Matrix/Tabular Reports, Charts and Graphs ).
• Deployed SSRS reports to SharePoint Server for the end users to look at them.
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services .
• Involved in migrating SQL Server 2008 R2 to 2016.
• Creating Distributed Partitioned Views, Debugging / Troubleshootin g Stored Procedures, upgrading existing ones.
• Defined best practices for Tableau report development .
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Written SSIS packages in 2016/2012/2010/2008 .
• Effectively used data blending feature in Tableau.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Created SSIS packages to transfer data from various sources like Teradata, Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.
• Make system architecture decisions using payor documentation, system knowledge and business rules, to efficiently and compliantly set up our systems in line with payor requirements.
• Conduct research and ad-hoc analysis to support revenue cycle goals. Designer and Developer.
• Creating and deploying parameterized reports using Power BI
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts .
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Developing OLAP cubes using SSAS 2008R2 and 2016 and calculates the metrics that were revealed in the functional analysis.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
• Involved in Dimensional modeling by identifying the fact and dimension tables and design start/snow flake schemas for the SSAS .
• Worked on which WCF supports publishing service metadata using formats specified in industry standards such as WSDL, XML Schema and WS-Policy.
• Worked on creating calculated measures that fits business logic, using MDX queries .
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS)
• Involved in designing Data Marts, Data Warehouse .
• Used Grid Controls, Checked List Box Control and Panel controls to display and manipulate data in win Forms.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.
• Developed Windows User Controls using Win forms controls and custom controls using c#.
• Designed and Developed Web Pages using ASP.Net Framework4.0
• Used Data Adapters, Datasets and Command & Connection Objects of ADO.NET to Manipulate Data in the SQL Server Database .

Environment: MS SQL Server 2016/2014/2012/2008, Visual studios 2008,2012,WCF,T-SQL,Payor, SSRS, SSAS, SSIS Packages, SSRS,Tableau, MDX, ETL, ASP.Net 3.0, Ado.Net 4.0, C#.Net, Excel, MDX, OLAP, OLTP, Access, Power BI, Windows 2003 Server.

Confidential, New Brunswick, NJ

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources ( Excel, CSV, Oracle, flat file, Text Format Data ).
• Created the logical and physical data modeling using Erwin tool.
• Created SSIS packages to migrate data from Oracle 8 i to MS SQL Server 2005 .
• Used BCP utilities, Data Transformation Services (DTS ), Extract Transform Loading tool ( SSIS ) to populate data from various data sources, created packages for different data loading operations for application.
• Created SQL server Reports using SSRS 2005 for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports .
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports .
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created Queries for generating drill down reports in SSRS .
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL .
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server ( SSAS ).
• Created Condition Objects in the Universe to restrict data
• Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
• Created simple SQL query filters, prompted filters and complex filters to restrict data in reports.
• Collected business requirements, designed data maps and data models . Created Internal and External Design Documents and Transaction Definition Documents .
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Created several stored procedures, triggers, views.
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Tuned lots of ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Environment: MS SQL Server 2005/2000, SSRS, SSIS, SSAS, MDX Cubes, ADO,WCF, MYSQL,T-SQL,Asp.net, .NET,Payor, Stored Procedures, Visual studios 2008/2012, HTML, XML, IIS 6.0, MS, Visual Fox-pro, DTS, Crystal Reports 9.0

Confidential, Chicago, I L

SQL Server BI (SSAS, SSRS, SSIS) Developer

Responsibilities:

• Developed applications and supported existing applications in MS Access .
• Designed UML diagrams such as Use Case Diagrams (UCD’s), Activity Diagrams in accordance with UML standards making use of MS Visio .
• Developed Use cases and Activity process flow diagrams using MS Visio for the Facets Membership Enrolment Process.
• Extract Transform Load ( ETL ) development using SQL Server 2005, SQL 2008R2 Integration Services (SSIS ).
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau .
• Successfully performed Conceptual Data Modeling, Logical Data Modeling (LDM) and Physical Data Modeling (PDM) in accordance with the business requirements.
• Worked on Performance Point Server ( PPS ) and created management reports.
• Implemented Pivot Table to automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Created SQL Server Reports using SSRS 2005 .Identified the data source and defined them to build the data source views.
• Tested the changes for the front end screens in FACETS related to following modules, test the FACETS batches (membership).
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.
• Responsible for working with the State to review and modify process flows to increase productivity and effectively utilize FACETS features not provided by the legacy systems.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008R2
• Generated different reports using MS SQL Reporting Services and Crystal Reports
• Organized JAD sessions with management, subject matter experts (SME) to develop new specifications and resolve pending issues.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008R2 as SSIS Packages.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2005 .
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Developed Analysis Services Project. Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS . Responsible for identifying and defining Data Source and Data Source views . Created cubes and defined the dimensions.
• Deployed, Tested and Scheduled SSIS packages.
• Gathered requirements from business users such as trade approver, and created business requirements document ( BRD ).
• Involved in the design, development and implementation of web user interfaces using C #. NET, ASP.NET
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created SQL Server Analysis Project using MS SSAS 2005 .
• Developed incremental loading using MERGE statement in SQL server 2008R2 .
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Performed Documentation for all kinds of reports and DTS and SSIS packages .
• Experience in Data Warehouse Modeling with SQL Server Analysis Service ( SSAS ).
• Managed MSSQLserver (storage, memory, processing) and their dependencies/performance bottlenecks

Environment:: Windows Server 2003, SQL Server 2008R2, SQL Profiler, SSIS, SSRS,SSAS, SQL*Plus, Teradata SQL Assistant,Payor,Sybase 11.x, Toad 8.5, Doors, Crystal Reports, Erwin, Facets, XML, MS Visio, Data Junction(ETL tool),T-SQL, Visual Studio 2008/2012/16, C#, MS Office, SQL, Oracle 10g.

Confidential

SQL BI Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views ).
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML .
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMS like SQL Server .
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, I ndexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import / Export for transferring data from Heterogeneous Database to SQL Server.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007 .
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server .
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.

Environment: SQL Server 2005 /2000, 64 bit edition of SQL server 2000), DTS,Visual studios 2008/2012, Crystal Reports, Microsoft Business Intelligence Development Studio,Payor, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS.