SUMMARY

• Over 6 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, Azure SQL Cloud and all MSBI tools including Power BI.
• Self - Motivated and possess the ability for critical thinking, analysis, good interpersonal, time management, multi-tasking, and communication skills. Ability to work effectively as a team member and individually.
• Strong written, verbal communication, and presentation skills.
• Pragmatic thinker, able to balance user requirements while delivering excellent technical solutions.
• Experience indesigning, developing, and deployingBusiness Intelligence solutions using SSIS,SSRS, SSAS, Power BI
• Hands on experience in MS SQL Server 2016, 2014, 2012 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Experience in Handling Heterogeneous data sources, databases Oracle, IBM DB2, Teradata, and XML files using SSIS.
• Experience in data migration between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Strong experience in design, development, and deployment of the SSIS packages and SSRS reports using SQL Server DATA Tools 2012/2014/2016.
• Expert knowledge in SQL Server Package Configuration technique to make Dynamic configurations for SSIS packages and Project deployment model in SQL Server 2012/2014/16.
• In-depth understanding in client requirement Analysis, Logical design, development, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2016, 2014, 2012, DTS, SSIS, SSAS and SSRS.
• Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, cursors, user-defined functions, views, indexes, user profiles, relational database models, and Complex Queries in MS SQL Server.
• Experience inwritingComplexSQLQueriesinvolving multiple tableswith innerandouter joins.
• Experience in tuning the reports that include modifying, testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Experience inOLTP/OLAPenvironment andData Warehouse.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler, and SQL Server Debugger.
• Involved in migration of legacy data by creating various SSIS packages.
• Hands on experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server ( 2016/2014/2012 ).
• Experience working on POC to migrate existing on-premises BI platform to Azure Cloud.
• Experience working on Azure cloud in spinning of new resources under resource group.
• Experience working on Azure Data factory to load the data from on premise to Azure Data Lake.
• Involved in configuring Integration Runtime (IR) to move the data from on premise to cloud.
• Experience Working on PowerShell scripts to automate the creation of resources and resource group.
• Experience working with Azure Data Warehouse, created TSQL code to use Polybase external tables to load data from ADL to ADW.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, and Reports on SSAS Cube using MDX, Drill-down, Drill-through, and Cascading reports using SSRS and Power BI.
• Expert in creating Power pivots, power query, Power views, and SSRS reports using tabular model (DAX), Cubes (MDX), and SQL queries.
• Designed and developedmatrix and tabular reportswithdrill-down, drill-throughusingSSRS.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and Physical Design of the Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects, and Crystal Reports and Excel pivot tables.
• Experienced in using global variables, expressions, and functions for the reports.
• Experienced with development and implementing of new emerging Microsoft-related technologies like PowerApps and Flow.
• Good Working experience in designing STAR, SNOWFLAKE Schemas, database modeling, logical and physical database design using Erwin and Knowledge of how the Kimball approach has been implemented in the Microsoft BI tool.
• Strong working knowledge on the data analysis using SQL Server 2012/2014/2016.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in writing MDX queries and in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Extensively worked on system analysis, design, development, testing, and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages.
• Experience in coding Unix/Windows scripts for file transfers.
• Involved in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor, and Index Tuning Wizard
• Involved in working with databases in C# and Microsoft Visual Studio .Net environment.
• Proficient with automated testing tools - Win Runner, Load Runner and QTP for testing Client / Server and Web-based applications.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2014/2012 , MS Azure SQL Cloud, MySQL, IBM DB2, Teradata, Oracle11g/10g/9i/8i, and MS Access

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP, Azure Data Factory, Azure Data Lake, MS Visio, IBM DB2, Teradata, ER Studio

Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Tableau, MicroStrategy, Excel.

Operating Systems: Windows XP, Windows Vista, Windows 7, Windows 10, Ubuntu, Linux, MacOS

Programming Languages: T-SQL, DAX, PL/SQL, HTML, C#, .Net, Python, R, C++, Java, Java script, CSS, Windows Scripts, Windows Power Shell

Design Technologies/Tools: MS Visio, Erwin, Rational Rose

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2016/2013/2010 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

MSBI/ Power BI Developer

Responsibilities:

• Setting up the Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Designed and developed Tabular Model Cubes. Developed calculated columns and measures using complex DAX.
• Developed custom visuals using Python and R languages.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server, and Flat files.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Created SSIS packages to integrate the data coming from flat files
• Migrated SSIS Packages from old to new versions during data migration.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Created SSIS packages for loading data from SAP BW/BI to SQL Server.
• Performed database backup and deployment to the production server.
• Involved in modifying existing DataStage and Informatica Jobs for better performance.
• Worked on POC to migrate existing on-premises BI platform to Azure Cloud.
• Worked on Azure cloud in spinning of new resources under resource group.
• Worked on Azure Data factory to load the data from on premise to Azure Data Lake.
• Configured Integration Runtime (IR) to move the data from on premise to cloud.
• Worked on PowerShell scripts to automate the creation of resources and resource group.
• Created detail technical documentation of various staging area operations for future reference and guidance.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.
• Designed STAR, SNOWFLAKE Schemas.

Environment: MS SQL Server 2016/2014, MS SQL Azure Cloud, Azure Data Factory, Azure Data Lake, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, Windows PowerShell, MS Excel, Excess, Windows 10/ 8.

Confidential

SQL Server/ MSBI Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed the packages and database solutions.
• Worked on the project using specifically Agile and Scrum methodology with the short-term releases.
• Worked closely with database to design and implement database components in timely manner.
• Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
• Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
• Developed highly complex SSIS packages using various Tasks, Containers and Data transformations.
• Used configuration files, to migrate SSIS packages from development stage to quality analysis (testing) without having to reconfigure the packages.
• Created SSIS packages to extract data from multiple flat files, CSV, Excel and XML filesand scheduled jobs to call the packages.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily/weekly/monthly basis.
• Developed stored procedures using T-SQL programming to meet the business requirements.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Extensively worked on Data Flow transformations like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations.
• Created and maintained Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques.
• Analyzes data by defining quality requirements, making recommendations for changes on the source system, working with users to correct historical data and by applying standard data cleansing in integration services flows using SQL Server Data Tools.
• Experience working with Team Foundation Server (TFS) and Visual SourceSafe.
• Responsible for regression testing ETL jobs before test to production migration.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Executed Transact-SQL batches, system procedures, and script files at the command prompt using SQL CMD Utility.
• Developed the database application using agile methodology along with Java development.
• Used Team Foundation Server for storing and moving the developed scripts to other environments.
• Resolvedandclosedthe Production tickets generated due to failure of production jobs.
• Developed unit test plans for SSIS packages and created a technical documentation.
• Worked for Development in error and bug fixing during testing phase for making the project run successfully.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, SQL Server Agent, Java, C#, DB2, Visual Studio 2016, XML, XSLT, MS Office, and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio.

Confidential

SSIS/SSRS Developer

Responsibilities:

• Responsible for transformation and loading into the target SQL Server databases using ETL tools, DTS and SSIS.
• Created SSIS packages with which data resources such as Flat files, Excel files, were loaded daily to create and maintain a centralized data warehouse.
• Made the package dynamic so it fits the environment.
• Scaled SSIS to make it work more reliable.
• Expertise experience with administering and debugging DTS and SSIS.
• Created scheduled jobs to execute DTS and SSIS packages.
• Transferred/Rewrote DTS packages to SSIS Packages. Hands on working experience with configuring every aspect of SSIS.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Involved in all the implementations, Data modelling techniques, Performance tuning and Query Optimization with SQL Server database.
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Developed reports without formal specifications often.
• Involved in building dimensional cubes with SQL Server Analysis Services(SSAS)and querying the data withMDXscript.
• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various data sources and thus, developed Cubes.
• Create prototype SQL Server Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM).
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2014/2012 Enterprise, Microsoft Reporting Service, SQL server BI development studio,Microsoft Visual Studio 2012.

Confidential

SQL/SSIS Developer

Responsibilities:

• Interacted with Business team to collect data for the conceptual design of the system.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Merged Data from Heterogeneous Data sources (Oracle, Access, and Excel) to SQL Server using SSIS packages.
• Participated in to Design ETL architecture and processes insurance and policies related record from different locations. Successfully met challenges of very high volume of data.
• Extensively used transformations, control flow tasks, data flow tasks, containers, and event handlers.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors, and user defined functions (UDF’s).
• Imported XML data file and put into the desired database.
• Created and Executed the Stored Procedures and Complex Queries for Reports.

Environment: SQL Server 2012/2008, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 7.