PROFESSIONAL SUMMARY:

• Around 8 years of extensive experience in database activities like Data Modeling, Database Design and Development, Coding, Implementation, Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication on Windows environment.
• Experience in Analysis, Design, Documentation, Development, Testing and Implementation in Client/Server applications using Microsoft SQL Server 2008/2012/2014/2016 and BI Suite for various Business, Finance and Health care domains.
• Expertise in Relational Database Management Systems using SQL Server 2005/2008/2012/2014/2016.
• Proficient in Database Programming and Development using SQL Server and good experience in creating T - SQL (DDL, DML), Triggers, Views, User Defined Functions and Complex Stored Procedures.
• Expertise in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2012/2014/2016 with Import/Export data, Bulk insert and BCP.
• Experience in SQL Server OLAP database development including KPIs, Data Mining, working with slowly changing dimensions (SCD).
• Expert in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Good Knowledge in Microsoft SharePoint Server and IIS web server to produce sites for file sharing, web databases and web publishing.
• Supported team in resolving SQL Reporting services(SSRS) and T-SQL related issues and proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Sub reports and formatting them.
• Worked with Power BI gateway to schedule daily job to refresh data
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server
• Managed relationship between Power BI using star schema.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports
• Expert in using different Recovery Models simple, full and bulk-logged depending on availability of database.
• Proficient in creating logical and physical data models using Erwin data modeling tool.
• Managed full life cycle Custom Development for several business applications from inception to completion.
• Ability to quickly learn and adapt to the rapidly changing Internet economy.
• Been involved in Agile practices such as daily scrum and sprint planning

TECHNICAL SKILLS:

MS SQL Server 2016,2014,2012,2008,2005,2000,Microsoft Visual Studio 2010, Microsoft Integration services 2013/2010/2008/2005 , Windows XP, MS-Access, Oracle8.i, Oracle 9.i, T-SQL, XML, MS Visual studio 2005, ERWIN 7.1, Microsoft SharePoint, Microsoft Visio 2003, Report Builder 3.0

EXPERIENCE:

Confidential, Bellevue, WA

Sr. MS SQL SERVER/SSIS/SSRS Developer

Environment: MS SQL Server 2008/2014/2016 , SQL Server Reporting Services 2008/2014/2016 , SQL Server Integration Services 2008/2014/2016 , BI, MS Excel, Report Builder 3.0

Responsibilities:

• Setting up SSIS 2014 framework for building ETL packages.
• Build and maintain database objects like tables, views, indexes, triggers etc.
• Create ETL Packages and Set up Parameters to call Child package from a parent package when a file is added to queue. Using SSIS Load multiple file formats into databases.
• Configuring for SSIS using table variables and setup logging in SSISDB.
• Setup SSRS reports in SQL Server 2014 and gave access to users according to groups.
• Created and troubleshoot-ed multiple SSRS reports for different clients of the company for their census data and monthly EBS data.
• Developing ETL Process based on BI Requirements
• Created ad-hoc reports using report builder 3.0 in SSRS report manager.
• Used Microsoft TFS for version control of code.
• Provided support for access, training, and usage of POWER BI dashboards / reports / visualizations.
• Setup Interfaces to automate and generate reports to User accessible locations on a daily basis.
• Worked with project manager and technical leads for resolution of technical issues. Used variables to call connection managers in the packages.
• Gathering requirements from users and creating code design documents.
• Working with higher level management to acquire requirements.
• Automating and Daily monitoring of jobs, figuring out errors and solving any Blocking issues that arise.
• Working on tight schedules for deliverables and delivering the solution.
• Created Indexes, both clustered and non-clustered for improving in performance.

Confidential, Dallas, TX

Sr. MS SQL SERVER/SSIS/SSRS Developer

Environment: MS SQL Server 2008/2014/2016 , SQL Server Reporting Services 2008/2014/2016 , SQL Server Integration Services 2008/2014/2016 , MS Excel, Oracle 11g, Report Builder 3.0

Responsibilities:

• Gathering requirements from users and creating code design documents.
• Working with higher level management to acquire requirements.
• Creating SSRS Reports which are parameterized.
• Responsible for managing BI environment, which includes Data Model, Data Sources, ETL tools, target Data warehouse, Data marts, OLAP analysis and Reporting tools.
• Creating data driven subscriptions to the SSRS reports.
• Work with rightfax to fax the reports developed using SSRS to the facilities.
• Sent response file for file loads as SSRS reports and gave users access to specific reports.
• Created .NET code to generate control files which are used to send faxes through right fax.
• Worked on loading of Authorizations into FACETS schema in Oracle databases.
• Created SSIS Packages to perform ETL operations on files received from third party vendors to load into FACETS schema.
• Worked on logging, scheduling, configuring SSIS packages.
• Worked on generating response files to be sent back to different third party vendors for the input files received.
• Worked on loading Flat Files, Excel Files into tables.
• Created database objects like tables, procedures, indexes and functions in both Oracle and SQL Server databases.
• Worked on fine tuning queries using execution plans.
• Created SSIS Configurations using XML Configuration and OLEDB Configuration.
• Scheduled jobs using TIDAL. Deployed SSIS Packages and Config’s using in house built tools to QA and Prod environments.
• Worked with JIRA to monitor tasks assigned and completed.
• Deployment of reports and working on production fixes for them.
• Working on tight schedules for deliverables and delivering the solution.

Confidential , Philadelphia, PA

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services, T-SQL, SQL Server Integration Services, MS Access, MS Excel, MS sharepoint services

Responsibilities:

• Created Star schema dimensional modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports from ODS.
• Developed SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database and OLAP as SSAS 2008 source
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008(SSRS)
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports
• Configured the report server and generated the report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.

Confidential, Cypress, CA

MS SQL Server/SSRS/ SSIS Developer

Environment: MS SQL Server 2005/2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Responsibilities:

• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
• Created business process diagrams defining current business processes.
• Generated reports using MS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
• Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in the project from planning stage to pushing codes to production.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent using SSAS.
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Worked as a technical expert in the design, development, and maintenance of OLAP cubes and databases
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Performed system study and requirements analysis, prepared data flow diagrams, entity relationship diagrams, data diagrams, and table structures to store the data.
• Integrating data from different source systems to load ODS(Operational data store)
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
• Used business object tools to develop reports and accessed, formatted, and delivered information to large populations of users.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2008.

Confidential

SQL Server Developer

Environment: MS SQL Server 2000/2005, SSRS, SSIS, Project server 2007, Crystal Reports, HTML, VSS, Office 2007 bundle, Windows XP, Windows 2003 Server.

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports.
• Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Involved in creating, deploying and configuring reports according the requirements.
• Involved in writing scripts for the clients requirements for generating reports.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers. Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Involved in creating, deploying and configuring reports according the requirements.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Fixed reports and bugs in stored procedures.
• Managed the security of the servers (Logins and users).
• Installed and Configured SQL Server 2005, Integration Services (SSIS) and Reporting services (SSRS) for Dev and QA environments.
• Documented the flow of the project.

Confidential

SQL Server Developer

Environment: Microsoft SQL Server 2008, Sql Server Integration Services, SQL Server Reporting Server, T-SQL, SQL Profiler

Responsibilities:

• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing the physical design for the database.
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in Implementation of database design and administration of SQL based database.
• Optimized queries and stored procedures.
• Wrote T-SQL procedures to generate scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications
• Responsible for transferring of the databases and database objects from Development to Production Server using DTS.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2008 for faster execution and developed database structures