SUMMARY

• Highly accomplished, deeply driven database developer and administrator with an extremely successful 7+ Years track record. Proven ability to succeed in all facets of SQL Server development, testing, implementation, migration, configuration, administration, optimization, maintenance, and documentation repeated success mastering complex technical and business environments. Thrives in fast - paced environments where consistently meet ongoing and overlapping deadlines.
• Deft in database designing skills and experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2016/2014/2012/ 2008 R2/2005. Experience in writing T-SQL (DDL and DML) scripts in all MS SQL server environments.
• Handles multiple assignments simultaneously and successfully identify and coordinate key deliverables with stakeholders in cross-functional groups. Passions include ensuring data quality, scalability, performance, integrity and security as well as standards development and process improvement
• Technically and logically very sound in T-SQL Programming, SSIS, SSRS, SSAS, Data warehousing, Business Intelligence etc.
• Highly self-motivated, able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines. I have always been recognized as a best programmer within the organization.
• Highly proficient in Tuning SQL queries and improving the query performance. Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Professional in creating and understanding Schemas Such as Star Schema, Snowflake Schema, Galaxy Schema.
• Expertise in Migrating Reports from SSRS to Power BI.
• Good in code migration, database change management and data management through the various stages of the development life cycle.
• Worked on MS SQL Server Query Engine, Execution Plan, Indexing and other performance tuning techniques.
• Strong Knowledge on creating SSIS packages using control flow tasks like Execute SQL Task, FTP, For Loop, For-each-Loop, Execute Package task, etc. and data flow tasks like Derived column, Slowly Changing Dimension, Look up, Conditional Split, OLEDB command, etc. Also, different types of sources and destinations like Oracle source, SQL, Excel, flat file, Raw, etc.
• Expert in creating and developing Power BI Dashboards and Reports in to rich look and Stunning Visualizations.
• Knowledge in all types of Database migrations with all the versions of SQL Server.
• Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
• Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.
• Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans.
• Experience in SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages, configuring Checkpoints, troubleshooting, debuggingthe data flow by using Data viewers, awareness on Transactions concepts to roll back the data of SSIS packages in case of failure.
• Experience in developing Oracle scripts, Functions and Packages using Oracle SQL developer.
• Implementing Logging features to the existing packages to track the record counts, package status by storing it in logging DB tables with their associated column values.
• Familiar with Complex Reporting Requirements like Dashboard, Matrix, Cascading Summary, Sub reports and pass through parameters from main report to the sub reports.
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

TECHNICAL SKILLS

DATABASES: MSSQL Server 2000/ 2005/2008/2012/2014/2016 , Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007 , MYSQL.

PROGRAMMING: T-SQL, PL/SQL, R, Python

WEB TECHNOLOGIES: Active X, Internet Information Services (IIS).

ETL TOOLS: DTS, SQL Server Integration Services (SSIS).

OLAP TOOLS: SQL Server Analysis Services (SSAS).

REPORTINGTOOLS: SQL, SQL ServerIntegrationServices(SSIS)SQLServerReportingServices(SSRS),Microsoft Power BI (Power Pivot, Power View, Power Query, Power Map), SQL Server Analytical Services (SSAS), Visual Studio, BIDS.

VERSION CONTROL: Team foundation Server (TFS), Visual Source Safe (VSS),SVN

OPERATING SYSTEMS: Windows XP/2007/2010

DATAMODELLING TOOLS: Erwin 4.x/7.x, MS Visio 2000/2003

AGILE TOOLS: Jama 4.0 and JIRA

SQL SERVER TOOLS: SSMS, Enterprise Manager, SSDT, Query Analyzer, Profiler, Performance Monitor

PROFESSIONAL EXPERIENCE

Confidential

MSBI/SSIS/SSRS Developer

Responsibilities:

• Actively participated in interacting with users, team lead, DBA’s and technical manager to fully understand the Application/System and Business requirements.
• Assist data modelers in designing of dimensional model for Star schema.
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query and Power BI.
• Involved in database Schema design and development.
• Created power shell scripts to transfer files from one folder to another and rename the files.
• Experienced in creating Standard and data-driven subscriptions with different delivery extensions like Windows File Share, E-mail and SharePoint Library.
• Worked in Agile Methodology.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS.
• Created several SSIS packages for performing ETL (Extract, Transform and Load) operations from OLTP to OLTP and OLAP systems.
• Involved in creating measure groups using different fact tables and created calculated members, Advanced KPI’s and named set in SSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the database.
• Migrating Oracle database source based SSRS reports to SQL source-based by changing the Oracle source code to SQL code compatible.
• Used Phabricator tool to verify the changes between existing script which is in source control to the script which I developed.
• Used JIRA project management system to track the enhancements and developments on a daily basis.
• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix and sub reports.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014/2016.
• Expertise in building and migration of various DTS packages.
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.

Environment: Microsoft SQL Server 2005/2008/2012/2014/2016 , SQLServer Reporting Services (SSRS), SQLServer Integration Services (SSIS), Power BI Desktop, SharePoint, Visual Studio2015,SQLServer Analysis Services (SSAS), JIRA,T-SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2012, MS Excel, Excess, Windows 8.

Confidential

SQL Developer

Responsibilities:

• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files
• Created different kind of reports like List reports, cross tab reports, charts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports as well as managed the subscription of the reports (Standard and Data-Driven Subscriptions).
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Creating & publishing the packages according to the business requirements and also involved in the scheduling and deployment of the reports.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created Staging database for temporary processing of data, consolidating data and loading database using Integration Services.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Involved in the Unit Testing of the reports and preparing the Test cases.
• Used GitHub for version control, source control and reporting.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, designed complex reports from different data sources such as SQL Database and Cubes.
• Worked on creating and maintaining SSAS Databases which includes creating new Cubes, Dimensions, and Calculated Measures, Partitioning and building MDX queries.
• Utilized Microsoft team foundation server (TFS) to manage the teams software development lifecycle.

Environment: SQL Server 2014/2012/2008 R2/2008/2005, SSIS, SSAS, MS SQL Server 2016 Management Studio, T-SQL, MDX, Power BI, Visual Studio 2013, GitHub and Microsoft Excel.

Confidential, St Petersburg, FL

MSBI/SQL Server Developer

Responsibilities:

• Gather requirements and design of data warehouse and data mart entities·
• Built Data marts (Fact and Dimension tables) from the warehouse tables.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Applied various Data flow and Control flow transformations to meet the business needs
• Designed and deployed Reports with Drop Down menu option and Linked reports
• Integrated Reporting Services with Microsoft Office SharePoint Services for central delivery and management of business insight.
• Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.
• Involved in Debugging reports on the production and UAT servers by modifying the RDL files using XML.
• Developed complex Stored Procedures and Views to generate various reports using Excel and SSRS.
• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, dashboards, and scorecards.
• Formatted the reports using the Global variables and expressions.
• Constructed Cubes based on data volumes mostly adhering to Star Schema
• Defined Relationships Between Dimensions and Measure Groups
• Solved issues related to deadlocks using SQL profiler deadlock graph by adding traces
• Created and Configured Dimensions, Attributes and Hierarchies
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Generated test cases to meet the functionalities deliverables in the project documentation and specifications.
• Experienced in implementation of strong referential integrity and auditing by the use oftriggers.
• Understanding the OLAP processing for changing and maintaining the azure Data Warehouse, Optimizing Dimensions and adding new Aggregations to the Cube.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Defined check constraints, rules, indexes and views based on business requirements.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases.
• Monitored the performance of Database objects using Performance Monitor.
• Experience in disaster recovery with Backup, Restore Strategies, and scheduling those backups on development server.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
• Interacted with business users to refine the requirements for the end to end process flow.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: SQL Server 2012/2008, SSRS, SSIS, SSAS, T-SQL, Visual studio 2008/2012, Windows Server 2008, HTML, Visio, UML, MS Project, Windows 2003 Server.

Confidential, Phoenix, AZ

MSBI/SSIS/SSRS Developer

Responsibilities:

• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2010.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Participated actively on Clients Calls, meetings with Project Manager and delivery head to discuss and produce alternatives of problems.
• Involved in evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships.
• Responsible for implementing the ETL solutions using SQL Server Integration Services.
• Created UNIX shell scripts, JCL mainframe procedures and processes to extract data from various sources such as DB2 and Oracle.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
• Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
• Involved in creation of dimensions using Star, Snow Flake schemas.
• Created several MDX queries according to Business requirements.
• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task, FTP Task, Script Task, Send Mail Task and Data Flow Task.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived column, look up, Conditional Split, Aggregate, Union all, Row Count and merge join transformations.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.Collecting requirements from business users and transforming them into logical and physical database designs.
• Responsible for automation of maintenance jobs, locks and index configurations.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Wrote custom T-SQL stored procedures, indexes, cursor, functions and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: SQL Server 2012/2010/2008 , SSIS, SSRS, SSAS, OLAP, OLTP, XML, Windows 2000/2003 Server, Erwin, Performance Point Server 2007.

Confidential

SQL Developer

Responsibilities:

• Developed backup and recovery plans based on OLTP load and server down time.
• Created T-SQL queries used in PIVOT/UPIVOT, CTE.
• Gathered requirements and created requirement specification documents for all reports.
• Developed documentation to reflect current design ETL processes.
• Worked closely with Business Users in identifying the gaps between existing code and the business requirements in the ETL projects.
• Database Design, Optimization of queries and Database, Performance Tuning using Index Wizard, SQL Profiler and Query Analyzer. Installed SQL Server Desktop Database and Standard Database.
• Created Stored Procedures, User Defined Functions, and Triggers to work consistently with the dynamic databases.
• Investigating and fixing the root cause of the problems that are encountered on in production environments on day to day basis.
• Wrote and maintained database documentation, including data standards, procedures, definitions for data dictionary and logical and physical models of the database.
• Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• 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.
• Created Linked Servers and send data across multiple Servers.
• Created Functions and Stored Procedures and Views.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.
• Involved in analyzing business requirements and design documents.
• Involved in interacting with business people on daily basis for better understanding and implementation.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)