PROFESSIONAL SUMMARY:

• Around 8 years of IT experience in MSSQL Server Development experience, System Analysis, Development, implementation, and support of MS SQL Server 2005/2008//2008 R 2/2012/2014.
• Design, develop, and deliver business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (MDS), and Reporting Services (SSRS)
• Strong in all phases of Software Development Life Cycle in different environments like Healthcare and Information Technology.
• Extensive Experience in Data Modeling, ETL (Extract, Transform and Load), Database Design, Development, and Reporting
• Application knowledge in software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.
• Write complex T - SQL (DDL, DML), new features like CTE, Ranking Functions, TOP (n), PIVOT, XML PATH, SQL, Physical, logical database design and Performance tuning.
• Develop and deploy SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Expertise in Power BI, Power BI Mobile.
• Strong in developing Power BI Dashboards in to rich look.
• Worked on Power BI which acts like a cloud service that works with Excel to provide a Self Service BI.
• Develop Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Knowledge in all types of Database migrations with all the versions of SQL Server
• Strong in Source Data Analysis, designing mappings for data extraction.
• Creating and analyzing existing high level ETL design documents and data mapping documents.
• Well versed with Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Good in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Strong in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them)
• Worked closely with management, applications development Team, and users on database solutions to resolve business problems.
• Experience on working with production Servers and 24 x 7 On-Call environments.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2012/2014/2016 , ORACLE, MS Access.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyser Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Reporting Tools: SSRS 2012/2008/2005 , Excel, and Power BI.

RDBMS: SQL Server 2005/2008 R2/2012/2014 Oracle 11g/10/9i.

Tool: SQL, PL/SQL, MDX, C# .NET, JAVA, XML.

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, SSMS

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Operating Systems: Windows 10/7/Vista/XP/2008/2003, Windows 9x, UNIX.

Web Technologies: HTML, XML, JSON, JavaScript, PHP, jQuery.

Tools: /Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. MSBI/Power BI developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Designed, Managed and published various reports using SQL Server Reporting Services 2012 and Power BI.
• Designed Dimensional Modeling using SSAS cubes for End-User.
• Developed reports and visualizations using Tableau Desktop as per the requirements.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Created Crystal Reports Repository objects (Reports template, commands)
• Participated in the data analysis and database modeling of both OLTP and OLAP environment.
• Extracted data using SSIS from OLTP to OLAP.
• Developed custom reports using SSRS/Power BI.
• Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.
• Thorough analysis and testing of database objects &T-SQL statements before deployment to the production server.
• 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.
• 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.
• Administered and maintained the BI Portal, Data warehouse and existing BI solutions.
• Responsible for creating the Complex Crystal Reports (on demand, AdHoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Crosstab, Dynamic Grouping, Csross-Tab, Graphical, Aging reports) and modifying the existing reports.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Developed Tableau data visualizations using Cross Map, Scatter Plots, Geographic Map, Pie Charts, and Bar Charts.
• Worked on forward and reverse engineering data architecture using data modelling tools like ER/Studio
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Strong Knowledge of Software Development lifecycle and methodologies like Waterfall, agile methodology and Scrum approach.
• Used TFS for proper documenting and implementing of codes on all environments.
• Created highly complex SSIS packages using various Data transformations like Conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2014 and unit test SSIS load processes for performance check.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Created multiple data visualization solution for initial Power BI environment business preview.
• Migrated and Converted Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Written & integrated stored procedures to generate the special reports according to client's need.

Environment: SQL Server 2016/2014/2012 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access & Windows Server 2008R2, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, ER/Studio, Tableau 9.1(tableau desktop, tableau server, tableau online).

Confidential, Newark, NJ

Sr. MSBI/Power BI developer

Responsibilities:

• Designed and Created SSIS packages.
• Designed SSRS and excel reports, expense analysis, and balance sheet analysis.
• Designed, reviewed, and created primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Created Power BI driven dashboards and reports
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Creating pipelines using Azure Data factory and Azure apps services to pull data from Webservices and API's in Azure SQL.
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command etc.
• Use login feature for analysis purpose
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Prepared complex reports using SSRS and deployed into MS CRM.
• Processed the data mapping for all the migrated jobs using SSIS and Power-BI
• Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance to tune them
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports
• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power-BI Service Desktop tool.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power-BI and SSRS reports.
• Created script to migrate SQL server object from one environment to another environment
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Uploaded and organized reports in report manager folders. Also, providing security and roles for those reports.

Environment: MS SQL 2008 R2/2012/2016, SSIS, SSRS XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, Ms CRM,VBA (Visual Basic for Applications), Share point, DTS, Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server,FTP & SFTP server, Power-BITool.

Confidential, Melbourne, FL

MSBI Developer

Responsibilities:

• Participated in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Analyzed business requirements and implemented data mart solutions for data mining and reporting.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Took part in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Created a report model on SSAS cubes.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installed, Configured and Deployed Reports using SSRS with Scale-Out topology.
• Worked closely with QA team and helped them come up with test scenarios.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS,, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server, Power-BI Tool.

Confidential

SQL Developer

Responsibilities:

• Met business stakeholders and other technical team members to Gather and analyze application requirements.
• Performed source/target analysis of data structures & content.
• Designed, developed, and implemented entry level workflow solutions with heterogeneous sources and multiple operating system environments.
• Extensively used various SSIS Objects such as Dataflow and Control Flow Elements, Connection Managers (Connections), Event Handlers and Progress Tab etc.
• Validated and modified data using SSIS with different Data Flow Transformations like Send Email Task, File System Task, Conditional Split, Lookup, Merge Join, Aggregate, Multi-Cast, Derived Column and Data Conversion etc.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSIS.
• Worked with team members to tune the SQL queries. Created necessary Index/Partition on huge fact tables for getting a better performance in ETL.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in Data Warehouse.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Used data compression techniques for Back Up.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS from Heterogeneous databases such as Oracle, DB2 and MS Access and designed data conversions from wide variety of source systems.
• Providing Production support to operational team for daily/weekly/Monthly job failure in Production environments.
• Created deployment documentation with the help of other users and operational team to deploy the new release in Production environment.
• Actively participated in the daily standup, planning, Review meetings.

Environment: MS SQL Server, MS Business Intelligence (SSIS, SSRS), Oracle, DB2, T-SQL and TFS.