SUMMARY

• An IT professional with 8+ years of experience as SQL and Business Intelligence Developer using MS - SQL, Microsoft BI Developer (SSIS, SSAS, SSRS) and Power BI in various domains.
• Working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Experienced as a MS SQL Server BI Developer 2019/ 2016/2014/2012 /2008 R2/2008/in various Industry verticals like State, Finance, Health and Insurance.
• Experience on Microsoft Power BI (Desktop, Service, Mobile).
• Experience in publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Experience in maintaining database, including updating statistics, re-indexing, schema modifications, index analysis and Log Shipping, Mirroring & Replication to restore, Database backup.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Experience in generating reports using SQL Server Reporting Services, Power BI, and MS Excel spreadsheets.
• Experience in create & validate end-to-end data integration flow & data quality routines.
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor
• Used Visual Source Safe (VSS)for version control and configuration management.
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Experience in Performance tuning and SQL Profiler of SQL Server.
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), and MicroStrategy.
• Hands on experience in execution of Parent and Child package execution.
• Experience in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts.
• Strong knowledge working with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Proficient knowledge of Data Warehousing methodologies and concepts, including Star schemas, Snowflakes schemas, ETL processes, dimensional modeling, and reporting tools.
• Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Strong understanding Microsoft technology stack (Azure SQL Server Integration Services, Analysis Services, Tabular Reporting Services etc.)
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
• Experience in developing new and maintain existing Cognos BI reporting solutions.
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.

TECHNICAL SKILLS

Database Technologies: SQL Server 2008R 2/2012/2014/2016/2019 , Oracle, MS Access, Teradata, HDFS

Database tools: MySQL, SSMS, SQL Server BIDS, Enterprise Manager, SQL ProfilerQuery Analyzer, Import Export DTS.

Programming/Query Languages: Python, C#,net, ADO.net, VB.net, Javascript,CSS,HTML SQL, T-SQL, MySQL, PL/SQL, MDX, DAX, Unix, Hive

IDEs /Tools: MS Visual Studio, SSMS

Other Tools: MS Office Suite (Word, PowerPoint, Visio, Excel),OLAP, OLTP, TFS, COSMOS,JIRA. MS Visio. MS SharePoint

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Power Query, Informatica Power center

Data Visualization tools: Power BI, Tableau

Cloud Technologies: AWS, MS Azure, Azure data lake, Azure data factory

Reporting tools: SSRS, Performance Point Server, Report Builder, Focus, Power Pivot, Power BI.

PROFESSIONAL EXPERIENCE

Confidential, Frederick, MD

ETL/Power BI Developer

Responsibilities:

• Design, develop, and monitor (ETL) processes. Creating stored procedures and functions to perform business operations on the back end using MS SQL Server database.
• Touch base with Business System Analyst to understand the requirements of tasks assigned, involving in Data analysis and profiling and participate in design discussions.
• Performed subscriptions and refresh extracts in Power BI as well as set up data alerts on business-critical data utilizing Power BI services.
• Creating SSIS packages to extract data from OLTP sources like MS SQL Server Flat Files, Excel and Access to OLAP systems (SQL Server), transforming them according to the business requirements and load into the respective databases.
• Creating new Pipelines in Azure Data Factory by using proper activities which are in the tiles with error handling.
• Designed, Managed, and published various reports using SQL Server Reporting Services and Power BI.
• Migrated and translate legacy reports into Power BI from SSRS environment.
• Developed and implemented SSIS and SSRS application solutions for various business units across the organization.
• Developed Ab Initio Graphs based on business requirements.
• Involved in unit testing of the Ab- Initio Psets/graphs.
• Used DAX query in writing queries and defining measures and calculated columns in PowerPivot and in tabular models in SSAS.
• Developed number of business-oriented reports utilizing SSRS, Power BI and Tableau.
• Creating functional and technical specifications, unit and integration testing, preparing user manuals and training key users. Involving in optimizing queries with Stored Procedures and parameter sniffing to get rid of the performance issues.
• Created SSIS packages to clean and load data to Enterprise Data Warehouse.
• Performing DDL, DML activities in database to handle the data using Stored Procedures, functions, Triggers and T-SQL queries. Experienced in Error Handling and Troubleshooting the scripts in failure to load the data into database.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases. Enhancing and deploying the SSIS Packages from development server to production server.
• Scheduling jobs for executing the put away SSIS bundles which were created to automate process like refresh the database on Daily premise, load the incoming data from different sources at a particular frequency.
• Involved in Unit Testing, Validating Reports and Production Support to determine progressing Production Problems by checking on configuration changes made to create frameworks. Involved in Performance tuning of the SQL Server Queries utilized as a part of SSIS packages.
• Creating Tech design and Release documents for QA and Production environment for all the developments done.
• Worked on creating dependencies of activities in Azure Data factory to load the data into target systems. Creating Stored Procedure and Scheduled them in Azure Environment, Monitoring Produced and Consumed Data Sets of ADF. Creating Data Factories in Azure Data factory
• Performing some Quality Assurance (QA) testing for the code developed by other developers in the team if required.
• Collecting and understanding the requirements from the developer and then creating high level test plans for testing in QA environment. Reporting bug fixes to the developer after testing has been carried out.

Environment: MS SQL Server 2014/2016, MS Azure, Azure Analysis Services(AAS),SSIS, SSAS, T-SQL, PL-SQL, SQL Profiler, HTML, XML, MS Excel, MS Office 2013/2016.

Confidential

MSBI/Power BI Developer

Responsibilities:

• This project was primarily a development of Data mart for budget and health services department along with analysis of existing data warehouse for performance improvements.
• Created Jobs in SSIS to run the process in cube and to get data from the data source.
• Created various packages to generated pipe delimited flat files with dynamic datetime appended to it and sending the files over secure FTP to client destination.
• Done unit testing by writing MDX queries and re-checking the data is getting matched or not.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Also scheduled Automatic refresh and scheduling refresh in Power BI service.
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.
• Develop complex MDX, stored procedures, function table and views to generate various drill through, drill-down reports, with dynamic grouping capability, parameterized dynamic
• Dashboard/Scorecard and link and pass the selected parameter values it to its sub reports using SSRS.
• Implemented complex business logic with case, cast, convert, CTE using T-SQL.
• Create and update SSIS Packages to pull data from source to destination database.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.
• Created types of SSRS report (Parameterized, Linked, Drilldown, Drill through, Customized, dashboards, graphics) in SharePoint environment.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Environment: SQL Server 2016/2014/2012 , SSRS, SSIS, Visual Studio, Power BI Desktop, Power BI server, Power Query, MDX, DAX, power pivot, C#, MS SharePoint

Confidential, NY

SQL BI/SSRS,SSAS

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.
• Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.
• Created SSIS Packages to migrate slowly changing dimensions
• 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 daily from OLTP database to OLAP or staging database using the SSIS packages.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• 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
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Scheduling the SSIS packages and Jobs.
• 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 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.
• Building KPI reports for the cubes and optimizing the reports.
• Involved in partitioning of cubes to increase the performance of cubes (SSAS).
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve a greater number of groupings and multi-value parameters
• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: SQL Server 2012/2014, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008, Oracle 9i, Ms excel 2003, Microsoft Visual Studio.

Confidential, MO

SQL Developer

Responsibilities:

• Developing SQL code such as writing complex queries, stored procedures etc.
• Design and develop Business Intelligence solutions using MSBI tools (SSIS, SSRS, SSAS).
• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers.
• Write and debug T-SQL Queries, SSRS Reports, SSIS Packages and Stored Procedures.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle database, DB2 and Teradata database, Excel, Flat files into the SQL Server target staging database.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL.
• Created and developed Stored Procedures and Triggers to handle complex business rules, history data and audit analysis.
• Involved in Testing and Debugging Stored Procedures and functions, database tuning.

Environment: SQL Server 2012,2008R2, SSRS, SSIS, Visual Studio 2010, C#.Net, Tabular Model, DAX, SSAS, Power Pivot