PROFESSIONAL SUMMARY:

• Around 8+ 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 2016/2014/2012/2008 , DTS/SSIS, SSRS, SSAS.
• Expertise in development of procedures, functions, packages and triggers, cursors,indexes, UDF, synonyms, collections, Exception handling, Query Tuning usingquery 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 ServerIntegration Services (Control Flow, Data Flow, Error Handling, Datatransformation Tools, Data Conversion).
• 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, Implementing 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 SKILLS

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.

PROFESSIONAL EXPERIENCE:

Confidential, Sterling, VA

Sr. SQL Server ETL Developer

• 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.
• 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.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• 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 ETL Projects using SSIS 2014 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
• 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.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Expertise in using Cloud based managed services for data warehousing/analytics in Microsoft Azure (Azure Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Table Storage, U-SQL, Stream Analytics, HDInsight, etc.).
• Create data integration and technical solutions for Azure Data Lake Analytics, Azure Data Lake Storage, AZURE Data Factory, Azure SQL databases and Azure SQL Data Warehouse for providing analytics and reports for improving marketing strategies.
• Working with multiple technical teams, architects, security officers, managers and business users, reviewed and documented workloads, system dependencies and business requirements. Mapped workloads to the capabilities of Microsoft Azure for public, private and hybrid clouds.
• Setup Azure Virtual Appliances (VMs) to meet security requirements as software-based appliance functions (firewall, WAN optimization and intrusion detections).

Environment: MS SQL Server 2008,2012,2014 Guide Wire Claim Center tools, ASP.NET 3.5/4.0/4.5,C#.Net, Power Pivot, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2010, .NET(C#, VB), Autosys Scheduler, Windows XP/Server 2012, MS Office 2010, Microsoft Windows Azure, Windows server 2012/R2/2013, Windows PowerShell , Microsoft Azure Storage , U-SQL.

Confidential, Richardson, 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 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, Chicago, IL

Sr. SQL BI Developer

• Gather report requirements and document technical specifications.
• Working on SRS document and implementing into functional level by making Data Models (logical and physical) using ERWIN.
• Created and maintained SQL queries and stored procedures.
• Created database objects like tables, views, synonyms, procedures, functions and data base triggers to meet the business requirements using T-SQL.
• Primary focuses were in the reengineering of the ETL processes using the SQL Server Reporting Services SSRS 2005.
• Pulling the data from T-SQL stored procedure to make the parameterized reports.
• Extensively worked on source data from Flat file source systems, SQL server source systems.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Performing administrative tasks like installation and configuration of databases, creating logins, usernames and assigning permissions.
• 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.
• Creating data elements mapping between data models to do data integration tasks.
• Extract data from star schema DSS data warehouse by creating and maintaining complex SSIS.
• Tuning package components like Script Task, Data Flow task, Data Conversion, Multicast, Sort, and Conditional split, Script Component, Configuration file, etc.
• Involved in study of Data Flow requirements and implementation issues to enable smooth sharing of information across the application.
• Designed and developed Data marts using SSAS.
• Application design and development using SQL, PL/SQL stored procedures and setup the scheduled feed programs and batch jobs.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Formatting the existing reports as well as creating new reports with different sources.
• Create and maintain SQL queries, stored procedures and Clusters.
• Designed high-Level design documents for legacy interfaces.

Environment: Microsoft SQL Server 2012 Enterprise Edition, SQL Server Integrating Services (SSIS), SSRS, Visual Studio 2005.

Confidential, Dallas, Tx

Sr. SQL BI Developer

• Primary focuses were in the reengineering of the ETL processes using the SQL ServerReporting 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.