SUMMARY:

• Over five years of Strong experience in the IT industries as SQL Developer and Business Intelligence Developer.
• Strong knowledge of managed claims management process, Knowledge of Medicaid and Medicare Services, Health Assessment Systems, HIPAA, PPACA(Patient Protection and Affordable Care Act), Compliance issues,, ICD 9,10, Electronic Health Records, Electronic Medical Records.
• Provided exploratory data analysis solutions using Microsoft BI suite and Power BI.
• Experience in data warehouse development with Integration Services (SSIS) , Analysis services (SSAS) and Report development (SSRS).
• Experienced in creating and using CTE, Cursors, Functions, Triggers and complex Stored Procedures .
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Provided Business Intelligence solutions to customers and management, providing guidance on the use of the solution developed, and on the information presented.
• Created SSAS Cubes (Tabular Models) as the source for Power BI and created various dashboards and visualizations and published it to POWER BI REPORT SERVER .
• Worked on providing row level securities using power bi and dynamic row level security with SSAS Tabular model to restrict data access for various users.
• Created complex measures, calculated columns, calculated tables using Data Analysis Expressions (DAX)
• Experience in Tabular Modeling, DAX and Worked on Data modeling , creating star schemas in SSAS .
• Excellent knowledge of Software Development Life Cycle (SDLC), Data Warehouse Life Cycle (DWLC), Agile.
• Performed ETL implementation using SQL Server Integration Services (SSIS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Extensive experience performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Experience in developing Custom Report and different types reports like Tabular Reports, Matrix Reports, Ad hoc reports, Drill Down, Drill Through and distributed reports using SQL Server Reporting Services (SSRS).
• Experience in Ralph Kimball’s strategies in approach to design large data warehouses
• Experience in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS) and Worked on Data modeling, creating star schemas in SSAS.
• Exposure in using Team Foundation Server (TFS) as a source control, source repository and project tracking solution.
• Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills, good team player and ability to acquaint to fast changing skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2017/2, MS Access 2013/2010

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI (Desktop, Services, Report Server), Tableau

Database Tools: SQL Server Management Studio, Visual Studio 2017/20155/2012

Languages: Transact SQL (T-SQL), R, C#, ASP.Net, VB Script.

Source Control: TFS 2015/2013/2012/2010

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Business Intelligence (BI) Developer/Power BI Developer

Responsibilities:

• Involved in creating database objects - Tables, Indexes, Views, User defined functions and Stored Procedures .
• Created and developed the Stored Procedures, Triggers to handle complex business rules. Wrote complex SQL statements using Joins, Subqueries, Correlated Subqueries and CTE.
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Created SSAS Cubes (Tabular Models) as the source for Power BI and created various dashboards and visualizations and published it to POWER BI REPORT SERVER.
• Developed dynamic row level security with SSAS Tabular model to restrict data access for various users.
• Automated SSAS models to refresh data and send link through email with the Power BI Dashboard link to the users.
• Created complex measures, calculated columns, calculated tables using Data Analysis Expressions (DAX)
• Provided exploratory data analysis solutions using Microsoft BI suite and Power BI.
• Created Power BI apps and content packs.
• Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.
• Designed SSIS packages which utilized various tasks and transformations.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support.
• Involved in development of Incremental Load process using SSIS Packages and various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Created the automated SSIS Packages to run sequentially using SQL Server Agent job.
• Created SSIS Script task to check for the file and run the package if the file exits. The process is automated and sends email notification upon completion.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Key Performance Indicators (KPIs) for generating reports.
• Created reports using SSRS (Reporting services) on request of end users to download the data to excel.

Environment: SQL Server 2017/2016/2014 , SSIS, SSRS SSAS, Visual Studio 2015, C#, R, RStudio, Power BI (Desktop, Services, Report Server), Team foundation server 2015

Confidential, Jacksonville, FL

SQL BI/Power BI Developer

Responsibilities:

• Involved in creating database objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Parameterized Stored Procedures and Constraints.
• Created and developed the Stored Procedures, Triggers to handle complex business rules. Wrote complex SQL statements using Joins, Subqueries, Correlated Subqueries and CTE.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Designed SSIS packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, XML Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in Incremental data loading.
• Developed SSIS 2012 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2014/2012 for further Data Analysis and Reporting by using multiple transformations.
• Involved in development of Incremental Load process using SSIS Packages and various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Utilized Power BI - Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports and created reports and dashboards using Power BI.
• Migrate existing data into the Power BI and create reports in Power BI preview portal utilizing the SSAS Tabular
• Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.
• Involved on call production support 24/7 for Production Jobs.
• Involved as a Lead for UAT team for bug fixes and production issues.
• Involved in transforming data from dev into Stage & Prod environments using BCP Process.
• Participated in Sprint meting and updating status on reports in Agile Environment.

Environment: SQL Server 2014/2012, SSIS, SSAS, Visual Studio 2012, ASP.NET, Power BI, Team foundation server 2013

Confidential

SSIS, SSRS Developer

Responsibilities:

• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Designed and developed various SSIS packages for ETL and conversion task, Made customized reports from complex T-SQL queries, etc. Enhanced database structures as per the business requirement which is applicable for Contract Accounting Maintenance in an efficient way.
• Wrote optimized SQL queries to access source data from RDBMS and provided reports according to the requirements.

Environment: SQL Server 2008 R2, SSIS, Web Services, SSRS, SSAS, TFS 2010.