SUMMARY

• Over 8 years of IT experience in various sectors, including Pharmaceutical, Financial and Retail as a SQL Server Developer that includes Database Design and Development in various versions of MS SQL Server including 2014/2012.
• Involved in all phases of Software Development Life Cycle (SDLC).
• Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client - Server & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience in building OLAP and OLTP Solutions,
• Expertise in writing and debugging Stored Procedures and Triggers in SQL Server and PL/SQL.
• Upgrade DTS packages to SQL Server Integration Services (SSIS).
• Expertise in Data Transformation Services (DTS) in SQL Server 2000.
• Expert in creating ETL SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Experience in Performance Tuning in SSIS packages.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expertise in generating dashboards using Qlikview, Tableau and Power BI.
• Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix, dynamics reports and other features of reporting service.
• Planned and implemented MS SQL Server Security and database access.
• Experience in Database Mirroring, Log Shipping, Database Replication, CDC and Database Snapshots
• Knowledge on Active Directory Administration.
• Created and implemented Change Control process.
• Experience in installing and configuring third party backup/restore tools like Quest Litespeed and Idera SQLSafe.
• Troubleshoot performance issues and bottlenecks using Performance Monitor and Profiler for monitoring dead locks and long running queries.
• Carried out database consistency checks using DBCC commands.
• Experience in Data Center Migrations and Server consolidation
• Configured database mail to send messages when jobs failed in SQL Server environment.
• Ability to quickly adapt and learn, work in-groups as well as independently with minimum supervision.
• Demonstrated understanding of Business Analysis/Data Analysis process
• Attention to detail and the ability to critically analyze and challenge the status quo, providing constructive alternative recommendations.
• Excellent communication, negotiation, facilitation and interpersonal skills and ability to present and articulate using a variety of verbal, written and visual methods where appropriate to a diverse range of audiences.
• Strong analytical abilities and creativity in developing approaches to business needs and recommending actions to management, or implementing the recommendations.
• Self-motivated and able to work primarily without direction
• Proven ability to: meet goals and deadlines, balance multiple tasks and manage time efficiently.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008/2005/2000
• Qlikview 11
• Tableau
• SQL Server Management Studio
• Data Tools
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• ETL
• PL/SQL
• Microsoft Team Foundation Server (TFS)
• MDX
• Azure
• SQL Server Profiler
• MS Visio
• MS Project
• Automate 9.0

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. BI Lead/ Sr. Tech Analyst

Responsibilities:

• Involved in complete design discussions, requirement gathering and development phases of the Breakfree Global BI project.
• Worked with various functional areas to understand the report requirements.
• Created GBI Cube using SSAS for the Business users on a Global scale.
• Created complex calculations for the users using MDX.
• Consolidated various data sources including ERP (JDE 9.1), JDA, Access Databases, and Nielsen Source Files in to a Global Data warehouse.
• Currently working on impact analysis of upgrading ERP to JDE 9.2.
• Analysis of various input sources and the mapping to the Global Data Warehouse.
• Created new and modified existing SSIS packages to suit the new Data sources and Tools.
• Created various SSRS reports for the Leadership Team and Super Users.
• Honored and delivered various ad-hoc analytical and reporting requests.
• Reviewing of the existing BI ecosystem and improve the existing reports using new tool set.
• Tested different BI Tool sets like Power BI and Tableau for the Business Stakeholders.
• Created complex Excel reports and Dashboards for the users using Power pivot and Power BI.
• Lead the Off shore team to make sure the requirements have been correctly translated.
• Provided high quality and consistent BI services and interactions with Clients.
• Provided analytical capability in order to help the Business User to understand and use their data.
• Provided training and assistance to Clients in using Business Intelligence Applications.
• Provided thought leadership regarding BI/Analytical applications and use of within TWE.
• Worked towards increase in adoption of BI and Analytical applications by demonstrating the business value that can be generated from the use of existing information assets.
• Liaise with key functional managers, analysts, BI consumers and stakeholders, critically analyze business needs and identify opportunities for BI to contribute to commercial outcomes by providing input to cost-effective, timely and efficient information solutions.
• Develop effective training and coaching methods intended to increase Analyst capabilities in BI toolsets, solutions and information content, for the purposes of empowering users with new skills that drive business innovation and discovery.
• Provide support to internal stakeholders with respect to information sourcing and their appropriate uses for commercial data, based on an understanding of the current data sources and business rules.
• Develop and maintain a detailed understanding of the business glossary/data model
• Proactively communicate project and operational statuses to internal stakeholders, highlighting potential issues and remediation required.
• Communicate/Update Clients on changes to BI Applications and Data.

Environment: SQL Server 2014, SQL Server 2012, SSIS, SSAS, MS Azure, Excel, Power BI, Tableau.

Confidential, Omaha, NE

SQL Server Migration Specialist

Responsibilities:

• Modified existing stored procedures, views and Tables across various Servers and Databases in the FCSA ecosystem.
• Modified the metadata across the SSIS packages for all the changes made to the corresponding databases.
• Created DNS Aliases for the databases in the FCSA ecosystem.
• Modified the SSIS Configuration Files for the DNS Aliases created.
• Active contribution in upgrading SSIS packages from SQL 2008R2 to SQL 2012.
• Deployed SQL Scripts and SSIS packages using Powershell Scripts.
• Reviewed existing dashboards built in SAP Business Objects and re-implemented the dashboards using Tableau.

Environment: SQL Server 2008 R2, SQL Server 2012, SSIS, Powershell, Tableau, Business Objects.

Confidential, Walnut Creek, CA

SQL Server BI Consultant

Responsibilities:

• Created new DataMart to normalize the data and generate the reports for the ACO Submission.
• Imported data from various data sources including Clarity Databases and various other sources.
• Gathered requirements about the different data sources and the data destinations for implementing the reports for the Coders.
• Consolidated XML, OLEDB, and Excel and CSV data sources and created ETL SSIS Packages to load the data in to the Staging Database.
• Analyzed data and troubleshoot Data issues and validate the data sources.
• Implemented complex PL/SQL stored procedures to stream line source data.
• Created complex SQL queries to create the SSRS Reports for Medicare and GPRO Submission.
• Unit tested & deployed the code to production.
• Scheduled ETL (SSIS) packages using SQL server job scheduler.
• Setting up Qlikview Dashboards for top management.
• Created a Technical Design Documents for the projects development.

Environment: Windows server 2008, SQL Server 2008 R2, PL/SQL, Clarity, Qlikview 11, Excel, SSIS, SSRS.

Confidential, South San Francisco, CA

Sr. BI Analyst/ SQL Server / Qlikview Lead Developer

Responsibilities:

• Involved in requirements gathering for the dashboards, Troubleshoot Data issues and validate the data sources.
• Responsible for creating source to destination data mapping documents and architecting ETL solutions using SQL server integration services (SSIS).
• Managed Off shore team for timely delivery of the dashboards.
• Responsible for unit testing & deploying code to production.
• Responsible for scheduling ETL (SSIS) packages using SQL server job scheduler.
• Involved in performance tuning of SQL queries & SSIS packages.
• Responsible for creating Qlikview Dashboards and creating triggers for dashboard refresh.
• Responsible for maintaining user access to the dashboards & Licensing Users for access.
• Created a Technical Design Documents for the projects development.
• Responsible for providing on call support for 24/7 server availability and Production Support.
• Responsible for coordination & communication with the offshore team for the project development effort.

Environment: Windows server 2008, Oracle 11G, SQL Server 2012, Qlikview 11, Excel, SSIS, SSRS.

Confidential, San Francisco, CA

SQL BI Developer

Responsibilities:

• Created the list of dimensions and Measures as per the User’s requirements.
• Created complex queries for database auditing purposes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
• Created the SSAS cube using complex MDX calculations and Dimension mappings.
• Created new views in order to populate the SSAS Cube.
• Created SSIS Packages and scheduled them using Automate Tool for loading the data to the SSAS Cube.
• Worked towards the improvement of overall Cube performance.
• Implemented and automated the QA process to compare the results from the cube to that of the Data Warehouse using SSIS.
• Involved in the process of creating Sales Dashboards using Qlikview.

Environment: Windows 7, MS SQL Server 2012, Data Tools, SSAS, SSIS, Qlikview 11, Excel Macros/PowerPivot.

Confidential, Richmond, CA

Sr. SQL BI Developer

Responsibilities:

• Participated in entire SDLC process. Followed waterfall process for the project.
• Interacted with Business Users to gather the requirements.
• Improved and improvised the system by rectifying existing bugs and implementing new features.
• Created new stored procedures, indexed views, user defined functions in accordance with client requirements.
• Monitored the database consistently on the production server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
• Responsible for installing and configuring SQL Servers on both Physical and Virtual (VMWare) Servers.
• Providing day-to day to support and monitoring SQL Servers performance.
• Monitor Disk space and suggest reasonable estimates for additional space.
• Automate database refresh from prod to test as needed.
• Configured SQL mail Agent for sending Automatic emails on Errors.

Confidential

Lead Developer

Responsibilities:

• Entirely responsible for the SQL Server Upgrade from SQL 2005 to SQL 2008 R2.
• Was in constant interaction with the ITSD for base lining the hardware as well as software requirements for the SQL upgrade.
• Actively involved in planning the recovery models for the upgraded SQL Server.
• Involved in setting up a maintenance plan for the periodic backups of the SQL Database.

Confidential

Lead Developer

Responsibilities:

• Entirely responsible for implementing critical reports in SSRS.
• Proposed a cost effective Business Intelligence model to the client.
• Involved directly with the Business Users, to gather information to be reported.
• Created scheduled subscriptions as per the User’s requirement.

Environment: Windows XP/2003 Server R2, MS SQL Server 2005/2008 R2, SSRS.

Confidential, Oakland, CA

Sr. MS SQL BI Developer SSIS

Responsibilities:

• Worked with Business Analysts and Users to understand the requirements.
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Created and managed complex batch jobs.
• Created complex queries for database auditing purposes.
• Extensively used different SQL joins in order to produce quality result sets.
• Imported data into the database using SSIS.
• Used various transformations during the data import.
• Manipulated the imported data using various stored procedures and functions.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Responsible for automating Weekend server maintenance Tasks including index Maintenance.
• Carried out database refresh using backup and restore in SQL Server.
• Applied Service Packs and hot fixes on SQL Servers.
• Configured SQL mail Agent for sending Automatic emails on Errors.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.

Environment: Windows XP/2003 Server R2, MS SQL Server 2008, SQL Server Reporting services, SQL Server Integration Services, Management Studio.

Confidential, San Francisco, CA

MS SQL Server Developer/SSRS/SSIS

Responsibilities:

• Migrated Data from MS SQL 2005 to MS SQL 2008.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Created packages to migrate data from different data sources to Data warehouse.
• Created packages for database maintenance.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Created SQL Server Reports using SSRS 2005 for the clients.
• Created parameterized reports for the brokers and clients.
• Deployed the developed reports and upgraded the system.
• Deployment of the developed reports on to the server for the end users.
• Fine-tuned the existing SQL queries for maximum efficiency and performance.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: Windows 7/XP, MS SQL Server 2008/2005, SQL Server Reporting services, PL/SQL, SQL Server Integration Services.

Confidential

Jr. SQL Developer

Responsibilities:

• Development of SQL scripts for backup restore.
• Creation of stored procedures for application development.
• Performance tuning of SQL statements using stored procedures and indexes.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Replication of data using transactional method.
• Created crystal reports, ODBC and database connections.
• Worked with Oracle and MS SQL Server databases to create reports using Crystal Reports.
• Formatting of reports for various output formats as per the convenience of the end users.
• Scheduling of alerts.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, Crystal Reports.