SUMMARY

• About 9+ years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2012,2016 in Production, Testing and Development
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, and preparing High level and Low - level design documents.
• Experience in installation, configuration of MS SQL Server 2012, 2016.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2012/2016 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Knowledge of Relational Database Management systems.
• 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 creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Install and Configure SQL Server 2012, 2016 R2 on Virtual Machines.
• Expert in designing ETL data flows using 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 Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using on SQL Server 2012/2016 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks
• 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.
• Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes.
• Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.

TECHNICAL SKILLS

Languages: VB6, SQL, Web Services - C#, C, C++, Java, Perl

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

Databases: MS SQL Server (2008, 2005, 2000, 7.0, 6.5, 6.0), MS Access, FoxPro, DTS, DB2

Reporting: Crystal Report, SQL Server 2005 Reporting Services (SSRS)

DBA Tools: SQL, Erwin, TOAD, PL/SQL, T-SQL, Web API, Power bi,Tablau.

PROFESSIONAL EXPERIENCE

Confidential, NC

Business Intelligence Developer

Responsibilities:

• Designed, deployed, and maintained complex canned reports using SQL Server 2016 Reporting Services (SSRS).
• Good experience in creating SQL Server Analysis Projects using SQL Server 2012/2016.
• Understand business requirements in Power BI context and design datamodels to transform raw data into meaningful insights.
• Create dashboards and interactive visual reports using Power BI
• Analyzing data and present data through reports that aid decision-making
• Create relationships between data and develop tabular and other multidimensional data models.
• 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 also 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, Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created andmaintained data flow diagrams for existing and future ETL processes.
• 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
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal

Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#,SQL Server Analysis Services (SSAS), Web API, Microsoft Visual studio 2010,IIS, VB.Net, Erwin.

Confidential, NJ

SQL & MSBI Developer

Responsibilities:

• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Chart creation and data documentation explaining algorithms, parameters, models, and relations.
• Design, develop, test, and deploy Power BI scripts and perform detailed analytics
• Perform DAX queries and functions in Power BI visualization tool using numeric, Boolean, date time, string and decimal data type.
• Good knowledge about the Power query, pivot, view, map, Q&A.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in DataExtraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote MDX scripts.
• Used SSIS 2008 to create ETL packages to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, indexes, Triggers.
• Extensively involved in writing database scripts.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS, VB.Net, Erwin, MS Excel, XML, SQL Profiler.

Confidential, Sunrise, FL.

SQL & MSBI Developer

Responsibilities:

• Working as SQL Server Analyst / ETL Analyst using SQL Server 2008 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.
• Used .Net Scripts.
• Produce XML.
• Event Handling, Logging, Batch Checks for data accuracy
• Code deployments / configurations management in various environments
• Implement Security, Roles, Logins, Web API, and Permissions
• Extract-Transform-Load data into SQL Server 2012 Normalized database from various sources
• Maintain Users / Roles / Permissions, Security
• Scheduling SSIS packages using Autopsy’s, 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.

Confidential

SQL & MSBI Developer

Responsibilities:

• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
• Experience in Object Oriented Analysis concept implementation, design and programming technical skills.
• Create and maintain DB Change Log to track the state of the DB in each environment(Dev, Test, UAT, Pre-Prod)
• Monitoring project progress and status using MS Project, providing high level estimates of efforts for analysis, implementation and support of application, estimating delivery schedule and resource allocation.
• Identified and documented business needs and created detailed Use Cases using UM and collaborated with production team to identify and map detailed existing processes, identify system gaps and developed functional requirements documentation (FRD) that supported overall strategy, goals and objectives.
• Completeness of requirements in different SDLC stages, and managed change requests.
• Creating SSIS Packages, Configure SSIS packages for different environments.
• Produce CSV, utilize CSV files as part of ETL Process.
• Experience in Data Modeling using Erwin Design Tool.
• Knowledge of Networking Concepts and Object Modeling Technology.
• Good interpersonal, Analytical and Communication skills.

Environment: SQL Server 2008 R2, 2012, VB.NET, Oracle 10g, Web API, Microsoft Visual studio 2010, Clear Case 7.1, autopsy’s, Share Point, SQL Server 2012 Integration Services, Quality Center 10.0, Compass Point.