SUMMARY:

• Highly professional and well - versed MS SQL BI Developer with over all 6 years ’ experience in designing and developing with strong background in Data warehousing and ETL experience .
• Experience in designing, developing and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management domains with expertise in MS SQL Server 2005 / 2008R 2 / 2012/2014/2016 and over 6+ years of experience in Microsoft Business intelligence stack products like SSIS and SSRS and 2+ years of experience in Power BI Service and Tableau Server .
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and SQL joins.
• Strong experience on developing ER diagrams like logical and physical data models using Erwin tool, Visio and Power Builder .
• Strong Knowledge on Normalization /De-normalization database design methodology.
• Highly experienced in whole cycle of DTS/SQL server integration services Packages (SSIS) for performing Data transfers and ETL processes across different servers.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mail and schedule SSIS Packages based on Business or Application needs.
• Integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages .
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets .
• Used 2012, 2014, 2016 version of SSAS to develop tabular models and experience in performing tuning of tabular cubes.
• Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS) to generate drill down, drill through, parameterized, linked, matrix and charts reports in SSRS 2005/2008/2012/2014.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema and Operational Data Store (ODS).
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Experience in configuring security, organizational content packs, data Gateways, refresh schedules for PowerBI service .
• Expertise in developing, enhancing and tuning of Oracle database objects and advanced PL/ SQL programs.
• Experience in working in agile scrum development methodology.
• Excellent interpersonal abilities, communication skills, time management and team skills with an intention to work hard to attain project deadlines under stressful environments.
• Flexible and versatile to adapt to new- environment and technologies.

TECHNICAL SKILLS:

RDBM/Databases: MSSQL Server 2016/2014/2012 /2008 R2, Oracle 8i & 9i, MS Access, Microsoft Azure

Programming Languages: T-SQL, PL/SQL, C, MDX, HTML, Java, Python, C

Data Modeling: FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI (Power Pivot, Power View), Power Query, Power Map), SQL Server Analytical Services (SSAS), Visual Studio, Tableau, Power BI.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS),TortoiseSVN, Redgate, GIT

Application Packages: MS Office, Microsoft SharePoint Server (MOSS)

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

SQL/MSBI Developer

Responsibilities:

• Excellent knowledge & experience in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined data types, effective functions, cursors and indexes using T-SQL.
• Demonstrable knowledgeable experience with Informatica, Oracle SQL, PL/SQL development.
• Experience working in deployment of cubes, OLAP & XMLA .
• Developed tools using python, shell scripting, XML to automate tasks.
• Well experienced in data modeling & data migration from Oracle to SQL.
• Experience working in Power BI.
• Have experience in support and maintenance of BizTalk & AX Microsoft Dynamics with implementation and involved in working with self-direct assignments using tableau .
• Involved in projects with Power BI environment and tableau.
• Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions).
• Worked on SSIS Packages Documentation, source, archive, Stage path mapping.
• Develop Exception handling process and audit process for each ETL package.
• Developing SQL code such as writing complex queries, stored procedures, user defined function etc.
• Monitor and SQL profiler and tuned queries and procedures to boost database performance.
• Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, SCD to load data into Database.
• Involved in creating proxy accounts and Scheduling Jobs to execute SSIS packages.
• Created and managed Interactivity Financials SSRS reports (Parameterized, Linked, Drilldown, Drill through reports)

Environment:: Informatica, PL/SQL, SQL Server 2016/2014/2012, SSAS, SSIS, SSRS, Windows Server 2008 R2, Visual Studio 2010, C#.Net, Oracle 9i, 11g, Teradata, TFS, Crystal Reports, AngularJS, Micro strategy, MS Dynamics AX, UNIX, LINUX, Azure, Mango DB.

Confidential, Charlotte, NC

BI Developer (MSBI)/Power BI

Responsibilities:

• Designed and monitored the construction of the SQL Server Business Intelligence enterprise data warehouse .
• Generated Tabular Model in SSAS, created DAX, MDX queries to retrieve and manipulate data off them.
• Designed complex SSAS Multidimensional cubes using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS 2012/2014 and in adding calculations using MDX.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Processed OLAP cubes with various processing options depending on the requirement.
• Designed and monitored construction of the ETL processes and provided the ETL mappings in the design document.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Formatted dashboards, multiple chart types, trends and KPIs with Power View to support analyses.
• Developed automation scripts which used REST APIs to extract data from blob storage of Azure Cloud Services.
• Created and Maintained SQL Server Agent Jobs for SSIS Packages.
• Customized sites on SharePoint Portal and hosted the SSRS and Power Pivot reports on to SharePoint.
• Created Power view reports using the Tabular SSAS models in Excel.
• Scheduled Reports using subscriptions in SharePoint.
• Provided 24/7 production support for Business users.

Environment: Microsoft BI (SSAS, SSRS, SSIS -2012/14), MDX/DAX, Power BI, SharePoint 2007/2010, SQL Server 2012/2014, Business Intelligence Consumer Services.

Confidential, New York City, NY

SQL/BI Developer

Responsibilities:

• Worked closely with business and involved in gathering the user requirements.
• Responsible for writing and modifying stored procedures, functions, packages for data conversions to create database objects dynamically.
• Created indexes, tables and sequences as per the business requirement and views to maintain data privacy.
• Used SQL profiler to identify slow running queries.
• Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud.
• Designed SSIS packages in order to validate, extract, transform and load data into staging and Data Warehouse.
• Analyzed the requirements and framed the business logic for the ETL process.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed data migration from Excel, Sybase, Oracle to MS SQL Server using SSIS.
• Created package to transfer data between OLTP and OLAP databases.
• Designed Cubes with star schema using SSAS. Created hierarchies and partitions for improving SSAS cube performance.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS)
• Deployed and uploaded the SSRS reports to Report Manager and called reports through a URL from .Net API for the end users and involved in enhancements and modifications.
• Involved in migrating SQL Server databases to SQL Azure database using SQL Azure Migration Wizard
• Created various kinds of reports using power BI based on the client’s needs.
• Used Collections, Bulk Collections for handling large amount of data in PL/SQL.
• Involved in creating visualizations and multiple dashboards in Power BI.
• Calculated columns, conditional column, custom columns, created measures in PowerBI.
• Responsible for creating SQL datasets for power BI and Ad-hoc reports.
• Created Action filters, Parameters and calculated fields for preparing dashboards and worksheets in power BI.
• Responsible for scheduled job maintenance and trouble shooting.
• Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve the customer details, payment history by giving related parameters
• Used Agile Development Methodology.
• Point of contact for all the production issues.

Environment: T-SQL, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Share Point Server, Azure, .Net, Power BI

Confidential

MSBI Developer

Responsibilities:

• Involved in creating extensive dynamic SQL to accommodate business requirements.
• Involved in documenting management procedures, plans and processes.
• Created complex store procedures, triggers, tables, views and other SQL joins and statements for applications using T-SQL
• Involved in performance tuning using indexing (Clustered, Non Clustered) tables.
• Worked on Query Optimization, execution plans, trace flags and SQL Profiler.
• Used System tables, System stored procedure, DBCC commands for database maintenance.
• Used BCP Utility in stored procedures to generate output files in text format.
• Used scripts and variables, email notifications for ETL process using Data integrator.
• Performed ETL operations to support data loads and transformations using SSIS.
• Extensively used SSIS in creating complex packages using proper control flow and data flow elements with error handling.
• Wrote stored procedures and user defined scalar functions to be used in SSIS packages in SQL scripts
• Optimized ETL packages by increasing memory buffer size and by increasing Max Concurrent Executable
• Enhancing and deploying SSIS packages from development server to production server.
• Normalized and De normalized entities for data warehouse.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
• Developed custom calculated measures in power BI to satisfy Business needs
• Migrated existing self-service reports and adhoc reports to power BI.
• Used bar charts, bubble charts and Power map to solve business requirements with Power BI.
• Created tabular, matrix, chart, drilldown, parameterized, cascaded reports and dashboards and scorecard reports.

Environment: T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Share Point Server, SQL Profiler, MDX.

Confidential

MSBI/SQL Developer

Responsibilities:

• Extensively involved in gathering business requirements that will facilitate the planning and the implementation phase of OLTP database.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Managed SQL Servers in 32/64bit Clustered environments. Implemented Database Mirroring on SQL Server 2008 environments.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Wed Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS ).
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Performed optimization of TSQL stored procedures by analyzing execution plans, creating proper indexes and employing SQL profiler and Database engine tuning advisor in OLTP environment.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Filtered bad data from legacy system using T-SQL and implemented constraints and triggers into new system for data consistency.
• Designed and developed the ETL data flow to populate the CER Cube Analysis Database using the SSIS packages (SQL Server Integration Services). Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting.
• Identified the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the SSIS packages. Identify and document the source to target packages.
• Created SQL server configurations for SSIS packages and XML & Windows event logs .
• Design and document the error-handling strategy in the ETL load process using Event handlers .
• Used Notification services to generate error messages and send them to the user through e-mails.

Environment: SQL Server 2014/2012/2008 R2, T- SQL, Microsoft Access, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio, Star Team Version Control tool, TFS, Tableau 8.1., MS Azure, C#, .Net, Erwin 8.0/MS Visio 2010.

Confidential

SQL Developer

Responsibilities:

• Created business requirements, designed F unctional Specifications and Flowcharts .
• Modified existing database to fit new business requirement by adding tables and relationships to support customer information system.
• Written SQL queries for back- end data validation database testing and reports verification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Working experience writing SQL Scripts using Joins, stored procedures, Views, Indexes, functions, triggers.
• Provided back end support for functional testing and performance testing.
• Worked on reconciliations of balances from different systems.
• Analyzed requirements with developers, business analysts and provided my inputs.
• Wrote and executed the test cases to perform System, Functional and Regression testing.
• Worked on Team Foundation Server (TFS) for code review to check in and check out the codes.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: SQL Server 2008, 2005, SQL Server Management Studio, SSIS, Visual Studio, MS-Office, MS Excel, MS Access.