SUMMARY:

• 9 Years of experience as a SQL Server developer/ Data warehousing/ 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 2014/ 2012/2008 r 2/2008/2005.
• Strong experience in using SQL Server to Develop T-SQL statements and objects including Tables, Views, Indexes, SQL Joins, Store Procedures, User Defined Functions, Triggers, Cursors etc. and implementing performance based query writing skills.
• Experience in OLTP and OLAP design model, development, testing, implementation and support of enterprise data warehouse.
• Experience in Data Warehouse and Data Mart design, Star Schema, Snow Flake Schema concepts and principles.
• Good understanding in entity relationships and Data Models.
• Experienced in SQL Query optimization techniques and debugging SQL statements.
• Proficient in tools like SQL Profiler and Query tuning advisor for monitoring and tuning MS SQL Server performance.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using SSIS and SQL Server.
• Strong Experience in ETL mapping using SQL Server Integration Services (SSIS) to load data into the SQL Server database from heterogeneous database like Flat Files, Excel Files, 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 using SSRS to 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 in SSRS deployment, and very knowledgeable to create cache/snapshot/subscription (Email and Data-Driven) for SSRS reports.
• 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 using SSAS Tabular model and Multidimensional model.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, and creating hierarchies using SSAS.
• Expertise in creating KPI’s, Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Good Knowledge in writing DAX and MDX queries with experience in creating and customizing Cubes using SSAS.
• Having Experience on Microsoft Power BI (Desktop, Service, Mobile)
• Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
• Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
• Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Published reports and dashboards to the Power BI service through the Office 365 integration.
• Shared the dashboards among multiple users in the group.
• Implemented row level security by restricting the users for the data access.
• Configuring the data sources to schedule the data refresh using Power BI gateways (Personal and Enterprise). And also created Content packs.
• Created User Groups and shared the content packs among multiple users in the specified group.
• Performed daily tasks including backup and restore by using SQL Server 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, create SQL agent 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 2014/2012/2008 R2/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

Sr SQL BI developer

Responsibilities:

• Understanding the ETL Technical and functional Documents.
• According to the Requirement created the complex T-SQL objects, SSIS Packages, SSRS Reports, Power BI,T ableau 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.
• Created complex SQL scripts 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 cube refresh.
• 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 complex Store Procedures, Functions, Joins, Triggers etc. in T-SQL.
• Performed database administration activities.
• C reated 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.
• Created SSRS reports like Table, Matrix, Charts, Lists etc.
• Created Subscriptions, Caches, Snapshots in SSRS Report manager.
• Created Parameterized, Drill through, Drill down, Matrix and Sub reports, added report mapping functionality to the reports using MS SQL Reporting Services.
• 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.
• Created Power BI reports and dashboards on Microsoft Power BI (Desktop, Service, Mobile)
• Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
• Designed analytical reports and dashboards utilizing Power BI Desktop to identify critical KPIs per business requirements.
• Designed ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planning.
• Created spreadsheet, bar chart, pie chart and filled/symbol map with Power BI.
• 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 2014/2012/2008 r2, Oracle 10g (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.

SQL Server Developer

Confidential

Responsibilities:

• Created and maintained SQL database object such as Tables, views, indexes and store procedures etc. 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 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, MS SQL SERVER 2012/2008r2, SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), Tableau, T-SQL.

SQL Database Developer

Confidential

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, MS SQL SERVER 2008r2, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), T-SQL.

SQL Server Database Developer

Confidential, NY

Responsibilities:

• Designed SSIS packages to Extract data from different sources like SQL server 2005, MS Excel, MS Access and transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages 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 Execute SQL task to insert data into the SQL table.
• Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or an Excel pivot table.
• Worked on SQL Profiler 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 in SSRS i.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 report server using SSRS.
• 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 used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Slowly Changing Dimension and row count etc.
• Worked on formatting SSRS reports using the Global variables and expressions.

Environment: Microsoft Visual Studio, MS SQL SERVER 2005, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), T-SQL.