SUMMARY

• Over 9+ Years of experience as a SQL Server/Business Intelligence Developer/ETL in SQL - BI suite Comprising of SQL Server Integration Services(SSIS)/SQL Server Reporting Services (SSRS)/SQL Server Analysis Services(SSAS)/Power BI/Tableau along with Professional Database design, development and maintenance of MS SQL Server 2012/2008r 2/2008/2005.
• Proficient in using SQL Server to Develop T-SQL statements and objects including Tables, Views, Indexes, SQL Joins, Store Procedures, User Defined Functions, Triggers, Cursors and implementing performance based query writing skills.
• Experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse.
• Experienced in SQL Query optimization techniques and debugging SQL statements.
• Proficient in tools like SQL Profiler and Query tuning advisor for monitoring and tuning MSSQL Server performance.
• Strong Experience in ETL mapping using SQL Server Integration Services (SSIS) to load data into the Data Warehouse from heterogeneous database like Flat Files, Excel, Oracle,DB2 and SQL Server.
• Excellent experience in maintaining ETL Batch Logging, ETL Error Logging with Event Handlers and Configurations, Parameters using SSIS.
• Extensive experience working with high volume data bases in Data warehouse, relational databases.
• Proficiency in deploying SQL objects and SSIS Packages in SIT, UAT, Pre production and production environments.
• Experienced in usingSSRSto build reports like Table, Matrix, charts, Lists.
• Proficiency in developing and deploying various reports like drilled down, drilled through, sub reports and parameterized reports using MS SQL Server Reporting Services (SSRS).
• Proficient inSSRSdeployment, and very knowledgeable to create cache/snapshot/subscription (Email and Data-Driven) forSSRSreports.
• Experienced in Creating Ad-Hoc reports by using Excel and Report Builder in SSRS 2012/2008r2/2008 and 2005.
• Experience in designing, creating, managing, Deploying and Monitoring Cubes usingSSAS Tabular model and Multidimensional model.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, and creating hierarchies usingSSAS.
• Expertise in creating KPI’s, Perspectives, Partitions and Design Aggregations in cubes usingSSAS.
• Expert in writing basicDAXand MDX queries with experience in creating and customizing Cubes using SSAS.
• Proficient in OLTP, OLAP and Data Warehousing Design concepts.
• Experienced in building visualization reports inPowerBIfrom the Scratch.
• Responsible for creating and changing the visualizations inPowerBIreports and Dashboards on client requests.
• Created Calculated Columns and Measures inPowerBIand Excel depending on the requirement using DAX queries.
• Eexperience on publishingPowerBIreports on dashboards inPowerBIserver.
• Created hierarchies inPowerBIreports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data in toPowerBIfor creating reports.
• Managed relationship between tables in Power BI.
• Used different type of slicers available inPowerBIfor creating reports.
• Performed daily tasks including backup and restore by usingSQLServer Management Studio.
• Experienced in Scheduler tools like SQL Agent, Third party scheduler tool Autosys (10.X/9.X).
• Experienced under ITIL process.
• Experienced in SIT, UAT, Production environment Support.
• Troubleshoots and resolves production problems, root cause analysis and performance bottlenecks.
• Perform ad-hoc requests for data manipulations, imports, exports, updates, createSQLagent jobs and schedules.
• Experienced in Software Development Life Cycle (SDLC) methods like Agile and Waterfall.
• Able to multitask and set priorities in delivering and meeting project deadlines.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt innovative technology quickly and a strong team player.

TECHNICAL SKILLS

Databases: MS SQL SERVER 2012/2008R2/2005, DB2, Oracle 9i/11g, 10g.

Operating Systems: Windows /XP/Vista

OLAP/Reporting Tools: SQL Server Analysis service (SSAS), SQL Server Reporting Service (SSRS), Tableau 10.x/9.x,Power BI

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

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio, Autosys, TFS, Service Now, Remedy, JIRA

SQL Server Tools: SQL server management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler, FTP.

Programming languages: Transact-SQL, PL/SQL, C#, HTML, XML

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, SQL Physical and Logical Data Modeling

Domain: Financial, Insurance, Marketing

PROFESSIONAL EXPERIENCE

Confidential, PA

Module Lead

Responsibilities:

• Understanding the ETL Technical and functional Documents.
• According to the Requirement created the SSIS Packages, SSRS Reports, SSAS cubes, Power Bi dashboards & Tableau Dashboards.
• Responsible for source data analysis.
• Extracted data from flat files, Oracle data base, Excel files.
• Used Execute SQL task, DFT task, Containers, Execute package task, Event Handler and Custom Logging to created Logging, Error Handling, Parameters, Expressions Etc. for SSIS Packages.
• Used SQL in SQL Server, Oracle to develop Stored Procedures, User-Defined Functions (UDFs), and triggers to support the incremental loading packages.
• Used Autosys as scheduler tool for SSIS & SSAS.
• Optimized existing Store Procedure by monitoring through SQL Profiler and Query Analyzer.
• Involved in developing initial load/incremental load ETL Packages, Staging Data ETL Packages, Package Test Script, and Report requirements/Unit Testing Document and synchronized these packages/ Documents into Team Foundation Server (TFS).
• Developed Store Procedures in T-SQL to replace existing SSIS packages in ETL process and gained better Performance.
• Created SQL Agent Jobs for Schedule SSIS Packages.
• Deployed and Configured ETL Packages and coordinated with broad Database Administration team to schedule the package in SQL server agent.
• Used SQL Server Analysis Services (SSAS) to create cubes with various measures and dimensions for report generation.
• Developed Aggregations, partitions based on calendar quarter for cube to improve running performance and business needs.
• Designed analytical reports and dashboards utilizingPowerBIDesktop to identify critical KPIs per business requirements.
• Designed ad-hoc reports in excelpowerpivot and shared them usingPowerBIto the decision makers for strategic planning.
• Created spreadsheet, bar chart, pie chart and filled/symbol map withPowerBI.
• Monitoring and troubleshooting the Informatica workflows.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL/BI applications.
• Develop and perform tests on all ETL codes for system data and analyze all data and design mapping techniques for all data models in systems.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.

Environment: MS SQL SERVER 2012/2008r2, Oracle10g(10.2.0.5), SQL Server Integrations Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), T-SQL, SQL,PL/SQL, Power BI, Tableau 10.x & 9.x. Autosys, Informatica 10.x.

Confidential - Michigan

BI Developer

Responsibilities:

• Created and maintained SQL database object such as Tables, views, indexes and store procedures with SQL Server Management Studio (SSMS) 2008r2.
• Created SSIS packages for migrating the Data from DB2, Flat files, Excel files.
• Extracted and transformed Source Data by SSIS. Soundly used SSIS transformations, Such as Conditional Split, Merge, Union ALL and Derived Column Etc..
• Created SSRS report, such as drilled down, drilled through and parameterized reports with T-SQL query to pull data from MS SQL databases.
• Created dashboards, reports, analytics and advanced graphical virtualizations by using various reporting objects like Facts, Attributes, Hierarchies, Filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Created SQL Server Agent jobs for auto-run SSIS package, such as SSAS cubes’ refreshment.
• Created multidimensional Cubes for summary reporting.
• Worked closely with end users with very little technical background. Translated requests to BI and delivered Solutions to meet end users’ needs.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL/BI applications.
• Develop and perform tests on all ETL codes for system data and analyze all data and design mapping techniques for all data models in systems.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.

Environment: Microsoft Visual Studio, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), Tableau, T-SQL.

Confidential

BI Developer

Responsibilities:

• Created and maintained database for the company’s daily operation.
• Monitored SQL Server Database and assisted solving SQL server related issues.
• Used SSIS to extract data of orders, freight schedule and account payable every day from various sources such as flat file, Excel and other Relational Databases and inserted them into SQL Server Database.
• Developed, modified and upgraded store procedures based on changes made in operation to maintain data processing quickly and efficiently.
• Created views for the most retrieved data sets to make sure every team member has access to updated key data sets.
• Scheduled ETL Process to populate Data Marts.
• Summarized, converted and distributed data based on data value by using SSIS.
• Used Event Handler, and Custom Logging to created Logging, Error Handlin for SSIS Packages.
• Created Gauge Report, Sub Reports, Drilled down Reports, Summary Reports, Linked Reports and Parameterized Reports in SSRS and Tableau for different departments.
• Extracted data from Flat file, Excel and Relational Database to generate reports from Tableau.
• Highly involved in configuring service on server, member permission and configured SharePoint farms, created team sites and monitored workflow.
• Configured documents properties and set alerts on files based requirements.

Environment: Microsoft Visual Studio, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), T-SQL.

Confidential

SQL Developer

Responsibilities:

• DesignedSSISpackages to Extract data from different sources likeSQLserver2005, MS Excel, MS Access and transform and then load into Dimension and Fact tables in Data Warehouse usingSSIS.
• DevelopedSSISpackages using for each loop in Control Flow to loop all excel files within folder, File System Task to move file into Archive after processing and ExecuteSQLtask to insert data into theSQLtable.
• Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the ReportingSQLServerenvironment.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or an Excel pivot table.
• Worked onSQLProfiler to view indexes performance to mostly eliminate table scan.
• Performed operations such as Fine-tuning highly complex TSQL stored procedures for maximum efficiency and performance.
• Produced operational reports inSSRSi.e. drill-down, drill-through, chart reports, parameterized reports and snapshot reports.
• Provided design, implementation and maintenance for custom reports using different techniques like data filtering, adding interactivity, deploying reports to reportserverusingSSRS.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Worked with project manager and technical leads for resolution of technical issues.
• Extensively usedSSIStransformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Slowly Changing Dimension and row count etc.
• Worked on formattingSSRSreports using the Global variables and expressions.

Environment: Microsoft Visual Studio, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), T-SQL.