SUMMARY

• Around 9 years of experience in Database Design, Programming,
• Development and Implementation of Client - Server Application Database systems using SQL Server 2005/2008R 2/2012/2014/2016.
• Hands on experience in using Microsoft BI studio products like SSIS, SSAS, SSRS, and Power BI for implementation of ETL methodology in data extraction, transformation, loading and reporting.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block, Unblock Transformations and by writing optimized T-SQL.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for fact and Dimension Tables using Analysis Services.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snowflake schema using SQL Server 2005/2008/2012 Analysis Services (SSAS).
• Hands on experience in creating Partitions using table binding, Query binding and dynamic partitions (Daily, Monthly...)
• Worked with creating Perspectives to improve Cube Performance by hiding unwanted data.
• Excellent hands on experience in creating groups and measures, KPIs.
• Experience in creating reports such as Parameterized, Cascading, drill down/ Drill through Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS and Power BI.
• Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Experience in generating reports for OLTP and OLAP databases.
• Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Strong experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Hands on experience working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Service (PPS), Power view.
• Windows application development using C# .NET, SQL Server.
• Experience with designing and development of applications using MVC
• Design, Develop and Implement Web Applications using .NET Framework Architecture including C# .NET, ASP.NET, AJAX, Web Services, ADO.NET, XML, IIS and Visual Studio.
• Experience in creating branches in TFS source control to code check-ins

TECHNICAL SKILLS

Databases: SQL Server 2014/2012/2008 R2,2005, MS-Access 2000, Oracle 11g/10/9i, DB2/Mango DB (No SQL)

Database Tools: SSMS, BIDS/Visual Studio, SQL Developer

SQL Server Tools: SSMS, Configuration Manager, SQL Server Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Shell Scripting/Power BI

Languages: VB.NET, C#.NET, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX

IDE: Visual Studio 2003/2005/2008 R2/2012

Operating System: Windows XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Informatica, MS Office suite

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC.

PROFESSIONAL EXPERIENCE

MSBI / POWER BI Developer

Confidential, Dallas, TX

Responsibilities:

• Loading the data from application source to stage ODS using SSIS packages.
• Tuning existing stored procedures to improve performance.
• Creating SSIS packages to load data from staging systems to ODS systems.
• Loading data from Restful API’s using script component as transformation.
• Involved in writing T-SQL Programming for implementing Complex Stored Procedures, dynamic SQL and Functions for different tasks for application.
• Created and debugged complex stored procedures, views and functions for better performance and flexibility.
• Created SSIS packages to load data from API’s using SSIS Script Component using C#.
• Developed Dynamic DFT using C#.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized Reports, Tabular reports, Matrix reports for the accounting calculation analysis by the end users using SSRS 2012/2014 and Power BI.
• Published Power BI reports into Power BI service and merged various reports as one single dashboard.
• Dealing with incremental data refreshes for larger data sets using power bi premium to maintain the pace.
• Worked on DAX (Data Analysis Expression) to aggregate the data using different mathematical and filtered functions.
• Worked on Restricting the users to export the data from dataset into excel, to prevent the data leakage.
• Responsible for gathering requirements from business users, managers and build Power BI visualizations, dashboards as per their requests using multiple data sources like excel, SQL, SharePoint and SSAS live data.
• Used visuals like tables, matrix, bar, card, gauge, waterfall charts, trend visuals and custom visuals like hierarchy slicer.
• Involved in performing transformations like Appending, transposing, creating calculated tables, columns, KPIs using DAX language.
• Used Row level security with Power BI Desktop to restrict the sensitive data access to the users. Users can only see their allotted data.
• Used on premises data gate ways to refresh the data in reports directly from the services by connecting to the database in order maintain the reports updated.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Environment: SQL Server 2016, Visual Studio 2012/2010/2008/2005 , C#, SSIS, Web Service, CSS, XML, TFS, POWER BI

Sr.SQL Server Developer

Confidential, Austin, TX

Responsibilities:

• Worked as SQL Performance engineer to improve performance of application by debugging through SQL server profiler.
• Loading the data for different banks from VCF files using SSIS packages.
• Encrypting files before loading the data into SQL server for data protection.
• Implemented SQL server functions to encrypt sensitive data using third party tool.
• Created Dynamic SSRS reports for application to access the data for end users based on their requirement.
• Involved in writing T-SQL Programming for implementing Complex Stored Procedures, dynamic SQL and Functions for different tasks and for application.
• Created and debugged complex stored procedures, views and functions for better performance and flexibility.
• Involved in fixing production related issues by debugging application front end involved in Angular JS, ASP.net MVC and SQL server.
• Migrating Data from SQL Server to Teradata using SSIS with third party connectors.
• Provided On-Call support to Mission Critical Environments and deploying builds on time.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
• Designing, developing and maintaining business intelligence solutions
• Strong background in graphic design, data visualization, user experience, or interaction experience
• Worked as offshore lead to collecting the requirement from business team and coordinating with offshore team.
• Getting task done on time and submit the tasks on time for each scrum meetings.

Environment: SQL Server 2008 R2/2012, SSIS (2008 R2/2012), SSRS (2008 R2/2012), SSAS (2008R2/2012)

ETL Developer

Confidential

Responsibilities:

• Analyzing Business rules for REMIT validation, to report trade data to a central trade repository for trades and transactions across multiple product classes and jurisdictions (ACER).
• Created SSIS package to accept data from multiple sources (Flat file, excel, SQL Server, oracle).
• Used SSIS MDM Load to Support unique identification of Trade information across heterogeneous data sources through advanced matching and linking.
• Analyzed business requirements and created SQL Server Stored Procedure/Functions/Views to convert business requirements to technical solutions.
• Query Optimization, tuned some SP’s/Queries/views for excellent performance upgrades like one Job was taking 6.5 hours reduced it to 15 minutes.
• Scheduled and maintained routine jobs, tasks, and alerts using SQL Server Agent.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like Oracle.
• Created/Modified multiple SSIS packages. SSIS packages were used to bring the application data from SQL Server to oracle and to text files as extracts/reports. Also, used SSIS packages to store data on third party FTP sites.
• As Report Writer, I Designed and implemented reports with different layouts using SSRS 2012/2008R2 in both RDBMS and Cube databases.
• Created data Source and Data Source views while developing cubes and defined the dimensions.
• Created several calculated members and Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Involved in creating dynamic partitions and perspectives in SSAS cubes
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Environment: SQL Server 2008 R2/2012, SSIS (2008 R2/2012), SSRS (2008 R2/2012), SSAS (2008R2/2012) Oracle 10/11 PL/SQL, Visual Studio.

Sr. Software Engineer - ETL Developer

Confidential

Responsibilities:

• Developed ETL (SSIS) packages to load data from different sources like csv, excel, MSSQL, Oracle.
• Created scripts to handle automate Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Extensively worked in data integration in developing ETL mappings and scripts using SSIS
• Data migration (import & export - BCP) from Text to SQL Server and vice versa.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and Used MDM concepts when loading data from multiple sources
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.
• Created Business Logic Layer & Data Access Layers to implement the MVC architecture.
• Developed stored procedures, Views and automated SQL, T-SQL scripts for database maintenance, deployment and installation.
• Used SSRS to deliver a variety of interactive and printed reports.
• Creating Ad Hoc and parameterized various Reports using SQL server 2008 Reporting Services.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Used Script task for setting the SQL query on fly using C#/VB in SSIS package

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008 R2, SSIS 2008 R2, MS Visual Studio 2008

Software Engineer

Confidential

Responsibilities:

• Primary role was SQL Server Developer with SSIS and SSAS.
• Created and executed SSIS(.dtsx) packages to extract data from the various data sources such as flat file, excel and from other database such as Oracle and by different data loading operations for many applications which is main purpose of ETL development using SSIS 2005/2008.
• Wrote DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed cubes by defining data sources and data source views and using SQL server analysis services (SSAS).
• Involved in defining Relationships with the measure groups and fact tables.
• Defined Granularity within a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performance of a cube by partitioning it and creating Perspective Cubes.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs and Optimized cubes for better query performance.
• Created reports from cubes by writing MDX queries.
• Writing various Stored Procedures, Triggers, Functions, and Views based on the functionality requirements for various teams and to load data from the OLTP database.
• Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2000/2005/2008 , BIDS 2005/2008, SSAS 2005/2008, SSIS 2005/2008, DTS, MDX, VB, MS Access, Visual Studio, T-SQL, Windows XP