SUMMARY

• Having 8 years of experience in implementingBIsolutions in Healthcare, Health insurance, and P&C industries using MSBI Stack (SSIS, SSAS, SSRS, and PowerBI).
• Involved in all phases of SDLC from requirement gatherings through post - deployment of application systems in large and small organizations using agile methodology.
• Proficient in creating packages as part of ETL - extracting data from heterogeneous sources like Excel, Flat file, OLEDB source, and loading toSQLServer databases using SSIS (2016/2014/2012 ).
• Experienced in using various SSIS control flow items like executeSQLtask, Data Flow task, Send Mail Task, File system task, Bulk Insert Task, for-each Loop, and Sequence Container.
• Experienced in debugging SSIS packages using checkpoints, breakpoints, and error handling by configuring send mail tasks using event handlers.
• Proficient in logging the runtime information into different log providers likeSQLServer, and Text File using SSIS Logging to increase the performance of SSIS packages.
• Designed, Developed & maintained databases on Microsoft's cloud computing platformSQLAzure.
• Experienced in transforming the data as per business needs using different transformations like Conditional split, Merge join, derived column, data conversion, and Fuzzy lookup in SSIS.
• Experienced in performing an incremental load of data into DW using SCD, Lookup.
• Strong experience in writing complex T-SQLqueries and creating database objects like tables, views Stored Procedures and Triggers.
• Object-oriented programming in Python C/C SQL Unix/Linux/Mac/Windows Perl Shell scripting
• Experienced in performance tuning of long-runningSQLqueries usingSQLserver built-in tools likeSQLServer profiler, Execution plan, and creating indexes.
• Strong Experience in designing diverse reports like tabular, matrix, parameterized, drill through, ad-hoc, linked reports, charts, and sub reports both for operational and regulatory needs using SSRS (2008/2012/2014/2016 ).
• Well experienced in deploying the reports, managing the reports in the report server by creating folders, and permissions, and delivering the reports in various formats using subscriptions.
• Proficient in optimizing the performance of various SSRS reports by modifying stored procedures and creating cache reports and snapshots in the report server.
• Enhanced the functionality in data warehousing concepts (OLAP) Cube by creating KPI, Actions, Perspective, and Hierarchies usingSQLServer Analysis Services (SSAS) and Dimensional Modeling Techniques such as Star and Snowflake schema.
• Expertise in defining the DB schema as part of data modeling to define the entities and relationships, generatingSQLscripts using Erwin Tool.
• Hands-on experience in working with query editor (PowerBI) to extra data from heterogeneous sources, perform data cleansing and shaping and load them to the data model region.
• Strong experience in story narration for business users by creating worksheets in Tableau using various objects like calculated fields, actions, filters, parameters, groups, sets, and hierarchies.
• Ability to work in tight schedules and efficient in time management and highly motivated team player with the intensity of delivering high-quality outputs within the deadline.

TECHNICAL SKILLS

Databases Tools: SQLEnterprise Manager, Query Analyzer,SQLServer Management Studio, Business Intelligence Development Studio,SQLProfiler,SQLServer Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS), Export/Import,SQLServer Integration Service (SSIS), Informatica Power Center 9.1/8.6.

Reporting Tools: SQLServer Reporting Services (2016/2014/2012 /2008), MS Access, MS Excel, Crystal Reports, Business Objects 4.0, Power BI, Tableau.

Database: MSSQLServer 2016/2014/2012/2008 R2/2008, MS Access, Oracle 9i/8i

Programming Languages: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML and CSS

Operating Systems: Windows (10/8/7/Vista/XP), Windows 2015/2012/2008 Server

PROFESSIONAL EXPERIENCE

Sr SQL Server Developer

Confidential | Dayton, OH

Responsibilities:

• Defined and designed the data sourcing and data flows, and data quality analysis.
• Proactively create the framework to analyze system performance to ensure high availability and processing using a variety of tools. Identified the data source and defined them to build the data source views.
• Creating Stored Procedures in MS SQL Server.
• Written complex SQL queries involving multiple tables inner and outer joins, temporary tables, and table variables.
• Strong SQL programming skills and some stored procedure development.
• Creating DB driven web apps in Python JSON Postrgre SQL Cassandra Flask Peewee ORM WSGI Werkzeug
• Wrote Complex Stored Procedures, Triggers, Views, and Queries. Created indexes, Constraints, and rules on database objects. String technical knowledge in Troubleshooting and performance tuning.
• Developed and deployed SSIS packages to load data from OLTP to the Data Warehouse system.
• Reviewed EDI 837 Claim and flagged HIPPA non-complement claims received for the Payor side
• Designing flow of data from daily tables to weekly tables and monthly aggregates for in the billing Data marts.
• Defined best practices for Tableau report development.
• ImplementedAzure Application Insightsto store user activities and error logging.
• Created report schedules, data connections, projects, and groups in the Tableau server.
• Involved in Data Migration using SQL, SQL Azure, Azure Storage, and Azure Data Factory, SSIS, PowerShell.
• Identified and modified the KPIs, and measures in co-ordinance with the requirement and created calculated members in a cube using MDX queries in Business Intelligence Studio using SSAS.
• Translated various existingSSRS reports to Tableau dashboards.
• Documented Informatica mappings in Excel spreadsheet.
• Tuned the Informatica mappings for optimal load performance.
• Responsible for building reports in Power BI from the Scratch.
• Developed Python scripts to parse XML documents and load the data in the database.
• Developed automatic generated reports using Python and SQL.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Maintained stored definitions, transformation rules, and target definitions using Informatica repository Manager.
• Experience in publishing Power BI reports on dashboards in Power BI server.
• Created hierarchies in Power BI reports using visualizations like Bar charts, Line charts, etc.
• Worked with both live and imported data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different types of slicers available in Power BI for creating reports.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files, etc.) and loaded the data into the target data destination by performing various kinds of transformations using SQL Server Integration Services (SSIS). Tested and managed the SSIS and SSIS packages and was responsible for their security.
• Created/ Modified SSRS-based reports based on T-SQL and Stored Procedure with Input parameters.
• Worked with RDBMS objects such as tables, views, indexes, stored procedures, functions, and triggers in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Scalable Web Architecture based AWS Cassandrain Python Linux OS for High I/O GPS Application DevOps.
• Worked on maintenance of web applications using C# and ASP.Net.
• Created stored procedures and functions to support efficient data storage and manipulation. Created check constraints to maintain data integrity. Performing basic troubleshooting of conversion logic.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS.
• Proficient in design and development of various dashboards, and reports using Tableau.

Environment: MS SQL Server, MSSQLServer 2014/2016, SSRS, Power BI, Tableau 8.1, SQL, Microsoft Azure, Python MS Excel, MS word, Visual Studio 2017, SSIS, Linux, Informatica Power Center 8.6.1.

SQL/BIDeveloper

Confidential | Oklahoma City, Oklahoma

Responsibilities:

• Involved in Technical and Business decisions for Business requirements, Interaction with Business Analysts, Client team, and Development team through the Agile Kanban process.
• Creating Azure Data factories for loading the data to AzureSQLdatabase from Cosmos platform.
• Created complex powerBIdashboards.
• Developed, deployed, and monitored SSIS Packages for new ETL Processes.
• Performed the role of Scrum Master in daily stand-up calls.
• Developed, deployed and monitored SSAS cubes.
• Created SSIS Packages to Extract and load data from and to different sources and targets likeSQLServer, Text Files, Excel, and CSV feed them to the COUPA cloud server.
• Have developed a .NET interface using C# for the users to enter data on daily basis.
• Involved in the development and implementation of SSIS, Azure Cloud services
• Performed Column Mapping, Data Mapping and Maintained Data Models and Data Dictionaries.
• Involved in retrieving multi-million records for data loads using SSIS and by querying against Heterogeneous Data Sources likeSQLServer, Oracle, Text files, and some Legacy systems.
• Expertise in using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component, etc.
• Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files toSQLServer using SSIS/DTS packages using various features.
• Utilized libraries like Numpy, Panda, SQL Alchemy, Scipy, IPython etc. to develop python code
• Involved in Performance tuning of ETL transformations, data validations, and stored procedures.
• Strong experience in designing and implementing ETL packages using SSIS for integrating data using OLE DB connection from heterogeneous sources.
• Created Complex ETL Packages using SSIS which upsets data from staging tables to database tables.
• Created roles using SSAS to restrict cube properties.
• Implemented cell-level security in cubes using MDX expressions to restrict users of one region from seeing data of another region using SSAS.
• Created calculated measures using MDX implementing a business requirement
• Experienced working on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing, and deployed them to the SSAS database.
• Designed aggregations and pre-calculations in SSAS.
• Experience in HIPPA guidelines, Claims, Member, Provider, HEDIS, Pharmacy, Care Management, etc.
• Involved in designing Partitions in Cubes to improve performance using SSAS.
• Experienced in Developing PowerBIReports and Dashboards from multiple data sources using Data Blending.
• Used recently introduced PowerBIto create self-serviceBIcapabilities and use tabular models.
• Responsible for creating and changing the visualizations in PowerBIreports and Dashboards on client requests.
• Created Calculated Columns and Measures in PowerBIand Excel depending on the requirement using DAX queries.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Created hierarchies in PowerBIreports using visualizations like Bar charts, Line charts, etc.
• Worked with both live and imported data into PowerBIfor creating reports.

Environment: MSSQLServer 2014/2016, PowerBI, SSIS, SSRS, SSAS,SQLProfiler, T-SQL, C#, web DEV (VB.NET), Python, Visual Studio, Azure Data Factory, and Azure Data Lake.

Sr Data Warehouse Analyst/SQL

Confidential | CA

Responsibilities:

• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Interacted with other Business Analysts for designing and implementing Use Cases and Test Plans.
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Created SQL stored procedures to load and manipulate data into production table structures
• Developed strong business and technical understanding of services and database design
• Collaborated with internal and external clients to understand business requirements and ensure the required business functionality of each data element is met.
• Performed T-SQL data profiling, analysis, and mapping to ensure data quality and reliability
• Interpreted and analyzed multi-dimensional medical, provider, pharmacy claims data as well as enrollment data to accurately assess and demonstrate key insights.
• Created ADF pipelines using LinkedIn Servers/Datasets/pipeline/to Extract, Transform and load data from different sources like Azure SQL, Blob Storage, Azure SQL Data Warehouse, and SFTP server.
• Ingested data from disparate source systems extensively by using Azure Data Factory.
• Advanced knowledge with Excel Power Pivot Tables and VLOOKUP. Experienced in working with Azure SQL database Import and Export Service.
• Developed automatic generated reports using Python and SQL
• Created Various reports using Tableau reports based on the Client’s needs.
• Adept in Moving Data in and out of windows Azure SQL Databases and Blob Storage.
• Worked on new implementations, changes to existing layouts/data load code, automation development, performance optimization, and database maintenance like indexing and fragmentation.
• Created SSIS packages to extract, transfer and load data into the data warehouse daily.
• Developed and implemented error handling logic in all the SSIS packages to handle bad data and avoid package failures.

Environment: MS SQL Server 2014/2012, Power BI, SSIS, SSRS, SSAS, SQL Profiler, T-SQL, C#, web DEV (VB.NET), Linux, Visual Studio, Azure Data Factory, and Azure Data Lake.

SQL/BIDeveloper

Confidential | Boston, MA

Responsibilities:

• Involved in creating technical specification documents after gathering requirements from business users.
• Created stored procedures, views, triggers, and user-defined functions to incorporate the flow of business and automated stored procedures.
• Managed index, statistics, and optimizing queries by using an execution plan for tuning the database.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created SSIS packages to extract, transfer and load data into the data warehouse daily.
• Worked with various SSIS Tasks like ExecuteSQLTask, bulk insert task, data flow task, FTP task, send mail task, for each loop container.
• Created and scheduledSQLjobs to run SSIS packages daily usingSQLServer Agent.
• Writing VB.NET and C# coding in Script task and script component.
• Implemented the Extraction Transformation and Loading (ETL) process by pulling a large volume of data from various data sources using SSIS.
• OLAP design SSAS 2008R2 for different cloud services and service items. Implemented OLAP cube and connecting using Excel PowerPivot.
• Managing and automating Control flow, Data flow, Events, and Logging for SSIS packages.
• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports usingSQLServer Reporting Services (SSRS).
• Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions, and Filters inSQLServer Reporting Services (SSRS). Promoted RDLs to Reporting Service Server.
• Defined relationships between Dimensions and Measure Groups.
• Reviewed cube changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
• Involved in designing and developing Data Warehouses, Data marts, and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes.
• Defined Granularity within a measure group and drill-through actions.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.

Environment: SQLServer 2012, Business Intelligence Development Studio, SSRS 2012, SSIS 20012, MS Visual Studio 2008, T-SQL, C#, VB Script, Window 7, Team Foundation Server.