SUMMARY:

• Over 5 years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2016,2014,2008, 2005, 2000 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, prepare High level and Low level design documents.
• Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2008R2/2012/2014 and 2016.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/ /2014/2016 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• 6+ years of experience in SQL Server MSBI Databases and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2016/2014/2012/2008 R2/2008/2005, T - SQL, SSRS, SSIS and SSAS.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• 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.
• Expertise in SQL Server 2008 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• 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 2005, 2008, 2008R2 on Virtual Machines.
• 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.
• 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/2012 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 using DBCC Utilities.
• Created custom TFS reports based on requirements from different business teams.
• 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.
• Setup various Team Projects into different Team Project Collections in TFS 2010 & TFS 2012
• Analyzed, defined, and developed build process improvements using TFS.
• Create reports in Power BI preview portal utilizing the SSAS Tabular.
• Good experience in creating SQL Server Analysis Projects (SSAS) using SQL Server 2000/2005/2008 R 2/2014/2016.
• 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.
• Experience in Data Modeling using Erwin Design Tool.
• Good interpersonal, Analytical and Communication skills.
• 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.

SKILL:

Languages: VB.Net, SQL, Web Services - C#, C, C++, Java, Perl

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

Databases: MS SQL Server (2016/2014,2008 R2, 2005, 2000, 7.0, 6.5, 6.0), MS Access, DTS, DB2, SQL Azure,TFS 2013, TFS2012, TFS 2010.

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

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

EXPERIENCE:

Confidential, Bellevue, WA

SQL developer/ Data Analyst

Responsibilities:

• Defined Breadth-first search (BFS) algorithm using Complex SQL Queries, Stored Procedures, Functions, Views to determine the dependency tree structure
• Worked on SQL Azure
• Defined the structure of Database independently and created various stored procedures as per the requirements.
• Created SQL agent jobs for Running SSIS Packages on scheduled basis
• Created Reports, Dashboard for Share Point Online Data using SSRS, Excel, Power BI
• Created and maintained data flow diagrams for existing and future ETL processes
• Deployed SSIS packages to SQL Azure
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal.
• Deployed OLAP cubes supporting business intelligence and mining: SSIS data mart population and MDX querying.
• Created reports by dragging data from cube and wrote MDX scripts.
• Created custom TFS reports based on requirements from different business teams.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, SQL, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Configured TFS builds with continuous integration and build notifications.
• Created custom TFS reports based on requirements from different business teams.
• Analyzed large amount of Data using Excel Functions such as V lookup, Macros.
• Optimized SQL agent Jobs to minimize its processing time
• Created Web Application using Vb.Net to show Dashboard which takes input at run time from end-user.
• Helped on various different issues to merge data from various excels using SSIS based on the requirements.

Environment: SQL Server 2012, BI 2012, SQL Server 2014,2016,ETL, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#, SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010, VB.Net, SQL Azure,TFS,Share Point Online, Visual Studio 2013.

Confidential, Milwaukee, WI

Sr. SQL Server/SSIS SSRS Developer

Responsibilities:

• Involved in new BANNER DB design and created ETL using SSIS from STUDENT legacy systems.
• Created ETL for all student systems and front-end applications like Admissions, Account Receivable, and Financial Aid etc.
• Designed ETL sync bridges for Student, Faculty, Building and Department data using T-SQL and SSIS for supporting internal applications.
• Created and modified already existing stored procedures, triggers, views and indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Extensive experience in using SSIS transformations like Lookup, Data conversion, Aggregate, condition split.
• Hands on experience with Variable, Script Task and Execute SQL Task in SSIS using VB Script and T SQL.
• Experience in counters, error handling, and event handlers, re-running failed SSIS packages using check points and scripting with Active-X and VB.Net in SSIS.
• Deployed OLAP cubes supporting business intelligence and mining: SSIS data mart population and MDX querying.
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used execution plan, SQL profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of the database.
• Implemented a combination of Agile & Waterfall development methodologies for both on shore and off shore development teams and performed the role of Scrum Master for the Agile projects.
• Installed a development TFS environment, where new services and tools could be tested before installing them onto the production server.
• Involved in DB application security using ADO.NET and C#.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Created and managed the databases in development environment.

Environment: MS SQL Server 2012,2014 Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, MDX, TFSProClarity, ADO.Net, Query Analyzer, Data Mart, ETL, MS Office 2010

Confidential, Houston, TX

MS SQL Server Developer/BI Developer/ SSRS Developer

Responsibilities:

• 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 Data Extraction, 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 report (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote MDX scripts.
• Used SSIS 2008 to create ETL packages (dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Design OLAP databases, SQL Queries, SSIS Packages, Jobs, and TSQL Stored Procedures, Views and Functions.
• Created custom TFS reports based on requirements from different business teams.
• 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.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• 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 2012, 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.