PROFESSIONAL SUMMARY:

• Over 7 Years as an experienced BI Analyst, and MS SQL Server Development experience in Finance, Manufacturing & Distribution, Telecommunications, Healthcare/Insurance Industry and Excellent knowledge about health care industry and claims management with expertise in MS SQL Server 2005/2008/2008 R 2/2012/2014/2016 and Microsoft’s suite of products like SSIS, SSAS, and SSRS. With an MS in Computer information systems background, I have a strong analytical approach to business analysis and management.
• Technically and logically very sound in T - SQL Programming, SSIS, SSRS, SSAS, Data warehousing, Business Intelligence etc.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008/12/14/16.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Good Functional Knowledge in SD, MM and FI module of SAP.
• Performed data extraction, transformation and loading from SAPand non-SAPsource systems into the SAPBW.
• Designed the dimensional star schema for a large-scale warranty data warehouse and implemented the ETL process in SQL Server 2016's DTS technology; implemented (Kimball "type-2") dimensional history to provide audit trail of dimensional changes.
• Excellent Power BI skills,Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database and development experience as well as in Microsoft technologies SSIS, SSRS, SQL server, Power Pivot, Power View, and related technologies
• Hands-on experience and exposure to different phases of Software Development Life Cycle(SDLC), Agile and Scrum Methodologies.Experienced in building SQL applications from scratch.
• Developed power BI reports and dashboards from multiple data sources.
• Good understanding of how traditional processes apply to the modern world, how Azure Data Factory(ADF), Azure Data Lake(ADL), Azure Analysis Services(AAS) can supplement SSIS etc.
• Maintain DB2relational databases.
• IBM DB2 Utilities and BMC DB2 Administration, Backup, Recovery and Utilities.
• Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
• Medical Claims experience in process documentation, analysis and implementation in 835/837/834/270/271/277/997 (X12 Standards) processes of Medical Claims Industry from the Provider/Payer side, Medicaid, & Medicare, Managed and maintainedHEDISfiles and records.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Proficient in usage of SSIS Control Flow items (For Each Loop, For Loop & Sequence container, execute package, execute SQL tasks, Script task, send mail task) and transformations (Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast).Hands on experience on ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Experience in using SQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services.Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSASto develop OLAP cubes having Star/Snowflake schemas.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSAS, SSRS, DTS)

Reporting Tools: SSRS 2016/2014/2012, Crystal Reports 14.1.x/14.0.x/12, Excel, PowerBI(Power Query, Power Pivot, Power View, PowerMap), Tableau

Database: MS SQL Server 2016/2014/2012, Oracle 12c/11g/10g, MYSQL, MS-ACCESS.

Programming: C, C++, Visual C++ 2012, C#.Net, VB.Net, PL/SQL,Powershell

Database Design Tools: Erwin 5.1, MS Visio 2016/2013, Rational Rose(UML)

Tools: & Technologies: PerformancePoint Server 2013, Enterprise Manager, SSMS, EMC Net Worker, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, QTP, Microsoft Office SharePoint Server 2013.

Version control: Visual SourceSafe 6.0, Team Foundation Server, PVCS(Polytron)

Operating System: Windows 7/8, Windows 2007 Server, UNIX.

Application Servers: Microsoft IIS 8.0/7.5, Apache.

WORK EXPERIENCE:

Confidential, Richardson, TX

SQL BI Developer/SSIS/SSRS/SSAS/PowerBI

Responsibilities:

• Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
• Creating tables, indexes and designing constraints.
• Creating triggers, stored procedures, Views, Query writing.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning
• StrongSQLServerDeveloperskills including writing triggers, Stored procedures, Views, Query writing.
• Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, ConformedFacts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Developed and deployed SSIS packages in Production Server.
• Defined Key Performance Indicators (KPIs) and involved in design the data model and its components within SAP BW.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Assisted in designing, planning and managing the data migrationprocess.
• Developed many ETL using SSIS (SSDT-2015), created security model using SSAS Tabular Model (DAX), using GitHub as source control. Generated hierarchy based - role based reports in SSRS/PowerBI for the management.
• Designing dashboards with use of visualization tools like Tableau.
• Designing dashboards with the use of visualization tools like Tableau, Using SQL for managing large volume of data.
• Creating Power BI dashboards and deploying them to SharePoint.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS.
• Expert knowledge on Microsoft proprietary SCOPE language specification (de-facto standard for all data related operations) for Microsoft Internal COSMOSplatform for a majority of usage streams such as Azure Compute, Azure Storage, Azure SQL & Azure DocDB.
• Maintained high degree of competency across the Microsoft Application Platform focusing on .NET Framework, WCF, Windows Azure, and SQL Azure.
• EDI820 testing for APTC/ CSR payments from federal exchange (FFM)
• Medical Claims experience in process documentation, analysis and implementation in 835/837/834/270/271/277/997 (X12 Standards) processes of Medical Claims Industry from the Provider/Payer side, Medicaid, & Medicare, Managed and maintainedHEDISfiles and records
• Knowledge in the Data Analysis, Design, Development, Implementation and Testing of reports generated in Web Focus.
• Good experience in front end development usingoracleforms/reports6i/9i/10g.
• Proficient inPL/SQLprogramming - Stored Procedures, Functions, Packages,SQLtuning, and creation ofOracleObjects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in DynamicSQL,PL/SQLCollections and Exception handling
• For new insurance carrier onboarding’s, create the test suite of sampleEDI834 enrolment files to cover different policy tiers, maintenance files for change transactions
• Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc.
• Experience in Migrationusing SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Packages Migration Wizard and knowledge on Storage Management.
• Created report models for ad-hoc reports using SSRS 2016 with Excellent Power BI skills,Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database and development experience,as well as in Microsoft technologies SSIS, SSRS, SQL server, Power Pivot, Power View, and related technologies.
• Setup and testing ofEDIsystem for multiple enterprises as per the company standards and requirement of the enterprise.
• Created Workspace and content packs for business users to view the developed reports using power BI.
• Designed a detail test plan for testing the entireEDIdata flow for both inbound and outbound flows sent/received data, performed translation and verification of loops and data.
• Designed and created Report templates, bar graphs, pie charts based on the financial data.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSASto develop OLAP cubes having Star/Snowflake schemas and also with Data Profiling.
• Good experience in front end development usingoracleforms/reports6i/9i/10g.
• Proficient inPL/SQLprogramming - Stored Procedures, Functions, Packages,SQLtuning, and creation ofOracleObjects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2016.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Environment: MS SQL Server 2016/2014/2012 /, T-SQL, SSAS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server Query Analyzer, Power BI, MDX, SQL Server BIDS, MS- Visual Studio 2013.

Confidential, Folsom, NJ

SQL BI Developer/SSIS/SSRS/SSAS/Tableau/PowerBI/Analyst

Responsibilities:

• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Servers
• Created SSIS package to load multilevel XML data into SQL SERVER database.
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports in SSRS.
• Migration of databases from SQL Server 2012 to SQL Server 2014.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. EDI820 testing for APTC/ CSR payments from federal exchange (FFM).
• Created Backend validations using Insert/ Update and Delete triggers.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Good experience in front end development usingoracleforms/reports6i/9i/10g.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2014.
• Lead ETL Developer for the design and creation of 2 new Data Marts with bi-directional links to Siebel Analytics and Siebel CRM as part of the Enterprise Data Warehouse for a major cruise company. Analyzed Siebel source systems and source data, created functional and technical designs, created complex map designs, created error handling and update strategies and created test plans and test cases. The Data Marts used the Bill Inmon methodology. The Enterprise Data Warehouse included staging, data store and presentation areas.
• Designed a detail test plan for testing the entireEDIdata flow for both inbound and outbound flows sent/received data, performed translation and verification of loops and data.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• StrongSQLServerDeveloperskills including writing triggers, Stored procedures, Views, Query writing.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSASto develop OLAP cubes having Star/Snowflake schemas.
• Excellent Power BI skills,Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database and development experience as well as in Microsoft technologies SSIS, SSRS, SQL server, Power Pivot, Power View, and related technologies
• Worked on Power Bi and created reports and dashboards and published them on service.
• Experienced and Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS 2012,2014
• Expertise in working with SSASTabular model to produce reports in excels files using pivot tables.
• Experience in creating and managing SSAS Tabular models, creating Dimension Tables and Fact Tables
• Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Building BI capabilities in an organization, with specialized capabilities including Business Intelligence (BI).
• Appliedsecurity featuresof Business Objectslike row level, report level & object level securityin the universe to make the sensitive data secure.

Environment: MS SQL Server 2012, SSAS, SQL Server Reporting Services 2012, SSIS, Power BI, Power Shell Front Office 8.3 / 10.2 / 10.3, Windows XP / NT / Vista/2007, MS Office 2007/2010.

Confidential, Omaha, NE

SQL BI Developer/SSIS/SSRS/SSAS/PowerBI/Analyst

Responsibilities:

• Involved in writing scripts for client requirements for reporting purposes.
• Responsible for writing T-SQL code for creating cursor and handling the data validations.
• Developed complex T-SQL code for the application.
• UsedDAXfunctions to generate spreadsheets and pivot tables.
• Developed queries and troubleshooting techniques to help with AX production support ticket resolution. Developed dashboard metrics for ongoing ERP work. Responsible for the content of many of theDAXreleases
• Designed the dimensional star schema for a large-scale warranty data warehouse and implemented the ETL process in SQL Server 2016's DTS technology; implemented (Kimball "type-2") dimensional history to provide audit trail of dimensional changes.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• StrongSQLServerDeveloperskills including writing triggers, Stored procedures, Views, Query writing.
• Monitored Scheduled jobs and alerts. Create new SSIS Packages to export flat files.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2012/2008 using Oracle 11g as the data source.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSASto develop OLAP cubes having Star/Snowflake schemas.
• Worked on Power Bi and created reports and dashboards and published them on service.
• Experienced and Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS 2012,2014
• Experience in working with SSASTabular model to produce reports in excel files using pivot tables.
• Experience in creating and managing SSAS Tabular models, creating Dimension Tables and Fact Tables.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Designed various types of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports, Sub reports, bar charts and matrix reports.

Environment: SQL Server 2008, Enterprise Edition, SQL, Enterprise manager, SSRS 2008, SSIS 2008, Spotlight, MS SharePoint, MS Access 2010 & Windows 7, platform,C#,VB.NET,ASP.NET.

Confidential

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in User Requirement Gathering and Technical Specification Documentation.
• Involved in Designing of the logical and physical database
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Creating transactional and merge replication on different servers.
• Performance tuning at Database level, T-SQL level and operating system level.
• Trouble shooting Problems by using SQL server profiler.
• Creating DTS packages to maintain central repository by extensively using different SQL2008 DTS tasks.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, and flat file, XML in order to create and maintain a centralized data warehouse.
• Plan and implement data roll-up from live site to data warehouse.
• Created reports using Crystal Reports using imported data sources.
• Generated various reports using Crystal Reports.
• Resolving the bugs in the database.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2008, DTS, Crystal reports, .Net Framework1.1, ASP.NET, C#.NET, VSS, IIS 6.0, Windows XP

Confidential

SQL BI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis.
• Determined the MS SQL Server 2008 installation options. Installed SQL Server Management tools using SQL Server Setup Program.
• Test the Installation of SQL Server and implemented different security modes.
• Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Handling the orphan rows in Dimension and Fact tables.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Worked on Client/Server tools like MS SQL Server 2008 Enterprise Manager and Query Analyzer to Administer SQL Server.
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2008.
• Created Distributed Partitioned Views, Debugging/Troubleshooting Stored Procedures, and upgrading existing ones.
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Designed DTS package, with DTS Import/Export wizard for transferring data.
• Data migration (Import & Export - BCP) from text to SQL Server.

Environment: MS SQL Server 2008 Enterprise Edition, Enterprise manager, MS Analysis Services 2008, MS Access 2008, Reporting Services, Crystal Report 8.0, DTS, Windows Active Directory.

Confidential

SQL BI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed and analyzed the SQL Server database and involved in gathering the user requirements.
• Reviewed, developed and designed data models, in conjunction with the application development team.
• Migration of databases from SQL Server 2005 to SQL Server 2008.
• 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 and integrated user defined functions and stored procedures for reporting purposes.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Assisted development staff with the application design to facilitate effective use of database languages, methodologies and established standards.
• Recommended the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures.
• Created various reports using MS Reporting Services and deploy public reports in dynamic web portal. Tuned complex SQL Queries.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Logical and Physical design of database for project on basis of user requirements.
• Created new tables, stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling of jobs.
• Performed data conversions from flat files into a normalized database structure.

Environment: SQL/Oracle 7.3 Forms 4.5, Reports2.5, PL/SQL and Win NT.