SUMMARY

• Over 12 years of experience in Data modelling, Database Design, Programming, Development, and Implementation of Client Server Applications and Database Systems using MS SQL Server 2005/2008/2012/2014/2016.
• Experience and knowledge of working in various domains such as Health Care, Banking and Financial.
• Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries, T - SQL-Programming, query optimization and performance tuning on SQL Server
• Highly proficient in design and development of SQL Server Integration Services (SSIS) packages and using various control flow tasks and data flow transformations.
• Experience in using Confidential BI studio products like SSAS, SSRS and SSIS for implementation of ETL methodology in data extraction, transformation, and loading.
• Gathering Requirements from diverse groups, assessing technical needs, creating prototypes.
• Expertise in installing, designing, developing, maintaining, and tuning of RDBMS.
• Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS).
• Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Cascaded, Sub reports and Charts using SQL Reporting Services (SSRS) based on Relational and OLAP databases. Designing, Scheduling and Maintaining ETL Framework for different Processes.
• Integrated Custom Visuals based on business requirements usingPowerBIdesktop.
• Created different visualization inPowerBIaccording to the requirements.
• Explore data in a variety of ways and across multiple visualizations usingPowerBI.
• Experienced in installing Power BI, developingPowerBIReports and Dashboards from multiple data sources using Data Blending.
• Effective in working independently and collaboratively in team

TECHNICAL SKILLS

• Business Intelligence (2008/2012/2016 )
• SQL Server (2005/2008/2012/2016 )
• Oracle (PL/SQL)
• Tableau
• Power BI

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

SQL (SSIS/SSAS)/Power BI Developer

Responsibilities:

• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Experience in Writing Complex T-SQL Queries, sub-queries, Complex joins
• Setting up Connection Strings and connecting SQL ServerAzureDatabases from locally Installed SQL Server Management Studio (SSMS).
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transformations.
• Experience in using C#.net in script component of SSIS.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Created several reports and dashboards in Power BI using SQL Server Analysis Services (SSAS) as data source.
• Used various sources to pull data intoPower BI such as Azure SQL Database, Azure Analysis Services.
• Installed and configured Enterprise gateway in Power BI service.
• Scheduled Automatic refresh and scheduling refresh in power BI service
• Managing the teams(Onshore/offshore) is also be part of the job role

Confidential, Philadelphia, Pennsylvania

SQL (SSIS/SSAS)/Power BI Developer

Responsibilities:

• Created and wrote database objects such as tables, indexes, views, procedures, functions, triggers,T-SQLcode with proper grants to all the users and roles.
• Implemented Error Handling and Logging in SQLServer Integration Services (SSIS).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package as per the advanced feature of SQL Server Integration Services.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQLServer using Lookup, Derived Columns, Condition Split, Aggregate, and Pivot Transformation.
• Developed, deployed, and monitored SSIS Packages using visual studio.
• Used containers, Execute SQLtask, Execute package task, Script task etc. for transformation of data in the SQLServer Integration Services packages.
• Designed dimensions and hierarchies inSSAStabular models based on star schema from Data warehouse.
• Developed Tabular Models using SQL Analysis Services (SSAS).
• Assisted in production Tabular Models, wrote queries to produce reports using Azure SQL Server Analysis Services (SSAS) and Power BI.
• PublishedPowerBIreports fromPowerBIdesktop toPowerBIservice.
• Used Power BI and embedded Power BI reports into ASP.Net applications.
• Created, Maintained & scheduled various reports inPowerBI.
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports.
• Creating stored procedures and some complex queries to embed this in SSRS reports.
• Responsible for all the client deliverables.

Confidential

SQL (SSIS/SSAS)

Responsibilities:

• Involved in writing complex SQL queries & Stored Procedures, Functions (T-SQL) & Performance Tuning.
• Strong experience inT-SQL Query, Stored Procedure development and tuning,C#.NET/ VB.NETsupport and development.
• Implemented Error Handling and Logging in SQLServer Integration Services (SSIS).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package as per the advanced feature of SQL Server Integration Services.
• Used containers, Execute SQLtask, Execute package task, Script task etc. for transformation of data in the SQLServer Integration Services packages.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQLServer 2005 using Lookup, Derived Columns, Condition Split, Aggregate, and Pivot Transformation.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Built tabular models for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS.
• Designed and implementedSSASTabular model as the reporting layer and used DAX scripting to access data from Tabular Model.
• Advanced extensible reporting skills using SQLServer Reporting Services (SSRS).
• Worked on developingPowerBIreports and dashboards from multiple sources.
• Created many complexes Query's and used them inPowerBIReports directly to generate reports on the fly.
• Responsible for all the client deliverables

Environment: SQL Server 2005/2008, T-SQL, Data Transformation Services (DTS), Advanced Reporting Services (SSRS), Integration Services (SSIS), SSAS, BI Tool Kit, SQL Profiler

Confidential

BI Developer

Responsibilities:

• Developing the ETLs using tool called CHEF
• Scheduling jobs to execute the ETLs
• Involved in creation and debugging of Complex SSIS packages using different kinds of sources and destinations
• Creating packages on SSIS by using different data transformations like Derived column, Look-up, Conditional split, Merge join, Sort, Data Conversion and Execute SQL Task to load data into database.
• Created Stored Procedures, Views and user-defined functions.
• Building and generating the SSRS Reports
• Developing parameter reports including cascading parameters
• Created sub reports, bar charts, drill-down and matrix reports
• Scheduling reports using Reporting services to e-mail with an attachment in the desired format of report to the top management
• Creating the Power View Reports

Confidential

SQL Developer

Responsibilities:

• Creating SSIS packages by using different data Transformations like Derived Column, Conditional Split, Merge Join, Sort and Execute SQL Task to load data into database.
• Scheduling Jobs to execute SSIS packages
• Developed Stored procedures, Triggers, Indexes, Views and user defined Functions
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Used Execution Plan, SQL Profiler and database engine tuning ad-visor to optimize queries and enhance the performance of databases
• Using Report Studio, we have developed many Cognos reports like Cross-tabs, Drill-down, Chart
• Using Event Studio, we have automated many of the Daily/Weekly reports
• We automated all manually maintaining reports, process and jobs by scheduling them upon the clients request.
• Monitoring the reports and their distributions to all the requested users.
• Create BRS for the new reporting, Business Model and Tools request from client.

Environment: SQL Server 2005/2008, T-SQL, Data Transformation Services (DTS), SQL Profiler

Confidential

T-SQL Developer

Responsibilities:

• Worked on various databases like billing database and accounting database
• Contributed help in designing & creating database tables as per requirement
• Analysed existing Stored Procedures & Triggers and took actions to increase the performance in modulation
• Creating Stored procedures, Functions, Triggers
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Used Execution Plan, SQL Profiler and database engine tuning adviser to optimize queries and enhance the performance of databases
• Involved in Unit Testing and Bug Fixing

Environment: MS SQL Server (2005/2008), SQL Profiler

Confidential 

SQL Developer

Responsibilities:

• Worked on various databases like billing database and accounting database
• Analysed existing Stored Procedures & Triggers and took actions to increase the performance in modulation
• Creating Stored procedures, Functions, Triggers
• Used Execution Plan, SQL Profiler and database engine tuning ad-visor to optimize queries and enhance the performance of databases
• Mostly involved in Query Optimization

Environment: MS SQL Server (2005/2008), SQL Profiler, VB.Net