ROSHAN KAMAT

San Jose, CA

EMAIL: ac6qcz@r.postjobfree.com

Phone: 669-***-**** / 626-***-****

JOB OBJECTIVE

Seeking a full-time or contract position as MS SQL Server Database Developer / MSBI (SSIS, SSRS, SSAS, ETL) Business Intelligence Developer / Reports Analyst / VBA Programmer / ETL Developer / Business Data Analyst / Data Engineer

WORK STATUS

US Citizen - authorized to work for any employer

EDUCATION /

CERTIFICATION

Master’s Degree in Computer Science, Pune University, India

Bachelor’s in Accounting & Finance, Mumbai University, India

Certification – Six Sigma Green Belt training from GE, USA

TECHNICAL SKILLS

MS SQL Server 2008/2012/2016, TSQL, DTS, SSIS, SSRS, SSAS, Snowflake, Star-Schema, MSBI, ETL, Data Analytics, Business Intelligence Reporting, VBA, Macro, VBScript, JavaScript, Python, Shell Script, .Net, HTML, XML, Visual Basic 6.0, Business Objects / Crystal Reports, Windows / Unix / Linux, Oracle, PL/SQL, MS Word, MS Excel, MS Access, MS Project, MS Visio, MS SharePoint, Agile / Scrum / Waterfall Methodology, SVN, TFS, JIRA, OOPS, C++

PROFESSIONAL

EXPERIENCE

●10+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like Healthcare, Financial, Insurance and manufacturing

●Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2

●Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)

●Experience in creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

●Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard and Bulk Insert

●Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all

●Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL

●Strong expertise in writing complex Access, Excel Macros with Excel VBA for different Business Environments

●Created user defined functions, add-ins, menu bars, forms and user friendly interfaces that support various P&L reports and daily tasks.

●Produced daily risk report encompassing VAR assessment, scenario analysis and stress testing using Excel and VBA

●Designed and developed MS Access user interfaces with user validations using VBA

●Used VBA extensively and provided options to query the data based on their selection.

●Imported data from SQL Server into Access. Developed multiple Excel/VBA Forms for data capture and report generation. Developed procedures in MS Excel for export and import of data to and from MS Access

●Error reports and Audit reports were generated as a result of error traps

●Created Excel applications (VBA, Macros) to import historical data which include multiple databases and perform various statistical analysis, pivot tables, charts and graphs

●Designed Dashboard, a front end Excel/user form based application which connects to back end Access database using Excel/VBA. Built user guide for technical users providing vital information to create new users for the Dashboard application, to load data necessary to update Dashboard and logical diagram of flow of data from flat files to Dashboard

●Automated the printing process of excel reports such as performance matrix report and Budget spending report on monthly and YTD(Year to Day) basis and sending them as an email attachments using Excel/VBA macro

●Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files

●Experience in Performance Tuning and Query Optimization.

●Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports

●Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages

●Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment

●Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services(SSIS)

●Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS

●Hands on experience in Creating Star Schema and Snowflake Schema.

●Ability to work effectively in a collaborative work environment involving multiple team members, business analyst, test engineers and end-users

●Capability to perform multiple tasks simultaneously in a fast-paced environment

●Zeal and enthusiasm to ensure that the task on hand is taken to execution in the given time frame and with the expected quality standards

●Result-oriented and positive attitude

●Ability to work in a team environment as well as independently with very minimal supervision

●Good communication, written, verbal, presentation and interpersonal skills

●Desire to learn new technologies

COMPANIES

CAPGEMINI DEC 2012 – JUL 2018

A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Capgemini is driven by the conviction that the business value of technology comes from and through people. It is a multicultural company of 200,000 team members in over 40 countries. The Group reported 2016 global revenues of EUR 12.8 billion.

Role & Responsibilities : Sr. Software Engineer

●Interacting with Onsite team, Taking clarifications on the customer requirements

●Analyzing the requirements and discussed with managers and leads on the functionality

●Participate in Walk-through sessions with onsite people

●Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2008

●Wrote the SQL queries, Stored Procedures and Views

●Built data connection to the database using MS SQL Server

●Regression testing was performed after each new build of the application

●Defect logging and Defect follow up in Team Track

●Have worked with Database testing and SQL queries, preparing Status reports

●Back-end database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs

●Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes

●Performed Database code Migration from SQL Server 2005 to 2008 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.

●Experience in SQL joins, subqueries, tracing and performance tuning for better running of queries.

●Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts

●Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.

●Experience in SSIS script task, lookup transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts

●Experience in generating reports using linked reports, subreports and filters in SQL server reporting services

●Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams

KAISER PERMANENTE NOV 2009 – SEP 2012

Founded in 1945, Kaiser Permanente is recognized as one of America’s leading health care providers and not-for-profit health plans. We currently serve 11.8 million members in eight states and the District of Columbia.

Role & Responsibilities : Sr. Software Developer

●Worked on Membership Enrolment, Eligibility, Provider Contracts and Pricing Methods, Authorization and Referrals, Cost Containment and Claims Processing

●Heavy Data ETL work from various sources to develop Data Warehouse platform using MS Business Intelligence SSAS, designing and developing Cubes for data analytics

●Created Data Marts using Snow-Flake schema, SSIS, Stored Procedures and Data Staging

●Created SQL server Reports using SSRS 2008. Identified the data source and defined them to build the data source views

●Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS)

●Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005 (SSAS)

●Used scripts and variables, email notifications for ETL process using Data Integrator.

●Experience in creating complex SSIS packages using proper control and data flow elements with error handling.

●Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.

●Enhancing and deploying the SSIS packages from development server to production server.

●Designed and built OLAP cubes to meet reporting needs.

●Performed Documentation for all kinds of reports and DTS and SSIS packages.

●Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).

●Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

●Created Packages in SSIS with error handling.

●Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

●Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

●Created Time Dimensions on OLAP Cubes using SSAS

●Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

●Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

●Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

●Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

●Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design

●Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

●Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development

●Involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

●Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.

●Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.

●Involved in migration from SQL Server 2005 to SQL Server 2008.

BANK OF AMERICA SEP 2009 – NOV 2009

Bank of America Corporation is an American multinational financial services company headquartered in Charlotte, North Carolina. It is ranked 2nd on the list of largest banks in the United States by assets.

Role & Responsibilities : Software Programmer

●Developed, Installed, upgraded, configured, analyzed and supported the report database management application - Data Access Information System used for the mortgage segment

●Developed business reports and management dashboards, running TSQL data query for large data sets to analyze transaction patterns, examine financial data and create reports on targeted information.

●Worked with DTS/SSIS Packages, creating, managing, and supporting high performance relational databases using SQL Server 2005, Microsoft Access and OLAP.

●Performed Database Administration tasks like Optimization, Partitioning, and Security.

ABPA INC OCT 2008 – SEP 2009

American Benefit Plan Administrators, Inc. (ABPA), founded in 1951, was one of the oldest third-party administrator (TPA) firms in the US, managing funds created under provisions of the Taft-Hartley Act, pension plans, and voluntary employees' beneficiary associations (VEBAs)

The primary goal of the project is to achieve a high rate of auto-adjudication of claims. This requires automation of business processes and decisions that are currently being done with legacy computer systems initiated manually by human operators. This product administrates various health plans. It includes technical implementation, processing claims (receiving, validating, substantiating), payments (Checks & EFT), statements generation (e-Statements & mails), Card issuing through interacting with bank & customers, also interacts with carrier's and Merchants. The work platform is equipped with all the latest features of Auto-adjudication rules, Claims Processing and Reports generation. Claims processing is the main user interface component of the system. And apart from the above components it has been equipped by web portal which is now becoming the customized component for the clients.

Role & Responsibilities : Software Developer

●Designed the SSIS ETL processes to pull Membership, Claims and Employers’ Data from the Mainframe systems. SQL Database designing and development, snowflake schema for data staging and production environments.

●Developed Business Reports in SSRS for different regions / accounts by working closely with the business analysts and PMO.

●Managed multiple tasks, peer review, maintaining standards, documentation, technical and conceptual design using MS Visio and Erwin.

●Created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS)

KB HOME JUL 2008 – OCT 2008

KB Home is a homebuilding company based in the United States, founded in 1957 as Kaufman & Broad in Detroit, Michigan. It was the first company to be traded on the NYSE as a home builder and was a Fortune 500 company from 2000 through 2008.

Role & Responsibilities : Software Developer

●Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).

●Used SSRS to develop different kinds of reports like canned, ad-hoc reports

●Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.

●Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

●Worked on formatting SSRS reports using the Global variables and expressions.

●Created parameterized reports, Drill down and Drill through reports using SSRS.

●Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.

●Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

●Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.

●Prepared the complete data mapping for all the migrated jobs using SSIS.

●Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and

●triggers

●Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

●Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

●Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

STEELCASE INC JUN 2004 – JUN 2008

Steelcase is a United States-based furniture company founded in 1912 in Grand Rapids, Michigan. The company produces office furniture, architectural and technology products for office environments and the education, health care and retail industries. It is the largest office furniture manufacturer in the world. It has facilities, offices, and factories in the Americas, Europe, Asia, the Middle East, Australia and Africa.

Role & Responsibilities : Software Developer

●Developed databases, created tables, stored procedures, and views using MS SQL using data modeling techniques, management reports to review the manufacturing performance measurements for scheduled and completed production, standard hours, pitch reports and flow-interrupters.

●VB Application programming, Database backup/Restore, Performance Tuning, Scheduling and Monitoring SQL Jobs and Scripts ensuring that the production system is available 24 x 7

SPECTRUM SELECT INC. OCT 2002 – JUN 2004

Spectrum Select is a start-up company engaged in the internet telephony business with an innovative concept of pay-as-go for voice and data plans using the phone booths installed in the public areas like airports, hotels, malls.

Role & Responsibilities : Software Developer

●Participated in database development and software applications programming process for our internal operations using client-server architecture and relational database management systems.

●Primarily supported all our IT operations as necessary to support our product ‘Payphone Internet Kiosk’, receiving log files, processing data files and loading them in our database, creating reports on the payphone usage. Extensive programming in VBA and Visual Basic 6.0 and upgraded SQL Server 7 database to SQL Server 2000 and performed data analysis using DTS, stored procedures and T-SQL.

●Running Shell scripts for remote connectivity, troubleshooting the Payphones at customer sites. Designed Database schema using Normalization concepts, Entity-Relationship Diagrams and Work-flows

●Worked with SQL Enterprise, Query Analyzer and SQL Profiler to understand Data Execution Plan.

●Created Database tables, Views, Stored Procedures and Triggers. Assisted DBA in database optimization, performance tuning, monitoring automated jobs, log shipping and backup / restore procedures, developed client-server applications using Visual Basic 6.0, ADO, OLEDB and ad-hoc reports using Crystal Reports

KAISER PERMANENTE JUN 2002 – OCT 2002

Founded in 1945, Kaiser Permanente is recognized as one of America’s leading health care providers and not-for-profit health plans. We currently serve 11.8 million members in eight states and the District of Columbia.

Role & Responsibilities : Software Developer

●Data analysis and mapping, translating, validating and updating the Clinical Information Systems with the viable information to be used by the health centres using SQL queries and VB Script.

●Ensure accurate and timely processing of information in and through the ancillary systems MS Access, DB2, AS/400 data marts using custom ETL tools

●Running defect management tools and utilities, comparing the migrated data by preparing the detailed test procedures. Writing Stored Procedures, Views and detailed technical supporting documentation

●Developed White Box and Black Box testing procedures by following Corporate Standards to handle confidential data coming from the Health Centres and Hospitals

Contact this candidate