PROFESSIONAL SUMMARY:

• Over 7+ years of experience in database development, modeling, testing, deployment and business intelligence using SQL Server 2016,2014,2012, 2008, MS SQL Server Integration Services (SSIS) , MS SQL Server Reporting Services (SSRS) , and MS SQL Server Analysis Services (SSAS), MSBI and Power BI, Informatica power center in finance, healthcare, investment banking, retail and insurance industries.
• Worked with various teams and user groups in designing and developing the reporting warehouse.
• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings.
• Interacted with various upstream and downstream customers in interfacing various systems for data extractions , ETL , analytics and reporting needs .
• Expert in designing reports using SQL Server Reporting Services ( SSRS ) based on OLAP cubes .
• Experience in developing custom reports and different types of tabular, matrix and distributed reports into multiple formats with SQL Server Reporting Services (SSRS), and in writing shell scripts on Unix platform.
• Have strong knowledge of working with Hadoop technology stack like HDFS , Impala , MapReduce, Spark, Hive etc.
• Expert in enhancing the reports visually by adding the visual elements including charts, graphs, gauges and maps to SSRS reports .
• Experience in creating SSIS packages based on multiple data source including SQL Server, flat file, excel and oracle .
• Strong experience with Data Analysis, Data Profiling, Root Cause Analysis
• Worked on POC to migrate existing on premise BI platform to Azure Cloud .
• Worked on Azure cloud in spinning of new resources under resource group.
• Worked on Data factory in order to load the data from on premise to Azure Data lake .
• Configured Integration Runtime (IR) in order to move the data from On premise to cloud.
• Worked on power shell scripts to automate the creation of resources and resource group.
• Experience working with Azure Data warehouse , created TSQL code to use polybase external tables in order to load data from ADL to ADW .
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of data migration and data maintenance .
• Designed SSIS package to extract appropriate records and output them to data marts and warehouse .
• Experience in developing scripts in SSIS to synchronize stored procedures, email output and log messages .
• Designing and maintaining data management and data processing solutions using SSIS, includes error handling and Slowly Changing Dimensions (SCD) .
• Experience in creating jobs, SQL mail agent, alerts and schedule SSIS packages in SQL Server.
• Expertise in developing and extending SSAS cubes, data mining models, deploying and processing SSAS objects, and writing MDX queries .
• Experience in normalize and de - normalize data in the process of building database and reporting.
• Familiar with process of testing, troubleshooting and debugging on each unit of work, including jobs, SSIS package, SSRS reports and SSAS cubes.
• Expert in migration of databases from older versions of SQL Server 2008 to SQL Server 2012 .
• Extensive database programming Experience in developing complex T-SQL queries including stored procedures , User Defined Functions (UDF), triggers, views, temporary tables constraints and indexes using various DDL and DML commands.
• Excellent Experience in monitoring SQL Server performance tuning in SQL Server2008/2012 using SQL profiler, query analyzer, enterprise manager, index tuning wizard, and windows performance monitor .
• Having full understanding of Software Development Life Cycle (SDLC) with substantial experience on object oriented analysis and design methodologies, and also extensive knowledge on other Methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player
• Expert in creating multiple type of reports using tools like Power BI and SSRS .
• Building and publishing Power BI reports utilizing complex calculated fields, table calculated knowledge of dimension hierarchies , drilldown , sub reports , and Key Performance Indicator (KPI)
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX querries using DMV’s and creating the necessary environment for Deployement.
• Experience in handling Heterogenous Data Sources and database Oracle, Teradata, and CSV and XML files using SSIS.
• Expert in creating and developing Power BI and Tableau dashboards into rich look.

TECHNICAL SKILLS:

Programming Languages: C, C#, ASP.net, VB.net, Java, Python, SQL & PLSQL

Web Technologies: HTML, XML, JavaScript, AJAX, SOAP And Active X.

Database Environments: Oracle 11g/12c, MS SQL Server 2008/2012/2016 , MySQL, DB2 and MS Access

ETL Tools: SQL Server Integration Services (SSIS), and Informatica.

Reporting Tools: SSRS, Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, Tableau, Cognos and Power BI

Other Tools: Microsoft Visual Studio, Oracle 11g,, SSAS, SQL Developer, SQL Server Management Studio, Microsoft Azure, Eclipse IDE

MS-Tools: MS-Visio, Outlook, Advance Excel, Word, and PowerPoint

Operating System: Windows NT/XP/Vista/7, Windows 95/98/2000/NT, Windows Server 2003/2008.

Version Control Tools: CVS, TFS, SVN, GIT

PROFISSIONAL EXPERIENCE:

Confidential, New York, NY

MSBI / BI Developer

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created drill down and drill through report to go to details and child report within Power BI based on hierarchy.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Have worked with Hadoop technology stack like HDFS , Impala , MapReduce, Spark, Hive etc.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
• Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like ( Excel, CSV, Oracle, flat file, Text Format Data ) by using multiple transformations provided by SSIS such as Data Conversion , Conditional Split, Bulk Insert , Merge and union all.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Excellent command on subscriptions, report snapshot and report cache.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Performing T-SQL tuning and optimizing queries for reports that take longer execution time.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2, Salesforce and Intacct.
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.
• Worked on POC to migrate existing on-premise BI platform to Azure Cloud .
• Worked on Azure cloud in spinning of new resources under resource group.
• Worked on Data factory in order to load the data from on premise to Azure Data lake .
• Configured Integration Runtime (IR) in order to move the data from On premise to cloud.
• Worked on power shell scripts to automate the creation of resources and resource group.
• Experience working with Azure Data warehouse , created TSQL code to use polybase external tables in order to load data from ADL to ADW .
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2012 that maintained data. Actively supported business users for change requests.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Data blending implemented on databases and generated interactive dashboards in Tableau.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Designed Power BI data visualization utilization cross tabs, maps, scatter plots, pie, bar and density charts.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS)/Visual Studio, T-SQL, MS Excel, Power BI and Tableau, Salesforce, Intacct, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, Azure.

Confidential, Plainsboro, NJ

ETL /SSIS /SSAS /MSBI/ Power BI Developer

Responsibilities:

• Worked as a Consultant in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Created SQL functions for critical Denodo reports and enhancements to the existing reports.
• Worked with various SSIS control flow tasks and data transformation tasks like data conversion, merge, aggregate, derived column, look-up, fuzzy look-up , etc. as part of ETL .
• Experiences in enhancing and deploying the SSAS cubes to production server. Converted Atscale cubes to SSAS cubes .
• Created proper indexing for functions and procedures when changes updated to the existing logic.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Responsibilities involve ETL development, unit tests, business validations, integration tests, defect resolution and production support.
• Have worked with Hadoop technology stack like HDFS , Impala , MapReduce, Spark, Hive etc.
• Used index tuning wizard, SQL profiler and SQL query analyzer for performance tuning.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML .
• Participated in testing and verification of the entire database/ data warehouse system after migration.
• Generated drill down, drill through, ad-hoc, matrix reports, parameterized reports using SSRS .
• Assembled report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI .
• Explore data in a Variety of ways and across multiple visualizations using Power BI .
• Designed Power BI data visualization utilization cross tabs, maps, scatter plots, pie, bar and density charts.
• Setting up Power BI Environment , creating app workspaces, publishing apps and setting up Power BI Gateway.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports .
• Involved in creating tableau dashboards by extracting data from the sources SQL Server .
• Created dashboard using parameters, filters, sets, groups and calculations to manipulate data.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Experienced in enhancing and deploying the SSIS packages from development server to production server.
• Involved in peer review sessions and helped other team members with design and data model issues.
• Provided suggestion on project issues which affected timelines to make sure the deliverables are completed and meet the deadlines.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS)/Visual Studio, T-SQL, MS Excel, Power BI and Tableau, Azure.

Confidential, Austin, Texas

SSIS Developer

Responsibilities:

• Involved with SQL server 2014/2012/2008 configuration, backup, recovery, and monitoring.
• Worked with various SSIS control flow tasks and data transformation tasks like data conversion , merge, aggregate, sort, conditional split, SCD, derived column, look-up, fuzzy look-up , etc. as part of ETL.
• Extracted data from various sources like SQL Server 2008/2014, oracle, MS Access, .CSV , excel and text file from client servers and through FTP .
• Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS .
• Have worked with Hadoop technology stack like HDFS , Impala , MapReduce, Spark, Hive etc.
• Developed calculated columns and measures using DAX in Power BI
• Used the tabular model cubes as the source in Power BI to visualize the data.
• Experienced in enhancing and deploying the SSIS packages from development server to production server.
• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Automated execution process , scheduling, deploying of packages using SQL Server agent by creating jobs and error reports using alerts, SQL mail agent and FTP .
• Responsibilities involve ETL development, unit tests, business validations, integration tests, defect resolution and production support.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Experienced in working with partially / full blocking transformations and expertise in performance tuning of SSIS packages .
• Used index tuning wizard, SQL profiler and SQL query analyzer for performance tuning.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML .
• Performed data validation checks during staging, before loading the data into the data warehouse .
• Participated in testing and verification of the entire database/ data warehouse system after migration .
• Generated drill down, drill through, ad-hoc , matrix reports , parameterized reports using SSRS .
• Created SSRS reports using complex SQL queries/stored procedures which have sub-reports , dropdown menu options and charts.
• Assigned permissions to the valid users for executing the reports and deploying reports to report servers .
• Expertise in writing complex DAX functions in Power BI and Power Pivot .
• Automated power query refresh using power shell script and windows task scheduler .
• Created workspace and content packs for business users to view the developed reports .
• Scheduled automatic refresh and scheduling refresh in Power BI service .
• Wrote calculated columns , measures query's in Power BI desktop to show good data analysis techniques.
• Involved in creating dashboards by extracting data from the sources SQL Server
• Created dashboard using parameters, filters , sets, groups and calculations to manipulate data .
• Combined views and reports into interactive dashboards in Power BI that were presented to business users, program managers, and end users.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS)/Visual Studio, T-SQL, MS Excel and Power BI, DAX.

Confidential, Milwaukee, WI

Senior ETL /MSBI / Power BI Developer

Responsibilities:

• Created and developed Business Intelligence solutions using MSBI tools ( SSRS, SSAS, SSIS )
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2008/2014
• Documented new SSIS packages and trained senior analyst on basic SSIS concepts.
• Scheduled the Packages in SQL Server agent on daily/weekly/monthly basis.
• Designed SSRS reports under SQL Server 2014 database and publishing SSRS reports to the reports Server.
• Developed ad hoc report according to customer's request for internal performance assessment.
• Maintained the regular reports for the day-to-day as well as weekly/monthly purposes in SSRS .
• Generated reports with cascaded parameters from SSAS cubes using MDX queries and calculated members.
• Merged data from heterogeneous data stores ( SQL Server, flat file and Excel ) using SSIS packages.
• Performing ETL with SSIS to extract data from SQL Server 2012 and load into enterprise data warehouse
• Developed and deployed data transfers packages using SSIS, also assigned the jobs running on Servers.
• Used event handlers for logging and error handling error capturing in data flow tasks, and dynamically sending error notification through email tasks at runtime using expressions in SSIS .
• Have worked with Hadoop technology stack like HDFS , Impala , MapReduce, Spark, Hive etc.
• Installed and configured and maintained Power BI Report Server.
• Created reports on Power BI Desktop and published on Power BI Report Server .
• Designed and developed Tabular Model Cubes using SSAS 2012. Developed calculated columns and measures using DAX
• Translated data structures within the enterprise and establish appropriate data model for analysis and reporting utilizing data views, dimensions, cubes, and Multidimensional Expressions (MDX) in accordance with latest standards.
• Involved in creating multidimensional cubes using SSAS and designing DW schemas .
• Assigned permission to users, roles and object, supported column level permission. Administered server's logins (Windows and SQL Accounts).
• Involved in version controlling of packages, database objects in TFS .
• Worked with complex/large database packages, procedures, functions and triggers with MS SQL Server 2012 .
• Built, maintained and modified tables, views, Indexes, stored procedures, packages, triggers and referential integrity depending on user requirements and converting them into technical specifications.

Environment : MS SQL-Server 2012, 2014 SSIS, SSRS, SSAS, SQL, TFS, and Windows Server 2007, MDX, Power BI.

Confidential, Nashville, TN

SQL Business Intelligence Developer

Responsibilities:

• Created new database objects like stored procedures, functions, triggers, indexes and views using T-SQL in development and production environment for SQL Server 2012.
• Maintained MS SQL Server 2012 configuration, tuning and provide 24 X 7 dedicated support to all production, development and clustered servers.
• Involved in framing SQL queries for validating data between data warehouse and source systems.
• Assist developers with difficult oracle PL/SQL code needed for queries, triggers, and stored procedures
• Extensively involved in the analysis and tuning of the application code (SQL and PL/SQL Procedures)
• Develop and maintain procedures to optimize application availability.
• Optimized queries by obtaining explain plan, analyzing tables, providing hints, and adding indexes on tables where required.
• Worked on database compression for different databases to save space across different environments.
• Extensively used joins and common table expressions to simplify complex queries involving multiple tables.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Designed layout of SSRS reports and determine the best way to present data to end users.
• Developed SSRS reports using Microsoft Reporting Services platform (SSRS), Microsoft SQL, SSAS, SSIS, MS Excel, pivot tables and other tools.
• Developed complex stored procedures and views to generate various drill-through reports, parameterized reports and linked reports using SSRS.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Created SSIS packages coming from text files and excel files to validate, extract, transform and load data to data warehouse.
• Migrated old data from MS Access into SQL Server 2012 using SSIS packages in Business Intelligence Development Studio.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Deployed SSIS package into production and used package configuration to export various package properties to make package environment independent.
• Implemented event handlers in SSIS packages and notified process results to various user communities.
• Tested, cleaned and standardized data meeting the business standards using fuzzy /exact lookups using SSIS tasks.
• Developed data management and data processing solutions using SSIS, which including error handling and Slowly Changing Dimensions (SCD).

Environment: T-SQL, PL/SQL, Oracle 11g, MS SQLServer2012 Enterprise Edition, SSIS, SSRS & SSAS, DAX.

Confidential, Atlanta, GA

SQL Business Intelligence Developer

Responsibilities:

• Developed store procedures, triggers, views and user defined functions for better performance in SSIS and SSRS
• Analyzed queries performance with SQL query analyzer, optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Installed and configured SQL Server 2008, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) which were highly efficient to monitor the central console and SQL Server instances and detecting problems before affecting transaction of online users.
• Implemented the online indexing making the transaction in SQL 2008 faster nearly three times as compared to the SQL Server 2012 .
• Merged data from heterogeneous data sources including MS SQL server, flat file and MS Excel to SQL Server 2008 using SSIS packages.
• Participated in to design ETL architecture and processes records from different locations, and successfully met challenges of very high volume of data.
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers in SSIS.
• Imported XML data file as data source and put into the desired database in SSRS and SSIS.
• Generated different type of customized reports including drill-down, drill-through in SSRS.
• Created and executed the stored procedures and complex queries for reports.
• Deployed, scheduled the reports and send the output via email in report manager.
• Responsible for generating different types of daily and weekly Reports based on specifications and user's requirements using SSRS
• Documented all the work and all the process of integration and reporting services for further references.
• Interacted with development teams and managers to analyze business needs and developed technical specifications.
• Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012,2014
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated SSIS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• 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.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MSBI.