SUMMARY:

7.5 years overall IT experience with major focus on Microsoft SQL Server Business Intelligence Tools (SSIS, SSAS, SSRS). Sound experience as a database developer and support executive in life science, banking, IT and financial sectors.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows Vista, Windows 7, Windows 10

Components/environment: MS SQL Server 2000/2008 R2/2012/2014, SQL Server Management Studio, Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS), Oracle PL/SQL, Tableau reporting tool, ProClarity reporting tool, HPSM ticketing tool and BO reporting tool.

Languages: T - SQL , PL/SQL , PHP, C#, JCL, COBOL, REXX

RDBMS: SQL Server 2014,2012,2008 R2,2000, MS Access, VSAM

Job Scheduler: Cronacle, SQL Agent

Tools: Visual Studio 2010 and 2012, Tableau Desktop, MS Visio, HPSM

Software Development Cycle: Waterfall Model, Agile Methodology

PROFESSIONAL EXPERIENCE:

Support Executive

Confidential, Indianapolis, IN

Responsibilities:

• Subject matter Expert of all the CRM BI NA applications with 100% SLA Adherence and 95+ % Customer Satisfaction Index.
• Exceptional Support, Maintenance and Development of Confidential components such as SSIS packages, SSAS cubes and SSRS reports, Tableau reports.
• SQL Configuration Manager, Tableau Admin and developer for Confidential Region.
• Single point of contact from team for the end customers in the client environments.
• Mentor team members, provide support during escalations, preparing project metrics, monitor and report the project status on a regular basis to the Roche leadership team.
• Implemented Kanban and Scrum Agile methodologies.
• Provided several process and performance improvement ideas (2 per month) for the customer throughout the project and implemented more than 90% of them.
• Proposed Application Portfolio Rationalization for a cost saving of about $20k on licenses plus several development and maintenance hours which has been accepted and appreciated by customers.
• Received several appreciations from customer for being very responsive, continuous communication and update to customer and also for driving several mini projects within the Solution Delivery and Solution Maintenance team.
• Pivotal in several high visibility customer projects such as GfA, Rexis Service Keyword Search, NASDM and CASDM.
• Pivotal in building a very cohesive environment within the team where my team is always willing to learn new technologies, participate in new projects and coordinate with other teams to help improve our efficiency and end results.
• Pivotal in reducing the incidents and failures and increasing the Change Requests which helped in getting better insight of the applications and also gave the customer more opportunities for using our team for various high end projects.

SQL Server & SSIS Developer

Confidential, MD

Responsibilities:

• Analyzed each of the requirements, impact analysis, created the design, technical specifications and coding of the stored procedures for the packages.
• Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Responsible for gathering Business Requirements and System Specification from users.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.

SQL Server & ASP.Net developer

Confidential, MD

Responsibilities:

• Responsible for all technical SQL Server database operations, Administration, ongoing development for various the HOCInsight database.
• HOCINSight .Net Application Development and Maintenance.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, user defined data types and functions for this project.

SQL Server & SSIS Developer

Confidential, MD

Responsibilities:

• Responsible for creating a Strategy Document for MS SQL Server 2000 & 2008 Migration which was presented to the client and the project proposal was eventually approved.
• Responsible for creating the estimate, schedule and plan for the project.
• Installation of SQL Server on Development, UAT, Production and COB Servers, setting up databases, users, roles and permissions.
• Created Technical Specifications Document (TSD) for each application for the conversion project.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Rewriting of SQL Server 2000 Data Transformation Services to SQL Server 2008 SQL Server Integration Services along with enhancement.
• SQL Server 2000 objects were analyzed for incompatibility with SQL Server 2008 and modified accordingly.
• Application level queries were rewritten for those SQL Server 2000 objects that were incompatible with the SQL Server 2008.

Mainframe Developer Developer

Confidential, MD

Responsibilities:

• Understanding the requirement using the Business Requirement Document (BRD) and Functional Specifications Document (FSD).
• Preparing the design document, Creating the detailed Technical Specification Document (TSD), Estimation based on TSD, Functional & Process Flow Diagram using MS Visio.
• Development, Maintenance, Implementation and Support for IBM Mainframe Z/OS using languages such as JCL, COBOL, REXX, CICS and VSAM as database.
• Provided onshore support when required.