SUMMARY:

• Over 18 Years of experience in all phases of web, client server applications. Experience includes Consulting, Business Analysis, design and programming in Government agencies, financial, hospitality industries.
• Microsoft BI expert. Expert Knowledge in Data Modeling, Data warehousing, ETL, Cubes, SQL Queries, Stored Procedures, Triggers, Query optimization, MS Business Intelligence 2005, 2008 and 2012(SSIS,SSAS,MDX Programming, SSRS, Excel & Excel Services, Performance Point Server, Share Point Server).
• Fair amount of knowledge working with Power Pivots providing self - service BI functionality for users. Good knowledge of DAX functions that allow users to define custom calculations in Power Pivot tables.
• Familiarity with Microsoft Azure SQL Data Warehouse
• Significant experience in designing and developing client server applications and web applications using asp, Cold Fusion 5, PHP, Visual Basic4.0/5.0/6.0, HTML, DHTML, ACTIVE-X, VB Scripts, JAVA Scripts, Oracle 10g,MS SQL Server 2000,2005/2008, 2012 MS Access 97/2000/2003 , MySQL, Windows 95/98/NT 4.0/2000/XP, and Windows 2000/2003 Server.
• Good understanding of Business requirement gathering, business processes flow and business analysis. Knowledge in business process design, knowledge in UML, Solid understanding object oriented methodology
• Good Communication and presentations skills. Experienced in working with business users as well as senior management.

TECHNICAL SKILLS:

Languages: Java, C#, PHP, Cold Fusion8, XML, Java Script.

Reporting Tool: SSRS,Hyperion8.5 and 9 Crystal Reports 8.5/9

Databases: MS SQL Server / 2000/2005/2008 , 2012, MYSQL, MS Access 2000/2003

Tools: Rational Suite, Microsoft office, Visio, Visual Interdev, Home Site, Eclipse, Macromedia

Servers: IIS, Apache Tomcat, Jrun, Cold fusion Server

Operating Systems: Windows 7,NT\XP\2000\2003, LinuxHyperion Business Intelligence Software 8.5Informatica Cloud, Salesforce

PROFESSIONAL EXPERIENCE:

Confidential

SR SQL Database Developer

Responsibilities:

• Worked on Database projects for in house applications and SQL Server 2008 BI implementation.
• Query Tuning, Query Optimization, Handling Deadlocks etc.
• Managing Informatica Power Centre ETL tasks processing MSMQ’s.
• Maintaining SSAS Cubes and doing any enhancements.
• Designing, Deploying and subscribing SSRS Reports.
• Enhancing, Rebuilding and Troubleshooting SSIS Packages which loads the Data from Transaction systems to DW systems.
• Designing Microsoft service brokers for messages flow.
• Data validations, data mapping from the source system to destination, Metadata management, Data dictionaries and data quality management.
• Database deployments in QA

Technology: Microsoft BI stack: Sql Serever 2008R2 (SSIS, SSAS, SSRS), Share point 2010, TFS 2012.

Confidential

Responsibilities:

• Handling EDI files of format 835 and 837 in SIIS using EDI tool for validating.
• Building Mini DataMart’s from their Huge Vision Claims related Health Care data for serving different Account holders and Confidential Finance team.
• Involved in ETL design to integrate data from various sources and providing self-service reporting solution for the business to create and manage reports
• Maintained oversight to deal with design issues discovered during the detailed build, testing or implementation project phase and where required updating and re-issuing architecture artefact.
• Involved in design and building lot Self Service reports and Report automation using SSIS and database subscription.

Confidential

Responsibilities:

• Worked on Database projects for in-house applications and SQL Server 2008 BI Implementation.
• Troubleshooting the performance issues, Query Tuning, Query Optimization etc.
• Managing Informatica Power centre ETL tasks processing MSMQ’s.
• DACPAC Deployments, Preparing the release notes and Adhering SDLC principles while developing the product and fallowing Industrial best practices.
• Maintaining SSAS Cubes and doing any enhancements.
• Enhancing, Rebuilding and Troubleshooting SSIS Packages which loads the data from Transaction Systems to DW Systems.
• Data validations, data mapping from the source system to destination Metadata management, Data dictionaries, and data quality management

Confidential

Data Architect

Responsibilities:

• Designed and Created SSIS Package having the master package calling the child Packages to load the billing data from Xifin Mars system connecting through secure ftp to their server unzip the txt files and do incremental loading in to sixty different tables of Confidential Billing Database.
• Designed and developed Confidential Data warehouse by integrating the data from different data sources like billing data from Billing Database and Lab data from
• Lancelot system and Sales Data from Salesforce Cloud. Implemented Type 2 SCD (Slowly Changing Dimension) in the ETL process while loading the data in to EDW.
• Migrated all SSIS packages from 2008R2 to SQL 2012.
• Developed different SSAS cubes on EDW and facilitated the Power users connecting to the SSAS cubes and do their ad hoc analysis on the cubes data.
• Designed, build and deployed enterprise Reports using SSRS both using Transactional Data and SSAS Cubes. And significantly increased the performance of the some of the reports connected to SSAS cubes instead of OLTP Data.
• Written complex TSQL Code by leveraging temporary objects, dynamic SQL, windowing functions, CTEs and Cross Apply.
• Read the execution plans and diagnose the problem in queries.
• Did data mapping between source and destination systems and established transformation rules.
• Enables and trained users using self-service BI Reporting using the tools like Power Pivot and Power view etc.
• Did data validation from source to Destination Systems by simulating scenarios of ETL Processes in Dev environment.

Confidential

Sr.Programmer

Responsibilities:

• The department sponsors various programs in various states for to upgrade their skill sets and make them employable. We have implemented complete life cycle of BI Project to get various metrics of programmers.
• It involved from gathering the requirements, preparing the staging database by merging data from various data sources using SSIS Packages and also using complex SQL Scripts.
• Building the Cube data from staging database using SSAS. Created cube partitions, calculated members and KPI’s. Fallowed the best practices while designing the cube.
• Designed the reports and charts using the cube data in SSRS, designed the score cards, dashboards using PPS and also Excel services and deployed in to MOSS.
• For some of the reports we have used custom MDX code to populate the data.
• Involved in analysis and development of implementing the geo coding using Google API’s in Cold Fusion 8 so that the Users can search the different locations by distances etc.
• Changed the design and architecture of complete FLPP site so that the site free from cross side scripting, SQL Query injections making all form and URL variables hack proof.
• Responsible for changing back end oracle stored procedures, Tables, Views and materialized views based upon business requirement changes in Oracle 11g.
• Responsible for maintaining the Forecast website. Completely refurbished the website redesigned the complete database and modularized the code and implementing the AJAX functionality in Cold Fusion and SQL Server 2005 drastically increased the client user experience and response time.

Confidential

Responsibilities:

• Worked on SUMS (Social security unified Measurement Systems) Project.
• Involved in designing and analysis of OLAP databases.
• Generating Dashboards and reports for drill up and drill down, slicing and dicing of the intelligence information using Hyperion 8.5.

Confidential

Responsibilities:

• Worked on several web applications using Cold Fusion, PHP and ASP with MySQL, Access, MS SQL Databases on Apache and IIS web servers.
• This system is developed for Maryland State Department of to manage the data for Career Technology and Adult Learning to add, edit and update the adult learner’s information through the web system. The users can update their class enrollment and their EDP and tutoring information. The system also generates the reports for audit purposes. The reports are redesigned for the fast retrieval of the data using OLAP approach. The data will be imported into this database from Correctional from time to time and the data collected from this database will be sent to federal government as reports for auditing.
• Maintained four different applications viz., Data Entry Application, Error Reports Application, State and Federal Reports Application and Data Export Application. This system has been developed using Asp, Access 2000, VBA, and SQL Server 2000 as the database on a Citrix Server. Designed some triggers and procedures in MSSQL2000.
• Developed various BI reports in MS Access and MS Excel for Management Decision and Quality Assurance.

Confidential

Responsibilities:

• Worked as Marketing executive and Asst Manager Operations in Confidential involved in devising various Marketing plans Using Market mix and as Asst Manager Operations involved in Logistics Planning and Management.