SUMMARY:

• Experienced MS Business Intelligence Developer with 7 years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments, visualization tools such as Power BI and Tableau. A wide experience working in different industry domains such as healthcare, service, retail and finance.
• Over 7+ years of working experience in MS SQL Server in various domains like Finance, HealthCare and Retail with expertise in MS SQL Server 2016/2014/2008/2005, SSIS, and SSRS. Experienced in handling multiple tasks under strict deadline and capable of handling responsibilities independently as well as a proactive team member.
• Highly proficient in using T - SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.
• Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager.
• Expert in Migration of data from Oracle, Sybase and DB2 to SQL Server.
• Involved creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, MOLAP cubes, Including Star and Snowflake schema.
• Expert in Creating, maintaining and Configuring SSIS packages.
• Involved working with heterogeneous data source like Excel, Flat file, Oracle, DB2, and SQL Server.
• Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved creating operational reports in SSRS 2008/2008r2/2012 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
• Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Experience in scripting languages like C#, JQuery and JavaScript and utilizing them on designing and developing ASP.net based UI.
• Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
• Defined and administered database standards, controls, procedures and documented the same.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.
• Experienced in Create report by using Power BI Desktop.
• Authorized to work in United States for any employer

TECHNICAL SKILLS:

OS: Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX: Databases SQL Server 2016/14/12/08 R2, Oracle 11g/8.0i, MS Access 2000/8.0, Teradata 14.0, DB2

Languages: T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Frame Work, C#, C, C++, JavaScript Web Tools C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting SSDT: 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS) 2016/2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2 R2), PowerBI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, DataStage, Informatica, Hadoop, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, Synergy, HP Quality Center & Jira

PROFESSIONAL EXPERIENCE:

Confidential - Kansas City, MO

Lead SSIS/SSRS/SQL developer

Responsibilities:

• Created ETL Packages using SSIS for extracting, cleaning, transforming and loading data from Staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Implemented data validation by using T-SQL queries to confirm that SSRS reports data results that are being returned are correct.
• Worked closely and communicate with project team members to achieve project goals.
• Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using SSRS.
• Participated in design discussions with Database architects and Application architects.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created Indexes for faster data retrieval from the database.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
• Coordinated with Users in different testing phases.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB and SQL client.
• Good hands on experience with C#.NET and VB.NET for downloading files from a remote server.
• Strong skills in transformation data from DB2 to SQL Server
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and SnowFlake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS).
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs and deployed cubes.
• Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.

Confidential, San Francisco, CA

Sr BI developer

Responsibilities:

• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Identified the dimension, fact tables and designed the Data - Mart using Star schema.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Data transformation from DB2 to SQL Server
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and SnowFlake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS).
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs and deployed cubes.
• Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.

Confidential - San Francisco Bay Area, CA

SQL Server SSIS, SSRS Developer

• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Upgraded/Migrated SQL Server 2000/2005 databases into SQL server 2008R2/2012 and mentored other technical staff.
• Tuned packages by updating statistics and reorganizing the indexes to improve the server efficiency in SQL Server 2014
• Involved in creating the Relational Database design. Wrote T-SQL queries to support different transactions.
• Monitored Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application; Making changes to existing ETLs and building some new ETL processes.
• Developed/Deployed SSIS packages through package installation wizard, Bids Deployment, Management Studio Import to further automate data processes.
• Data Automation Using SSIS to automate data processes for input of information.
• Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and Quarterly Reports including current status.
• Involved in creating report datasets and using stored procedure parameters in SSRS.
• Implemented data validation by using T-SQL queries to confirm that SSRS reports data results that are being returned are correct.
• Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using SSRS.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.

Confidential - Monroe, LA

SQL Server SSIS, SSRS Developer

• Install and configure SQL Server 2008R2/2012. Troubleshooting Performance issues and database issues
• Worked on T-SQL programming, stored procedures and views in the processing of developing reports. Worked on SQL Server 2008 R2 and 2012 for different parts of the project.
• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Created Joins and SubQueries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Created Linked Servers to retrieve data from other databases.
• Created Extract, Transform and Load (ETL) packages using SSIS to load source data from flat files to database tables.
• Developed slowly changing dimension SCD-Type 0,1,2 in SSIS to update the old data in dimension tables when the new source data is loaded. Also automated the process by deploying the packages into SQL server and creating jobs in SQL Server Agent.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005, OLEDB using SSIS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Extensive knowledge on designing Reports, Scorecards, and Dashboards using SQL Server Reporting Services, PerformancePoint.
• Developed perspectives to simplify the process of browsing the cubes. Defined calculations, which are Multidimensional Expressions (MDX) expressions.
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and Quarterly Reports including current status.