SUMMARY

• 8+ Years of IT experience in Database Development, Administration, Business Intelligence Solutions in SQL SSIS, SSRS, SSAS, System Analysis, Design, Development, implementation and support of MS SQL Server 2005/2008//2008 R2/2012,2014, 2016
• Experience in working in Agile - Scrum environment with all phases of Software Development Life Cycle in different environments like Banking, Natural Gas, Health Care, Engineering and Information Technology
• Experience in Data Analysis for large and complex system including in HealthCare, Aviation, Banking etc.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and De-normalization as required of the large-scale OLTP/OLAP databases using Erwin, Visio
• In-depth knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables
• Proficient in SQL Server, Azure, PL/SQL and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, Flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union
• Experience in Performance Tuning in SSIS Packages by using Sorting, Design Alternatives and by Measuring Performance
• Experience in Error Handling by using event handlers and provide custom logging for SSIS packages
• Experience in handling Heterogeneous Data Sources and databases APS, EDW, Oracle, IBM DB2, CSV and XML files using SSIS
• Experience in creating Multidimensional Cubes and Tabular Models, shared dimension tables, measures, hierarchies, levels and experience in implementing KPI’s, Aggregation, Partitions, Perspectives, Hierarchies and Calculated Members using SQL server Analysis Server (SSAS)
• Experienced in creating row level security for SSAS Tabular Models and their deployment and worked on DAX and MDX in SSAS in tabular and multidimensional cubes
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2012/2014/2016
• Writing Ad-hoc querybatchesand stored procedures to assist in analyzing, cleaning, checking processingdata to ensure the maximum possible integrity and quality
• Experienced in working with various data profiling software including Information Analyzer, Visual Studio.
• Experience in creating Jobs, Alerts, SQL Server Agent, and Scheduled SSIS Packages
• Experience in creating Power BI Visualizations, Dashboards and reports used Power View and Power Map for visualization and versatile in BIDS (Business Intelligence Development Studio), QlikView, Tableau, Query Analyzer, Profiler, SQL Server Management
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL), Power Builder, SharePoint, UNIX shell Scripting
• Experience with Power BI for building dashboards, graphs, reports using Power Pivot
• Experience with .NET framework using ASP.NET, C#, XML, IIS and ADO.NET database connectivity
• Proficient in Database performance optimization, debugging, Troubleshooting and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore Experience with different scheduling tools like SQL Agent, ActiveBatch, AutoSys, Tidal Scheduler
• Proficient with automated Testing Tools - Win Runner, Load Runner and QTP for testing Client /Server and Web based applications
• Excellent Communication, Analytical and Inter Personal Skills and ability to learn new concepts and supported 24/7 on call in production and development environment

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g/10g/9i/8i, Teradata V2R5 and MS Access 2003/2000/97

Business Intelligence Tools: SQL Server integration Services(SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio(SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL Server Enterprise Manager, Microsoft management Console, Data Transformation Services (DTS), DTSX, Team Foundation Server(TFS), SQL Server Analysis Services (SSAS), OLTP, OLAP, Power BI

Reporting Tools: Microsoft SQL Server Reporting Services(SSRS)

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003

Programming Languages: HTML, C#.Net, VB.Net, T-SQL, SQL, Python, PL/SQL, Dynamic SQL, shell scripting

Design Technologies/Tools: Erwin r7/r4/r3.5, MS Visio 2007, SQL Profiler, SQL * Loader

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

MS BI/SSIS/SSAS developer

Responsibilities:

• Involved in the working and interacting with the business units for the requirement gathering, involved in writing the data dictionary and worked under the agile environment for defining the objectives and bi-weekly task.
• Worked on the data migration from Oracle DB to SQL Server by developing SSIS packages for the migration using various stored procedure and CTE’s.
• Worked on building the data marts i.e. identifying the Dimension and fact, constructing tables and developed logical and physical models.
• Developed ETL packages for transforming the data and loading into the Enterprise Data Warehouse(EDW) and used high performance ETL codes for loading the data in EDW.
• Developed ETL mappings in PL/SQL through packages, triggers, views, and user defined function.
• Worked with Meta-Data Driven SSIS Packages to pull the data from various sources and load to Data marts
• Migrated 20 SSIS Packages from SQL Server 2012 to SQL Server 2016
• Worked on building SSIS packages, deploying, and executing the packages in all environments and scheduling the packages in Production and
• Worked on Change Data Capture (CDC) packages for capturing the data changes from sources and updating data warehouse
• Created and maintained the SSAS databases in Tabular cube models in SQL Server Analysis Server and created roles and row level security for tabular cube models
• Worked mainly on Tabular models for SSAS using the DAX Queries for creating hierarchies, levels, measures, and calculated columns as per business requirements
• Built MDX queries and Data Mining Expression(DMX) queries for Analysis Service SSAS.
• Created custom calculations in Data Analysis Expressions (DAX) in PowerPivot and SSAS
• Worked on creating Power BI reports preview portal via Analysis connector with SSAS tabular cube
• Worked with Power BI for creating Power BI reports and dashboards and created custom visualizations and published them to power BI service
• Worked on creating the hierarchies using visualizations like bar chart, line, forecast, and created reports using clustered column, Tree map chart, KPI’s and pie charts in Power BI
• Worked on creating and scheduling jobs for the stored procedures and SSIS packages and tabular using SQL server Job Agent and implemented efficient error handling techniques.
• Worked on resolving SQL server related issues and database performance in case of deadlock situations by removing obsolete tables, procedures.

Environment: MS SQL Server 2012/2016, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MS SQL Server 2012/2016 Management Studio, Visual Studio 2012/2016, Oracle DB, SQLAgent, C#.NET, Power BI, T-SQL, PL/SQL, IBM Maximo, ERP, Windows 2008/XP, Windows

Confidential, Dallas, TX

MS BI/SSIS/SSAS/SSRS Power BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle process from gathering requirements and creating the work flow from source to destination systems. Worked with team of developers, QA analyst and technical team in Agile environment for defining the objectives
• Worked on complete modeling (end -to- end) of DW and building Data marts (Fact and Dimension tables) creating E-R diagrams from the legacy Data warehouse (DW) tables. Worked on the data modeling (Logical and Physical modeling) for building cubes and schema with E-R Win.
• Designed and createdSSIS Packagesto import and export data fromvarious data sources like Flat files, OLE Data bases, Excel, SQL, Azure and Oracle Servers.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval and conducted data import and export operations using the DTS wizard.
• Involved in implementing BI strategy and road map for the project and Worked on SSIS in Development and Production environments, building packages, deploying, and execution. Worked with Event Handlers and Error Handling in SSIS packages.
• Used different Transformations in SSIS Dataflow like Merge Join Multicast, and in Control Flow task like Merge Join, FTP, Script Merge and SQL script for creating Packages
• Used SSIS Automation for creating reports from database on to excel and migrating the SSIS packages from SQL Server 2008 to SQL 2014.
• Worked on Performance Tuning in SSIS package using Buffer transformations like Row and blocking transformations and worked on Optimizing queries
• Designed inTabular Data warehouse and DAX operations forSQL Server Analysis Server (SSAS)
• Data warehouse and client server technologies, exclusively involved in Analyzing / building TeradataEDW using TeradataETL utilities
• Designed shared dimension tables, measure, hierarchies, Cubes, and levels on SQL Server Analysis Server
• Involved in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Multi-Dimensional Expression (MDX) for OLAP databases.
• Worked on implementation of Row level security for different users in cubes using MDX expression using SQL SSAS. Created custom columns in Tabular module using DAX in Microsoft Excel PowerPivot
• Created different kind of Report templates, bar graphs and pie charts based on the fiscal year Data for analysis and created reports using SQL Server Reporting Services (SSRS).
• Developed Ad-Hoc Reports and Tabular reports using SSRS Report Designer and used Power BI to connect with SSAS and build reports in drill mode using financial tables, cross tabs and charts
• Developed different reports SSRS reports and Crystal reports as per business requirements and worked with Report Manager for Deploying, Scheduling, and setting the security setting of the developed Reports.
• Worked with Power BI for creating and configuring dashboards, graphs and reports for analysis from different data base sources like SQL, Azure, Sales Force, SSAS, Oracle, and Excel, CSV, text files
• Worked with Power BI for Creating and deploying inter-active Dashboards or Analysis using excel Power Pivot and Worked on QlikView reports and used them for developing the dashboards.
• Created custom visualizations and dashboards using Power BI desktop and published them to Power BI service and worked on developing Ad-hoc reports, KPI’S for analysis teams using Power BI
• Deployed the Power BI reports using enterprise gateway and SSAS connector on AzureVM
• Involved in periodic checking of databases for consistency and data integrity using DBCC commands
• Involved in checking and maintaining and resolving issues with SQL server Database blocking
• Developed T-SQL Queries and PL/SQL Stored Procedures, Triggers, Views and Adding/Changing Tables for data load and transformation
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views

Environment: MS SQL Server 2016/2014/2012/2008 R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), SQL Server Analysis Server (SSAS, T-SQL, PLSQL, C#.NET, UNIX, T SQL, XML, Erwin r7, Power BI, QlikView, DTS, HTML, Team Foundation Server(TFS), MS Excel

Confidential, Minneapolis

Sr SQL ETL /SSIS/SSAS/Reports Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams and designed Logical and Physical Data Models with Erwin r4
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Worked on data migration from Oracle DB to SQL server and Worked with Microsoft Azure to build and deploy services and wrote variousT-SQLqueries, CTE’s,and Stored Proceduresand used them to build SSIS packages
• Developed many ETL’s packages to transform and load the data into new Enterprise Data Warehouse(EDW)
• Involved in designing the physical databasemodels on SQL Server 2012 R2 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing Constraints and Triggers for data integrity in development database and Created User defined functions for making business logics more secure
• Created SSIS Packages to populate data from various data sources Like Flat Files, Excel Files, SAP systems, OLEDB to SQL Server and configured SSIS packages using Package Configuration wizard to allow packages run on different environments
• Worked with Meta-Data Driven SSIS Packages to pull the data from various Sources and load to Data mart
• Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012
• Involved in creating and maintaining SSAS databases in Tabularand Multidimensional cube models inSQL server Analysis Server using BI semantic Model (BISM). Built MDX and DAX Queries using SQL Server Analysis Server
• Worked mainly on Tabular models for SSAS using the DAX Queries for creating hierarchies, levels, measures, and calculated columns as per business requirements
• Created custom calculations in Data Analysis Expressions (DAX) in PowerPivot and SSAS
• Developed a Parameterized reports, Tabular Reports, Ad-Hoc Reports using SSRS Report Designer
• Created various kinds of reports using crystal reports including Drill Down, Form, standard, Cross Tab, OLAP report
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder
• Developed Complex SSRS Reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries and deployed them as per schedules by Auto-sys
• Worked on designing different complex dashboards using QlikView and used QlikView Publisher for reload and distribution task
• Developed complex SQL Queries and crystal reports formulae for addressing the problems faced by business users, and scheduled the crystal reports in Business Object environment
• Developed ETL mappings in PL/SQL through packages, triggers, views, and user defined functions
• Conducted data import and export operations using the DTS wizard. Scheduled the Main Stored procedure on a schedule basis by creating a SQL Server Job Agent and implemented efficient error handling techniques
• Worked on HIPAA standards transaction of Enrollments/disenrollment of health Plan (834) and Claim Payment (835). Worked on the premium and claim payments data for developing detailed reports for Fiscal year.
• Monitored the Performance and reverse engineered causes and did the Performance tuning of the database objects and server to ensure efficient data retrieval and used the Query optimization of the Database as required by the application
• Worked on high performance PL/SQL ETL codes for loading data into the data warehouse
• Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa
• Responsible for Drafting, Documentation for describing the Metadata and writing technical guide

Environment: MS SQL Server 2008 R2/2008/2005, SQL Server Integration Services (SSIS), SSAS, SSRS, crystal reports, MS SQL Server 2008 Management Studio, C#.NET, HTML, UNIX shell scripting, ASP.NET, Azure, T-SQL, PL/SQL, QlikView Publisher, Netezza, DTS, Clarity reports, Windows 2008/XP, Erwin r4, STARS, Windows

Confidential, Torrance, CA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in interacting with the business users and gathering the requirements for the data warehouse.
• Worked on converting the business requirement into technical specifications and created the facts and dimensions in E-R studio
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Managed Package Configurations through system variables and SQL server Configuration to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Worked on Scope script COSMOS query language
• CreatedSSISPackages usingSSIS Designerto export heterogeneous data fromOLE DB Source (Oracle), Excel Spread sheetand loaded the data into target data destination by using various transformations inSQLServer Integration Services (SSIS).
• MigratedDTS packagestoSQLServer Integration Services (SSIS)and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Created multiple reports (SSRS) in Drill mode using tables, financial income tables, crosses tabs and charts.
• Built MDX queries and Data Mining Expression (DMX) queries forAnalysis Services & Reporting Services.
• Add only in SSAS requirement and experience in working creating Multidimensional cubes and Tabular Models usingSSAS.
• Developingstored procedures,triggers, views,and adding/changing tables using PL/SQL for data load and transformation, and data extraction.
• Created the SSAS 2012 Multidimensional and Tabular model reports from Datawarehouse using SSDT
• Worked extensively on Teradata tools like SQL Assistant and TeradataView Point and worked with Data Stage ETL tool with Teradata as backend
• Design, deployment, and maintenance of variousSSRSReports like Parameterizedand cascading parameterized reports
• UsedSQLServer Profilerto trace the slow running queries and tried toOptimize T-SQL andSQLqueries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases includingre-indexing, updating statistics,recompilingstored procedures and performing other maintenance tasks.
• Provided24/7productionsupportfor the production database and to the code deployed into the production environment.

Environment: SQLServer 2008/2005 Enterprise Edition,T-SQL, andSQLServer 2008 Manager Studio, E-R studio-SQL, PL/SQL, SSIS, SSRS, SSASSQLAnalyser and Enterprise Manager, Visual basic andSQLAgent.

Confidential

MS SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005/2008.
• Worked with development team in creating a web application using MySQL database
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Developed Informatica mapping reusable transformation. Worked for data integration techniques in data warehousing using Informatica powercenter
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Wrote several Stored Procedures for managed PostgreSQL production and implementing high availability or backup recovery
• Created and managed new security accounts. Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Assisted with various ad hoc query requests.
• Worked on testing and automation by using shell scripting
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005/2008, MySQL, T-SQL, Informatica, PostgreSQL, DTS Designer, HTML, MS-Office, MS-Excel, VSS

Confidential

SQL Developer/ DBA

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
• Responsible for MS SQL Server Installation and configuration, applied service packs and hot fix.
• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Wrote User Defined Functions and Stored Procedures, and defined Roles and Privileges to control access to database.
• Created Triggers to enforce data and referential integrity.
• Created Constraints, Defaults, Views and Indexes.
• Created Triggers to enforce data and referential integrity.
• Developed Master/Detail Reports and Tabular reports using Crystal Reports

Environment: SQL Server 2000, Windows NT 4.0, Crystal Reports 9.0.

Confidential

Application Developer

Responsibilities:

• Prepared test specifications and checklists for code review.
• Worked on modifying Use case and other UML diagrams in Visual Studio.
• Assisted in preparing Test plan, Entry/ Exit Criteria for Test Plan.
• Prepared various Test Cases and executed them in timely manner.
• Performed Negative and Positive tests manually.
• Conducted Integration, Module and Backend Testing.
• Written SQL queries for back end testing for DB2.
• Performed Manual Testing for the entire web application.
• Conducted Regression testing for each build of application.
• Performed System and Compatibility tests.
• Responsible for Documentation of Test Results and Issues.
• Regularly interacted with developers to discuss various problems and issues.
• Involved partially in the User acceptance testing (UAT).

Environment: .Net, DB2, SQL, JCL, CICS, MS Visio, Visual Studio, MS Word, MS Excel, Power point.