SUMMARY:

• 13 years IT experience in Database Development, Data Analysis, Administration,Design, Development, and Support of MS SQL Server 2008/2008R 2/2012/2014/2017 in Production, Testing and Development
• Proficient in Power BI (Dash Board Reports) with the Advance DAX script, Reporting Services, Crystal Reports, and SSRS Reporting
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill - down, Drill-through and Cascading reports using SSRS.
• Proficient in Creating, configuring workflows designed in MS SQL Server Integration Services (SSIS)
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management
• Maintaining the Log and Audit information in SQL Tables, experience in providing Logging, Error handling by using Event handler for SSIS packages
• Good experience in creating SQL Server Analysis Projects (SSAS) using SQL Server 2005/2008/2012.
• Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes.
• Strong Knowledge of Data Warehousing methodologies including star schemas, snowflakes concepts(Relational Database Management systems)
• Experience in installation, configuration of MS SQL Server 2008, 2008R2, 2012, 2014 and 2017.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2008/2008R 2/2012/2014/2017 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Experience in Database Backup, Recovery, and Disaster Recovery procedures.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SSMS on SQL Server 2005/2008/2008 R2/2012/2014 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star, and Snow Flake Schemas of Data Marts.
• Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.
• Good interpersonal, Analytical and Communication skills
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.

TECHNICAL SKILLS:

Languages: SQL, Web Services - C#

Operating Systems: Windows (XP NT 3.x- 4.0 200 ) and UNIX

Databases: MS SQL Server (2017, 2014, 2012, 2008, 2005, 7.0, 6.5, 6.0), Oracle, MS Access, DTS, DB2

Reporting: Crystal Report, SQL Server 2014 Reporting Services (SSRS), Power BI, Micro Strategy

DBATools: SQL, Erwin, TOAD, PL/SQL, T-SQL, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Salt Lake City, UT

Senior MSBI/Power BI Developer

Responsibilities:

• Designed Power BIdata visualizations utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Designed, deployed, and maintained complex canned reports using Micro Strategies and SQL Server 2014 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries, and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created and maintained Schema Objects (facts, attributes, Hierarchies, Transformations) in MicroStrategy to develop QBR Dashboards.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Cr eated SSIS packages to load data from Excel, Oracle, SQL Servers, Hyperion, CRM, Sources into Data warehouses.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Responsible for scheduling the packages through Sql server agent Jobs and maintaining periodically.
• Created complex queries involving CTE’s, Sub-queries and Joins.
• Debugged the SSIS packages using breakpoints and checkpoints. Used event handlers to keep track of error logs. Also, to trigger emails about the failure using Email task.
• Deployed SSIS Packages and Data Structures from Dev/Staging/Production using Package Configurations
• Building Data marts for financials and operational data using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Manually documented each process and the flow of the package.
• Used various SSIS tasks such as Derived Column, Conditional Split, Multicast, Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).

Environment: SQL Server 2017, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), Power BI, C#, SQL Server Analysis Services (SSAS), Microsoft Visual studio 2017

Confidential, Austin, TX

Senior MSBI Developer

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
• Worked on analysis of the data and develop plan based on the ETL specifications.
• Designed and Implemented plan for the moving data to various destinations.
• Created mappings and workflows as per the business requirement.
• Fine-tuned queries to make the reports run faster, worked on query run time analytics.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.

Environment: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#,SQL Server Analysis Services (SSAS), Microsoft Visual studio 2013

Confidential

ETL/ MSBI Developer

Responsibilities:

• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• SSIS ETL tool was used extract the account-specific data and stored it in a historical Sybase database on monthly basis
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Tuning the Databases, Auditing, Dynamic Management Views
• Database Capacity Planning, Maintenance Plans, Backup, Restore
• Data Modeling, Conceptual/Logical/Physical Modeling
• Create and maintain database for Incident, Problem Tracking, Metrics
• Access SharePoint Server using Web Services to deploy reports on Reporting Server
• Working with Stored Procedures, functions, triggers, Views
• Involved in creating tables, stored procedures, indexes
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation, and impact on system performance. Analyzed potential problems (response delay, locking, server down time) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.
• Creating / Running jobs with SSIS packages
• Design, Creating and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
• Configuring the Database Mail, Mail Operators using SQL Server 2014
• Created different types of reports which involve more number of groupings and multi-value parameters.
• Deploying reports to reports server, proving features for reports to show in PDF format as per the requirement and printing all the reports in a batch process for monthly Statements.
• Ensuring Data Consistency, Analyzing the Data
• Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries
• Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Environment: MS SQL Server- 2014/2012/2008 R2/2008, SSIS, SSAS, SSRS, SQL Profiler, MS Excel, C#.NET, ASP.Net

Confidential

SQL Server Developer/DBA

Responsibilities:

• Working as SQL Server Analyst / ETL Analyst using SQL Server 2012 for CMH Project.
• Source Controlling using IBM Rational Clear Case
• Developing and Management Database for Collateral Management and Hedging
• Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
• Defect tracking and closing by using HP Quality Center
• Design and Deploy SSIS Packages
• Creating SSIS Packages, Configure SSIS packages for different environments using DTS Config
• Produce CSV, utilize CSV files as part of ETL Process
• Used .Net Scripts in SSIS
• Produce XML Files for Tibco (Real Time Data Transfer)
• SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
• Code deployments / configurations/ config management in various environments
• Implement Security, Roles, Logins, and Permissions
• Extract-Transform-Load data into SQL Server 2012 Normalized database from various sources
• Maintain Users / Roles / Permissions, Security
• Scheduling SSIS packages using Autosys, writing JIL Scripts
• Enhance existing applications to meet new business requirements
• L3 Production Support on Rotation basis
• Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
• Capacity Planning DBs, Disk Requirements
• Deploy the code in various environments i.e. DEV/SIT/UAT
• Create and maintain DB Change Log to track the state of the DB in each environment (Dev, Test, UAT, Pre-Prod)

Environment: SQL Server2012, VB.NET, Oracle 11g, Microsoft Visual studio 2013, Clear Case 7.1, Autosys, Share Point, SQL Server 2012 Integration Services, Quality Center 10.0, Compass Point

Confidential

Senior SQL Server Developer

Responsibilities:

• Generate Dash Board Reports for Internal Users using SQL Server 2008 R2 Reporting Services and Dundas Reporting
• Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers
• App Testing in Development, Production, DR
• UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2007
• Deploy various reports on SQL Server 2008 Reporting Server
• Tuning the Databases, Auditing, Dynamic Management Views
• Database Capacity Planning, Maintenance Plans, Backup, Restore
• Data Modeling, Conceptual/Logical/Physical Modeling
• Create and maintain database for Incident, Problem Tracking, Metrics
• Working with SQL, and T-SQL
• Design Reports as of Internal User needs
• Access SharePoint Server using Web Services to deploy reports on Reporting Server
• Working with Stored Procedures, functions, triggers, Views
• Involved in creating tables, stored procedures, indexes
• Creating and Maintain users
• Creating / Running jobs with SSIS packages
• Design, Creating and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
• Configuring the Database Mail, Mail Operators using SQL Server 2005
• Creating Jobs, Job Notifications
• General Day to Day Database Administration
• Importing Data from various sources like DB2, Oracle, Excel, XML
• Ensuring Data Consistency, Analyzing the Data
• Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries
• Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Environment: SQL Server 2008 R2, SharePoint 2010, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services (SSRS), Integration Services (SSIS)

Confidential

SQL Developer

Responsibilities:

• Create and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes, defaults, and rule.
• Set database access privileges for different users and user groups.
• Perform optimization of SQL queries in SQL Server and Sybase system.
• Maintenance of clustered and non-clustered indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Develop DTS Packages to transform data from excel/Access file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Analyzing the Data and Monitor SQL Server activity through profiler.
• Develop backup & restore scripts for SQL Server as needed.
• Monitor server space usage and generate reports.
• Restore Development and UAT databases as and when needed.
• Design and implementation of database maintenance plan
• Performance optimization and normalization of database
• Tuning and optimizing queries and indexes.
• Job, Scheduling, batch, alert, and E-mail notification setting.
• Maintain Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.
• Migrate data using PL/SQL T-SQL and DTS.
• Design and Develop reports in Crystal reports 8.5 for the various in-house systems.

Environment: SQL Server 2008, Windows 2003,2008 Advanced Server, .Net (Vb.Net, C#), Visual Source Safe, Excel Macros (VBA), IIS 6.0 7.0, VB.NET, MS Access, Web services, Active Directory, VBScript