P ROFESSIONAL SUMMARY:

• Around 7+ years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2012/2008/2005, DTS/SSIS, SSRS, SSAS.
• Expertise in development of procedures, functions, packages and triggers, cursors, indexes, UDF, synonyms, collections, Exception handling, Query Tuning using query optimizer in the development and design of SQL Server database.
• Extensive experience in development and deployment of customized reports using SSRS with enormous use of Integration services using SSIS for packages, Migration (MSMA), Troubleshooting, Backup and Recovery.
• Experience in Developing Power BI Reports and Dashboards from Multiple data sources using Data Blending.
• Database and Log Backups and restores, backup strategies, scheduling backups. Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled.
• Good experience in working with Agile Methods like Scrum, Open Agile, Lean.
• Extensive knowledge in designing ETL objects mappings, using mapping operators, transforming data in SSIS. Expert in working with SSIS for creating packages to transform data from different OLEDB Provider.
• Expertise includes analysis, design, development and application using SQL Server Integration Services (Control Flow, Data Flow, Error Handling, Data transformation Tools, Data Conversion).
• Installation of SQL Server 2005,2008 with Reporting Services(SSRS) & Integration Services(SSIS) with migration from SQL Server 2000 to Server 2005. Extensively worked on SQL Server Report Services (SSRS) Designer, Operator and troubleshooting with data sources.
• Skilled at using SSAS extensively for configuring and managing data sources, data source views, dimensions, cubes and mining structures
• Experience in using Multi - Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards and Score Cards.
• Good experience using Peoplesoft System Administration and Security Administrator. I mplementing and maintaining security in various levels. Creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content References and Definition Security. Managing PIA, Tuxedo Application Server Domains, Web Logic and Process Schedulers.
• Expert in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Data Analysis, Normalization, Data warehousing, Data Cleansing, Data Modeling, Data Mapping, Erwin 3.0 in OLTP & OLAP environments.
• Extensively involved in T-SQL performance tuning to enhance the performance of the complex queries for Reports, Packages and other business logic.

TECHNICAL SUMMARY:

Data Warehousing & BI: SQL Server Business Intelligence (SSIS, SSRS, SSAS)

Reporting Tools: SSRS, SSAS and Crystal Reports, Open Text

Languages: C, SQL, T-SQL, PL/SQL, HTML, XML, DAX, MDX, DTS, Power BI, PowerPivot, Power view.

Operating Systems: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Databases: MS SQL Server 2016/ 2014/2012/2008 R2, Oracle 10g/9i/8i, MYSQL, MS-ACCESS

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), IBM AS/400.

ERP: Peoplesoft

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles

Sr. SQL Server BI Developer

• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2014/2012/2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Developed cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions etc. and created various user roles. Developing OLAP cubes using SSAS 2012/2015 and calculate the metrics that were revealed in the functional analysis.
• Expertise skills in calculating measures and dimension members in SQL Server Analysis Services (SSAS 2012/2015) using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Extracted data from SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment. Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Along with SSRS, tableau to create adhoc reports by connecting various data sources, multiple views and associated reports. Also, used Excel, flat files, CSV files to create Tableau adhoc reports.
• Implemented SSRS Security and Deployed Reports to report server.
• Generated Power BI Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Power BI reports. Created reports in Power BI preview portal.
• Generated Power BI reports with Trend lines, Reference lines and Bands and generated several drilldown and drill up reports.
• Automated the entire process of data refresh using PowerShell scripts and Azure platform tools such as Azure automation and run books and web hooks.
• Based on these deliverables, we were able to retire existing reporting platforms which is based on premise data base and Business Objects which had lot of data and performance issues and involved more manual support, into Azure Cloud platform and Power BI advanced reporting.
• Migrated Sales, Customer and Product and organizational data from on premise to Azure Cloud based platform using Azure data factor.
• Generated Power BI Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Power BI reports.
• Generated Power BI reports with Trend lines, Reference lines and Bands and generated several drilldown and drill up reports.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Scheduled, maintained, and supported the distribution and access to reports at Server.

Environment: MS SQL Server 2000,2008,2012,2014 Guide Wire Claim Center tools, Power Pivot, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2010, .NET(C#, VB), Azure, Autosys Scheduler, Peoplesoft, Windows XP/Server 2012, MS Office 2010.

Confidential, Houston, TX

Sr. SQL Server BI Developer

• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations and data conversion to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Implemented SSRS Security and Deployed Reports to report server.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Fine-tuned the current SSAS cube for performance improvement and created proper partitions and designed aggregations to enhance the performance of the SSRS reports.
• Worked on calculating measures and dimension members in SSAS using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models and developing reports using MDX and T-SQL.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance. Performed T-SQL tuning and optimization of queries for reports that took longer execution time.
• Experience in writing DAX in MS Power BI Desktop.

Environment: MS SQL Server 2000,2008,2012,2014, Power Pivot, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2010, .NET(C#, VB), Autosys Scheduler, Windows XP/Server 2012, MS Office 2010.

Confidential

Sr. SQL Server BI Developer

• Created indexed views, and appropriate indexes to cut the complex query run time. Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created ETL Projects using SSIS 2012 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring..
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Built the Source to target mapping document based on Subject areas for ETL Data Integration initiative. Created Star Schema from analyzing the underlying requirements of the data ware house
• Deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
• Configured and Tuned SQL Server 2012 Analysis Services (SSAS) Tabular and Multi-Dimensional Cubes.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Created gauge, funnel, slicer, stacked area chart, line chart utilizing Power BI.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Worked and tuned T-SQL Stored Procedures, Views, Complex Queries, Functions on OLTP and OLAP Environments.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks. Developed SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.

Environment: MS SQL Server 2000,2008,2012,2014 Guide Wire Claim Center tools, Power Pivot, MVC4, Cognos, SQL SSIS, SQL SSRS, T-SQL, Oracle, Autosys Scheduler, Visual Studio 2010, .NET(C#, VB), Windows XP/Server 2012, MS Office 2010.

Confidential

Sr. SQL BI Developer

• Primary focuses were in the reengineering of the ETL processes using the SQL Server Reporting Services SSRS
• Used Microsoft Tableau BI Query to by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau adhoc reports.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Doing data transfer from various types of databases with conversion through SSIS. Using Data Cleansing to avoid duplicate, corrupt or inaccurate data using SSIS tools.
• Tuning package components like Script Task, Data Flow task, Data Conversion, Multicast, Sort, and Conditional split, Script Component, Configuration file, etc.
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Designed and developed Data marts using SSAS.
• Wrote complex Stored Procedures to meet the business requirements. Created tables, relationships, triggers and indexes for enforcing business rules.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Designed and built data load procedures, using MS SQL Server.
• Performed database Log Shipping for high availability solutions and fault tolerance between multiple SQL server instances.
• Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases.
• Implementing MS SQL Server Security and database Permissions.
• Wrote DTS scripts that extract data from database tables and write the data to text files.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance. Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Involved in creating Technical Specification Document (TSD) for the project.

Environment: SQL Server 2000, 2005/2008, T-SQL, SSRS, SSIS,SSAS, Query Analyzer, DTS, Windows 2000 Advance server, Windows NT.

Confidential

SQL Server Developer

• Monitoring Log shipping/Replication and troubleshooting of errors.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Performed database backup and archived on regular basis.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.
• Resolved any deadlocks issues with Databases/Servers on a real-time basis.
• Implementing MS SQL Server Security and database Permissions.
• Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, log space utilization monitoring etc.
• Backup and Restoration of data/databases using third party tool (SQL LITE Speed). Involved in Design and Development of Disaster Recovery Plan.

Environment: SQL Server Enterprise Edition, SSIS, Windows 2000/NT, UNIX, Excel, SQL Profiler, Replication, DTS, MS Access, T-SQL, Crystal Reports.