SUMMARY:

• Extensive experience and hands on working knowledge in various domains of IT industry like Health care, financial and insurance as SQL/MSBI Programmer.
• Hands on experience in MS SQL Server 2016, 2014, 2012, 2008 R 2/2008/2005/2000 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Experience in Handling Heterogeneous data sources, databases Oracle, IBM DB2 and XML files using SSIS.
• Experience in RDBMS database design, Data ware House, performance tuning, optimization, client requirement Analysis, Logical design, Development, Testing, Deployment and Support.
• Expertise in Transact - SQL (DDL, DML) and in Design and Normalization.
• Involved in dimensional data model design, ETL frameworks and processing, metadata management, operational data integration, master data management and data quality, data auditing and profiling, and business intelligence reporting solutions.
• Experience in testing and validating data repositories, including data accuracy, data quality, and performance.
• Strong experience in Data ware house and dimension modelling using Kimball and Inmon methodologies.
• Knowledge on EPIC Clarity data models.
• Experience with Microsoft Azure and Service Bus for Windows.
• Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure.
• Strong Knowledge on Data Cleansing, Matching, Referencing, Profiling and monitoring using Data Quality Services (DQS).
• Worked on system performance and data quality issues.
• Experience in integrating the data from multiple data sources from different applications by establishing the connections using drivers.
• Good proficiency in SSAS cubes development and processing including Dimensions and measures design, MDX queries.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement
• Good experience in developing reports using SQL Server (SSRS).
• Experienced in writing parameterized queries for generating tabular reports, formatting report layout, sub reports using global Variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS.
• Worked in Upgrade and Migration projects SQL Server /2014 and upgraded DTS to SSIS by rewriting the complete functionality.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and writing query.
• Proficient in Performance Tuning of SQL query, troubleshooting the performance problems, fine-tuning of databases and Index Analysis.
• Involved in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Involved in working with databases in C# and Microsoft Visual Studio .Net environment.
• Involved in writing C#.net code for SSIS 2008/2005 packages.
• Experience in leading and co-coordinating with off shore team.
• Knowledge on SCRUM/AGILE development methodologies.
• Knowledge on all programming and scripting languages like Python, Perl and JavaScript.
• Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.

TECHNICAL ENVIRONMENT:

RDBMS/DBMS: MS-SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g/10g/9i/8i, MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), Windows Azure, Mongo DB, OLTP, BCP, SSIS, MDS, MDM, DQS, OLAP, Microsoft Visio and ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports, Qlik View, Micro strategy, Report Builder and Tableau.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7, Windows 10, Linux, Mac

Programming Languages: T-SQL, PL/SQL, HTML, VBA, C#.Net, VB.Net, C, C++, Java, Java script, Perl, Python, CSS, Windows Scripts, Unix Scripts

Design Technologies/Tools: Erwin, MS Visio, Rational Rose

Data Warehouse/BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2017/ 2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012/2014, Visual Studio Shell 2013

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Data Engineer | SQL Server Developer

Responsibilities:

• Maintenance, optimization and governed enhancements to the local data environment, on several SQL servers for the Email Management Services (EMS) System.
• Work with the IT Development teams to conceive and convert logical models to physical designs for in-house developed databases, which entails analyzing, defining and documenting requirements for data flow, workflow, logical processes, hardware and operating system environment, interface with other systems, internal and external checks, controls, and outputs.
• Verify that applicable data-related standards are applied in data management activities.
• Participate in the development of data-related standards, guidelines and procedures, and data tool evaluations.
• Ability to draw broad technical expertise to design new database systems at the cutting edge of distributed database technology, and deliver large scale systems.
• Participate on project teams to develop database design changes to existing data models
• Effectively manage day-to-day tasks / activities in coordination with a team to effectively meet the deliverables and schedule of a data solution component within a larger application project.
• Design, build and support data formats, conversion, validation, data extraction, transformation and loading processes.
• Lend support to various business and technology teams as necessary during design, development and delivery to ensure solid, scalable, robust solutions.
• Understanding of database design and data modeling for all the Business Processes.
• Translate requirements into SQL-based objects, such as queries, stored procedures, functions, etc.
• Database development, reporting development and data conversion.
• Develop complex SQL queries, stored procedures and SSIS packages.
• Developing and changing existing ETL, in any database Objects.
• Resolving automated job failures on database applications.
• Validation and monitoring of ETL feeds.
• Responsible for promoting application related objects/code (releases) through different environments up to & including production.
• Assist with production configuration and deployment, as necessary.
• Optimization and performance tuning of Complex and advanced SQL Scripts.
• Assist in troubleshooting and resolution of database issues.
• Assist in the application development, debugging, configuration and optimization from a database perspective.
• Execute and automate recurring DBA tasks.
• Be part of DBA team on-call rotation.
• Administer security - user accounts & database roles, schema, etc.

Confidential, Fremont, CA

Database Design & ETL Developer

Responsibilities:

• Working on the application database design and ETL for the migration of the database from old to the new system.
• Analyzed the legacy system and requirements, designed the new ER database diagram for new system.
• Database design mainly to implement referential integrity to make database robust and consistent application database.
• Redesigned the new database for application from Logic design to physical design.
• Developed ETL and migrated data from different sources.
• Created audit log process on the master tables using triggers.
• Used sources Views and transformed the data with in ETL process.
• Setup HTML Email with dataset for the newly added master data to notify the business users.
• Cleaned data by running through transformations and mapping the data using look up tables as per business logic.
• Worked on performance tuning, working on business requirements using complex T-SQL Scripts.
• Implemented incremental and differential Loads using SSIS and scheduled as daily jobs.
• Worked extensively on testing and reconciliation procedures after migration.
• Developed SQL Scripts for weekly and monthly Qlikview Reports.
• Worked on database security by creating and setting up the permissions on system and custom application database level.

Environment: MS SQL Server 2016, Visual STUDIO DATA TOOLS, SAP HANA, T-SQL, SQL Server Agent, SSIS, SSRS, SSAS, VB.net, C#, Visual Studio 2013, Windows Server 2012, VBA, MS Access, Windows Azure, Qlikview, XML, MS Office and MS Excel

Confidential, Morgan Hill, CA

Lead SQL Server Data ware house Developer

Responsibilities:

• Designed models for loading various data marts with star and snow- flake.
• Design and develop SSIS packages, store procedures, configuration files, tables, views and functions, implement best practices to maintain optimal performance. Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Worked with DBA to build the data model and table structures.
• Actively participated in discussion sessions to design the ETL job flow.
• Compiled source to target mapping documents to design the ETL jobs.
• Extracted data from multiple applications and data sources with the database integration using SSIS and Linked server ODBC connections.
• Used ODBC connections and configured with dynamic expressions.
• Prepared detail design documents which contain job designs and functionality of each job.
• Built ETL process using T-SQL completely and also using SSIS for different loads.
• Developed Data Stage extract jobs using SQL server SSIS and load the data into a staging area in the form of flat files/Data Sets.
• Extensively worked on error handling and logging in SSIS and T-SQL Scripts on package and task level.
• Worked on database design and defining the relationships.
• Worked on current and new system design changes on database and loads.
• Developed SQL Scripts for ETL and implemented slowly changing Dimensions using Merge statements. Designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
• Generated multi parameterized SSRS reports allowing users the ability to make selections before executing reports; thus making them user friendly.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Wrote complex SQL Queries for implementing the business logic.
• Used Shell Scripting for implementing the tasks in the file system.
• Worked extensively writing complex SQL Stored Procedures, Functions, Triggers and Views with dynamic SQL and implemented customer error logging and handling.
• Worked on performance tuning, index analysis and planning.
• Worked on Report Builder to modify existing reports and fixed various SSRS reports on production.

Environment: SQL Server 2014/2016, Oracle 11g, Visual Studio 2015, SQL Server Data tools, SSIS and SSRS, Power BI, Report Builder 3.0, Excel VBA.

Confidential, San Francisco, CA

Senior SQL Server Data ware house Developer

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, tables, views and functions, implement best practices to maintain optimal performance.
• Create the data ware house on SQL Azure database.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2012. Developed reports from OLAP cubes.
• Created, implemented and maintained a reporting suite of over 60 standard reports while also customizing many reports to meet individual client needs.
• Created drill down, drill through, sub and linked reports using MS SSRS 2012 as well as managed the subscription of the reports.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Conduct code walkthroughs and review peer code and documentation.
• Deploying and managing applications in Datacenter, Virtual environment and Azure platform as well.
• Working on Azure for highly available customer facing B2B and B2C applications.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Wrote C# scripts to process the files with dynamic columns.
• Installed Oracle ODBC drivers, created and configured the system data source within the ODBC data source administrator System DSN and used in the SSIS ETL for data imports/exports.
• Extensively worked on SSIS script task with C# and Vb.net scripting.
• Created system for capturing, reporting, and correcting error data.
• Creating Star schema cubes using SSAS .
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Created MDX queries to extract data from the Data Mart.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Gather requirements and design of data warehouse and data mart entities.
• Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Configured SSIS packages and Stored Procedures in Automate 9 Scripts for automating the process of data loads.

Environment: MS SQL Server 2014/2012, Oracle 12c/11g, BIDS DATA TOOLS, T-SQL, SQL Server Agent, SSIS, SSRS, SSAS, VB.net, C#, Visual Studio 2013, Windows Server 2012, Automate 9, Power Shell, VBA, MS Access, Windows Azure, XML, MS Office and MS Excel

Confidential, Pleasanton, CA

Lead SQL Server ETL and Report Lead Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process and understanding the functional work flow of information from source systems to destination systems.
• Involved in daily batch loads into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2014.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Created SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Installed ODBC drivers for Service Now
• Created a linked server using Service Now ODBC drivers and extracted the reports by running the OPEN queries in the SSMS pointing the Service Database.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Created different types of SSRS reports like linked reports, tabular reports, charts, sub-reports, drill-down and various parameter based reports like drop down, Multi-Valued, Multi-select.
• Developed custom ad-hoc reports by using Report Builder, SQL Server Reporting Services (SSRS).
• Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
• Deployed SSRS reports to SharePoint Integrated Server mode and later used these reports on different Dashboard tabs.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Created E-commerce daily, weekly, monthly and Yearly ad-hoc reports for finance department.
• Perform data analysis and develop data mapping and functional solution design documents.
• Implemented data driven subscription using SSIS and C# script in the script component.
• Developed on complex T-SQL scripts and worked on Windows Azure machine.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Environment: MS SQL Server 2014/2012, BIDS DATA TOOLS, T-SQL, SSIS, SSRS, SSAS, VB.net, C#, Visual Studio 2013, Windows Server 2012, Service Now, Windows Azure, MS ACCESS, TERADATA, XML, Unix, Shell Scripts, MS Office and MS Excel.

Confidential, San Mateo, CA

Lead SSIS/SQL Server DBA/Developer

Responsibilities:

• Extensively worked on data analysis and cleansing.
• Worked closely with end-user clients to understand their reporting needs and provided necessary solution.
• Migrated the SQL Server On premise data to SQL Azure by moving the schema and data.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application on Windows Azure machine.
• Created Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for data loads.
• Loaded the data from SQL Server into Azure Data ware house by exporting the data from SQL Server tables to flat files and loaded flat files into Azure tables with BCP command line utility.
• Developed SSIS packages to Load the Azure SQL Data ware house from SQL Server.
• Developed AzCopy command utility to stage the data in Azure Blob Storage and used the poly base scripts to load into Azure data ware house tables.
• Extracted and loaded the data from NetSuite for reporting, by installing NetSuite ODBC driver and created linked server.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created ad-hoc reports by extracting the data from multiple applications. Extracted data from Service now using ODBC with linked server in SQL Server.
• Worked on index tuning to improve the performance.
• Coded windows scripts and created batch files for file transfers and integrated with SSIS.
• Developed C# scripts to validate the columns of the flat files and created temporary tables using dynamic SQL queries to load data from multiple data files into single table.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Co-ordinated with Qlikview reporting team to provide the required data for building dashboards.
• Troubleshooting DB performance issue and implementing necessary DB changes and implemented processes to ensure Optimal Query Performance.
• Co-ordinated between the business team and off shore team.

Environment: MS SQL Server 2014/2012, DATA TOOLS, T-SQL, SQL Server Agent, VB.net, C#, Visual Studio 2013/2010, XML, MS Office, SQL AZURE, MS Visual source safe, TFS, MS Excel and MS Visio. Windows Azure and PowerShell, Microsoft Visual Studio Tools for Applications 3.0, SQL Server Integration Services, SSRS, Report Builder, QlikView 11.20 and Qlik Sense 2.0.2, ITSM Service Now.

Confidential, Foster City, CA

Senior SQL Server/MS BI Developer

Responsibilities:

• Developed modular ETL applications which enable the flow of data between data sources using SSIS.
• Worked on migration of the databases from SQL Server 2000 to SQL server 2012.
• Re wrote the DTS to SSIS packages completely from scratch with enhanced functionality and incorporated new Business rules.
• Integrated data from CRM and ERP applications to extract critical reports.
• Wrote complex functionality using C# and Vb. Net scripting and re wrote active X Scripts to C# and .Net Code.
• Extracted the data Chronicles Cache and loaded the data in relational database tables of EPIC Clarity using ETL scripts and generated reports from the tables.
• Worked with business users for report requirement and developed complex stored procedure and views for reports from EPIC DB.
• Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings.
• Developed batch scripts to run the SSIS/ DTS utility and scheduled on Windows jobs.
• Worked on advanced SQL coding writing complex stored procedures, functions, CTE’s, Triggers, Views and dynamic SQL for interactive reports.
• Loaded new and changed records from source systems into staging and implemented Data cleansing.
• Delivered the ETL high level functional and technical design document for program.
• Coded VB.net and C# scripts using script task transformation to meet complex functionality requirements.
• Worked with database administrators and developed high performing ETL and maintain consistent development functions.
• Worked on Performance tuning the SQL scripts and SSIS packages and solutions to improve the overall execution time.
• Created and modified the indexes on the tables and views for the improvement in the performance of SQL Stored procedures.
• Created proxy accounts, Jobs and scheduled for SSIS packages on the UAT and production server.
• Developed ETL solutions and SQL Scripts with ERROR HANDLING and ERROR LOGGING
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Developed T-SQL Queries and stored procedures, Cursors, triggers, views and adding/changing tables for data load and transformation and data extraction.

Environment: MS SQL Server 2012, 2008 R2/2000, DTS (Data Transformation Services), Master Data Services, MDM, Windows Azure, SQL Azure, DATA TOOLS, T-SQL, VB.net, C#, Visual Studio 2013/2010/2008 , XML, XSLT, MS Office and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio. Microsoft Visual Studio Tools for Applications 3.0, SSAS, SSIS, SSRS, Epic Clarity, SharePoint 2013, SQL Server Reporting Services, Service Now Ticketing System.

Confidential, Richmond, VA/Newbury park, CA

SQL Serve DBA/MS BI Developer

Responsibilities:

• Worked on the project using specifically Agile and Scrum methodology with the short term releases.
• Worked on the complex stored procedures and scripts supporting HIPAA transactions.
• Tested DTS packages and converted them to SSIS from Scratch.
• Converted DTS ActiveX Script to SSIS from developing the code using Script task in SSIS.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Worked with SSIS packages involved FTP tasks, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations.
• Created and maintained Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques.
• Responsible for regression testing ETL jobs before test to production migration.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Executed Transact-SQL batches, system procedures, and script files at the command prompt using SQL cmd Utility.
• Improved the performance of the application by rewriting the SQL queries.
• Involved in designing and developing enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Designed and deployed various SSRS Reports such as Parameterized and cascading parameterized reports using SSRS 2008.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Developed the database application using agile methodology along with Java development.

Environment: MS SQL Server 2012, 2008 R2/2008, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), BIDS, T-SQL, SSAS, SQL Server Agent, QNXT 5.0 including EDI Manager, Java, C#, IBM Mainframes, DB2, XML, XAML, Visual Studio 2008/2005, XML, XSLT, MS Office and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio

Confidential, Pleasanton, CA

Database Programmer

Responsibilities:

• Designed STAR, SNOW FLAKE Schemas. Worked on database modeling, logical and physical database design using Erwin.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS 2008 using MDX.
• Created various Dimensional Hierarchies, KPI’s, Measures and calculations as part of cube design.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Took part in the normalization and de-normalization of database.
• Worked with team in developing interfaces using C#, ASP.NET.

Environment: SQL Server 2008, SSAS, SSRS and SSIS, Visual Studio 2008/2005