PROFESSIONAL SUMMARY

• Microsoft Certified Professional, with over 14 years of industry experience in design, development and implementation of business requirements with Microsoft .Net technologies, and integration of MSBI Stack with SharePoint, DW Project Management, and MS BI Stack configuration
• Experienced in each phase of BI development life cycle, from business analysis to DW design and implementation.
• 9 Years of Experience with MS SQL Database Engine 2000 - 2012
• 6 Years of Experience with the Microsoft Business Intelligence Stack

i. using relational databases

ii. MS SQL, Microsoft Analysis Services SSAS ,

iii. Microsoft Integration Services SSIS ,

iv. Microsoft Reporting Services SSRS

v. SharePoint Excel Services

• Data analyzing experience in designing and implementation of Reports in SQL Server Reporting Services SSRS , Power View, Report builder, PerformancePoint, Tableau dashboard in data warehouse Environment.
• Expertise in Requirement analysis, Database design, Data modeling and complete software lifecycle.
• Experience in supporting multiple production database servers
• Experience in MS SQL Server Installation, Configuration, Performance Tuning, client/server connectivity, building servers, trouble shooting, query optimization, back-up/recovery, running Database Consistency Checks using DBCC and troubleshooting on large databases and maintaining, supporting, monitoring production and test environments
• Self-starter with strong planning, organizing, controlling skills and communication skills. Consistently manage time and multiple tasks to meet deadlines, established objectives and quality performance standards.
• Experienced in the Financial, Government, and Healthcare domains.

TECHNICAL SKILLS

• RDBMS/DBMS: MS-SQL Server 2000/2005/2008, Oracle 8 /Oracle9i Enterprise, MS Access, Excel, ERWIN, TODD
• ETL Tools: DTS, SSIS, Data Junction, Informatica Power Center 7.1.1
• Database Utilities: MS DTS, MS Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, Replication Tools
• Design Methodologies: UML, OOP. SDLC
• Data Modeling: Erwin, MS Visio
• Programming Languages: Transact-SQL, VB 6.0, HTML, XML, VBScript, ASP.Net, VB.net
• Reporting Tools: SQL Server Reporting Services. Cognos Series 7, Business Object XI release 2, Tableau Desktop, Crystal Reports / Webi Reports
• Application Packages: MS Office 2010, MS VSS.
• Operating Systems: Windows - XP, Vista, windows server 2003, DOS, UNIX, Novell LAN
• Internet Technologies: IIS, Ms-Front Page, TCP/IP, LAN, WAN
• Scripting: UNIX, shell scripting
• MSBI Self Service Tool: Report Builder, Power View, PowerPivot, PivotTable, SSRS, SSAS, SharePoint 2013

PROFESSIONAL EXPERIENCE

Confidential

BI Solution Architect

OMS ODS Reporting. Project requirement the Reports should be generated for overall view into Order Health that will drive efficiencies in supporting Customer Order Fulfillment. Ability to proactively identify issues with the Customer Orders will help in faster resolution of these issues and thereby reducing time delays in delivering the product to the customer. Ability to meet SLAs consistently will help in reducing the customer order cancels

Responsibilities:

• Coordinating efforts with IT and Business Units and departments to ensure that the BI technical infrastructure including overall technical architecture, data structures and models, ETL processes, and reporting tools meet their needs and objectives.
• Created tabular model, data performance testing. Schedule job every 30 min data refresh
• PerformancePoint Dashboard integration with SSRS report worked with 23 filters
• Creating blue print solution for reporting.
• Reviewing HLT and LLD Documents.
• Working with SharePoint administration for setting up BI solution configuration.
• Design solution for ETL - Oracle to PDW to Tabular 30 min data refresh.
• Injecting CSS code in PerformancePoint Dashboard design.
• Part of Data mart design for reporting requirement.
• Part of UAT defect and solutions.
• Interacting with business team for Reporting design solution.
• Data topic discussion for solution and understanding the data mapping document with Operational team.
• MDS metro map update for reporting LLD for data management
• Discussion Business requirement for canned , Adhoc reports and 30 minute delta load
• Handling the team of 5 people of developer and QA in offshore and onsite.

Environment: SQL Server 2012 , Parallel Data Warehouse, Windows Server 2012 R2, SharePoint 2013, Excel services 2013, PerformancePoint ,MS Tabular Model , DAX, MDX query, Power Pivot, SSRS ,SSIS, .NET/C ,Microsoft Visual Studio 2010/12, Team Foundation Server, Maestro Job scheduler, Master Data Services MDS

Confidential

Sr. MSBI Consultant

Responsibilities:

• Being active part of Database designing team, to identify integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Created Business Intelligence BI application Solution based on the latest Microsoft Business Intelligence MSBI technology stack. I have been personally responsible for designing, building and deploying the entire MSBI front end.
• Analyzing financial reporting data with the existing Data Warehouse system environment. Exporting data load from landing area to Tabular Mode environment in SQL Server 2012
• Developed detail and summary Financials reports , line and pie chart, trend analysis reports and sub reports according to business requirement using Power View /Pivot Table, Report builder and SSRS,
• Created MDX and DAX Queries from Tabular model for SSRS Reports.
• Developing ETL packages SSIS for Data warehouse and Scheduling and monitoring the ETL packages
• Created and managed Interactivity Financials SSRS reports Parameterized, Linked, Drilldown, Drill through reports by using MS Tabular Model. Multidimensional model in SharePoint environment.
• Implemented business Intelligence dashboards using power view in SharePoint 2013.
• Using PerformancePoint dashboard designer create Drilling, Decision Tree, Scorecard, Strategy maps, KPI filter dashboard report
• Key product area utilized also include data modelling, SSRS report subscriptions and data driven subscriptions, SSAS analysis service processing task, cube processing option and role.
• Developed a tabular model for financial Reports account payable, general ledger, account receivable ledger in SQL server Data Tool and Excel PowerPivot
• I performed the Installation and configuration of SharePoint 2013 with Self-service Business Intelligence Tools for users.
• Create Scheduling for Database Backup and SSIS packages, SSRS.
• Created web application, site Collection, custom list, libraries, custom page layouts content types. Application management in SharePoint2013

Environment: SQL Server 2012 , Windows Server 2012 R2, SharePoint 2013, Windows azure, Excel services 2013, PerformancePoint ,MS Tabular Model , DAX, MDX query, Power Pivot, SSRS ,SSIS,SSAS , .NET/C ,Microsoft Visual Studio 2010/12,

Confidential

MSBI Developer/ Architect/ Sr. SQL Server Engineer

Responsibilities:

• Work closely with the Business analysts for requirements gathering, designing the database and creating workflow for report.
• Create Complex Store T-SQL Procedure for Medicare Reports using Recursive Queries using Common Table Expressions CTE , derived table, Pivot Table.
• Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions Range and List partitions .
• Create batch jobs to pull data from Database/user interface using T-SQL scripts/SSIS jobs to schedule them for periodic data backup for post-trade analysis.
• To design the ETL flow using SSIS and SQL Server 2008 and integrate it with existing system There is a common package- Parent package which dynamically execute the child package using configuration information .
• Experience in analyzing the existing Data Mart system environment. Exporting data load from landing area to Data Mart environment.
• Worked on SSIS Packages Documentation, source, archive, Stage path mapping.
• Create and managed Interactivity to reports by using Reporting Service SSRS.
• Created types of SSRS report Parameterized, Linked, Drilldown, Drill through, Customized, dashboards, KPI reports, graphics in SharePoint environment.
• Created data consolidation reports for account executive.
• Created SLA Service level agreement reports in SSRS, scheduling, formatting, Switches, Emailing, Sub report and implemented business working hours and holiday in reports.
• Developed different Scripts for the Data analysts for Verification of Reports.
• Using Team Foundation Server TFS for Configuration Management and Version Tracking.

Environment: SQL Server 2008, T-SQL, C .Net Programming, Team Foundation Server TFS , Microsoft Visual Studio 2010/12. Framework 3.5, erecruit, windows 2008 r2

Confidential

MSBI Developer/ Architect / Sr. SQL Server Developer

Responsibilities:

• Work closely with the Business analysts for requirements gathering, designing the database and creating workflow.
• Being active part of Database designing team, to identify integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Created Complex Store Procedure for Medicare Reports using Recursive Queries using Common Table Expressions CTE , derived table, Pivot Table.
• Scheduling and monitoring the ETL packages.
• Worked on SSIS Packages Documentation, source, archive, Stage path mapping.
• Designed the staging database in order to extract and load the data from various sources optimally.
• Develop Exception handling process and audit process for each ETL package for each ETL package.
• Create batch jobs to pull data from Database/user interface using T-SQL scripts/SSIS/DTS jobs to schedule them for periodic data backup for post-trade analysis.
• Elimination of the double-entry process using SSIS Integration with C .net Web Services API.
• Working with SSIS Integration using Web Services for Ultimate Software, delivering the best HR and payroll software to help you improve your workforce management.
• Using Team Foundation Server TFS for Configuration Management and Version Tracking.

Environment: SQL Server 2008, T-SQL, C .Net Programming Team Foundation Server TFS , .Net Framework 3.5, Ultimate Software Ultipro, Windows 7

Confidential

ETL Developer / Senior Software Engineer

Responsibilities:

• Work closely with the Business analysts for requirements gathering, designing the database and creating workflow.
• Being active part of Database designing team, to identify integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Co-ordinate with offshore team in India for ETL design development.
• Created Complex Store Procedure for Medicare Reports using Recursive Queries using Common Table Expressions CTE , derived table, Pivot Table.
• Debugging using TOAD, Extensive error and event logging
• To design the ETL flow using SSIS and SQL Server 2008 and integrate it with existing system There is a common package- Parent package which dynamically execute the child package using configuration information .
• Developing ETL packages SSIS for Data warehouse.
• Worked on SSIS Packages Documentation, source, archive, Stage path mapping.
• Develop Exception handling process and audit process for each ETL package for each ETL package.
• Designed the staging database in order to extract and load the data from various sources optimally.
• Made strategy for ETL process and designed the basic flow to be re-used within the Project.
• Designed the workflow and take the ownership of some very complex SSIS packages.
• To design the architecture of database for data warehousing.
• Extracting data from source systems and bringing the data into the data warehouse using ETL.
• Prepared Mapping documents and design documents for data conversion.

Environment: SQL Server 2008, Oracle 11g, T-SQL, C .Net Programming, SSIS, Team Foundation Server TFS , TOAD, Windows 7

Confidential

Senior Consultant - OEM Report Project / MSBI Developer

Responsibilities:

• Interaction with business and technical teams, with clients, technical architects, project managers, requirements analysts, testing teams.
• Planning and designing Data warehouse for Original Equipment Manufacturer OEM auto Sale.
• Created Complex T-SQL queries for Auto Metric Reports using Recursive Queries using Common Table Expressions CTE , derived table, Pivot Table.
• Design the ETL flow using SSIS and SQL Server 2005 and integrate it with existing system.
• Develop Exception handling process and audit process for each ETL package for each ETL package
• Developed different Scripts for the Data analysts for Verification of reports.
• Create Scheduling for Database Backup and SSIS,SSRS packages
• Created Original Equipment Manufacturer OEM report Parameterized, Linked, Drilldown, Drill through, Customized, dashboards, KPI reports, graphics for Brand, Regional ,District and dealer level sales Metric reports in SSRS, scheduling, formatting, Switches, Emailing, Sub rep
• Created and managed Interactivity to reports by using Reporting Service SSRS
• Worked on SSIS Packages Documentation. Source, archive, Stage path mapping .
• To work toward designing OLAP/MOLAP SSAS , identify the dimensions, to plan schema designing strategy for implementing Cubes.
• Used TortoiseSVN for Configuration Management and Version Tracking.

Environment: SQL Server 2008, T-SQL, C .Net Programming, Team Foundation Server TFS , .Net, Framework 3.5, SCRUM/RALLY

Confidential

Senior Consultant MSBI Developer Transforming IT Management.

Responsibilities:

• Created Complex T-SQL queries for SLA Reports using Recursive Queries using Common Table Expressions CTE , derived table, Pivot Table.
• Created SLA Service level agreement reports in SSRS, scheduling, formatting, Switches, Emailing, Sub report and implemented business working hours and holiday in reports.
• Strong knowledge in Report implementation of Crystal Reports/Webi Reports/SQL Server Reporting Services SSRS and SQL Server Analysis Services SSAS .
• Extracting data from source systems and bringing the data into the data warehouse using SSIS.
• Built new Universes as per the user requirements by identifying information required from corresponding tables located in data marts via defined Universe connections.
• Developed Complex Reports Using Webintelligence and Desktop Intelligence and scheduled for distribution to senior managers/Groups.
• Created Business Object Transforming Remedy WEBI report / crystal report for CASD System.
• Business Objects Web Intelligence Reports with Date validation in hour's minute second, monthly, weekly and daily.
• Created report in Business Objects Web Intelligence with Ticket hyperlink to open ticket details in service desk environment.
• Worked with Tableau Desktop Tool to analyze and obtain insights into large data sets and create Scorecard and Dashboard report and maintain Ad reports
• Created custom fields, filter and table relationship in BO universe.
• Created Dimensions and Measurable objects with the universes as per the analysis and the report requirement.
• Use Central Management Console give rights to user and configured data connection setting for crystal reports to run report in Business Objects Web Intelligence.
• Import BO crystal report and scheduled in Business Objects Web Intelligence.
• Implemented business working hours and holiday in monthly report in Business Objects Web Intelligence.
• Created Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula features web intelligence Reports
• Interact with client meeting for review reports.

Environment: SQL Server 2005 , SQL Server 2008 SQL Reporting Services SSRS, T-SQL, Business Objects Universe, Business Objects Crystal Report, Business Objects Web Intelligence, Business Objects Enterprise XI Release 2 Info View, Tableau Desktop

Confidential

Sr. SQL Server Developer / MSBI Consultant

Responsibilities:

• Created Complex Store Procedure for Medicare Reports using Recursive Queries using Common Table Expressions CTE , derived table, Pivot Table.
• Created SSRS Reports for ReCredentiaing Reports For Analysis. Reports uses scheduling, formatting, Switches emailing SubReport.
• Developed Deployed of various parameterized packages with SQL Integration Services 2008.
• Scheduling and monitoring the ETL packages. Job, Scheduling, batch, alert error-handling and E-mail notification setting.
• Perform optimization of SQL queries in SQL Server.
• Created Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions Range and List partitions .
• Design the ETL flow using SSIS and SQL Server 2008 and integrate it with existing system.
• Create batch jobs to pull data from Database/user interface using T-SQL scripts/SSIS/DTS jobs to schedule them for periodic data backup for post-trade analysis.
• Develop Exception handling process and audit process for each ETL package for each ETL package
• Developed different Scripts for the Data analysts for Verification of reports.
• Create Scheduling for Database Backup and SSIS,SSRS packages

Environment: SQL Server 2008, SQL Reporting Services SSRS, SSIS, T-SQL

Confidential

Sr. SQL Server Developer / Consultant

Responsibilities:

• Created Complex Store Procedure for Consumer Debit Scorecard Financial Report Calculation to Match with Excel financial reports.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Creating Reports for Data comparison, Data Exception's , Modified objects, columns, Data type , Constraints
• Created SSIS packages to import and export data from Excel and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Scheduling and monitoring the ETL packages. Job, Scheduling, batch, alert error-handling, audit process and E-mail notification setting.
• Developed Reports in SSRS for Bank scorecard chart and Compliance Dashboard using complex queries.
• Create batch jobs to pull data from Database/user interface using T-SQL scripts/SSIS/DTS jobs to schedule them for periodic data backup for post-trade analysis.
• Tested, debugged and developed the technical documentation.
• Used TortoiseSVN for Configuration Management and Version Tracking.
• Created and managed Interactivity to reports by using Reporting Service SSRS
• Installed and Configured SQL Server 2008 Dot Net
• Managing security, which includes monitoring and controlling database access, assigning permissions to application owners
• Worked on Excel Transpose Data and Excel Micro for formatting data for SSIS package Load.
• Worked on SSIS Packages Documentation. source, archive , Stage path mapping
• Created SSRS Reports for Consumer Debit Report For Financial Analysis. Reports uses scheduling, formatting, Switches emailing Subreport.

Environment: SQL Server 2008 Query Analyzer, Enterprise Manager, SSIS packages, SQL Profiler , SQL Server 2000,MS Access, MS Excel, Ms Word, , Business Objects, IIS, , SQL Reporting Services SSRS, T-SQL

Confidential

Sr. SQL Developer Team Lead

Responsibilities:

• Data Upgrade conversion from SQL Server 2000 to SQL Server 2008
• Work closely with the Business analysts for requirements gathering, designing the database and creating workflow.
• Identified, modify, tested, and resolved database Upgrade conversion relate issues.
• Creating Reports for Data comparison, Data Exception's , Modified objects, columns, Data type , Constraints
• Monitor and SQL profiler and tuned queries and procedures to boost database performance
• Job, Scheduling, batch, alert, error-handling and E-mail notification setting.
• Develop Exception handling process and audit process for each ETL package for each ETL package.
• To design the ETL flow using SSIS and SQL Server 2008 and integrate it with existing system There is a common package- Parent package which dynamically execute the child package using configuration information .
• Using WMI Windows Management Instrumentation to deep access to system network information.
• Development generic code modules to be reused across the project.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Design schema and cubes for OLAP operation using SSAS.
• Developed different Scripts for the Data analysts for Verification of reports.
• Installed and Configured SQL Server 2005 and 2008.
• Worked with SharePoint environments for Implementation of reports and docs
• Managing security, which includes monitoring and controlling database access, assigning permissions to application owners

Environment: SQL Server 2008 Query Analyzer, Enterprise Manager, SSIS packages, SQL Profiler , SQL Server 2000,MS Access, MySQL, MS Excel, Ms Word, DTD, Business Objects, SSRS, Erwin ERX 3.5, Smart draw

Confidential

Sr. SQL Developer Team Lead

Responsibilities:

• Interaction with business and technical teams across geographic boundaries, with clients, technical architects, project managers, requirements analysts, testing teams.
• Worked on the entire Software Development Life Cycle SDLC processes including Analysis, Design, Programming, Testing and Documentation.
• Gather client requirements and translate to mapping documents
• Developed database objects such as SSIS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Develop Exception handling process and audit process for each ETL package for each ETL package.
• Scheduling and monitoring the ETL packages.
• Experience in re-writing pre-existing DTS and VB ETL packages/programs
• To design the ETL flow using SSIS and SQL Server 2005 and integrate it with existing system There is a common package- Parent package which dynamically execute the child package using configuration information .
• Develop generic code modules to be reused across the project.
• Developed different Scripts for the Data analysts for Verification of reports.
• Performed data conversions from flat files into a normalized database structure.
• Managing historical data from various heterogeneous data sources i.e. Excel, Access .
• Modified the existing database by adding tables and relationships to support online Trust Transaction system.
• Database planning in relation to physical and logical data architecture
• Responsible for database backups, data replication, encryption and database security
• Worked with SharePoint environments for Implementation of reports and docs
• Standardized all automated database maintenance plans.

Environment: SQL Server 2008 ETL Tools , SQL Server 2000,MS Access, MS Excel, Ms Word, DTD, Cognos, SSRS, Erwin

Confidential

Sr. SQL Server Developer Team Lead

Responsibilities:

• Successfully migrated old data from legacy systems FoxPro and external system including text and excel into SQL Server 2005 using DTS, BCP, SSIS and ActiveX scripts.
• Developed Deployed of various parameterized packages with SQL Integration Services 2005.
• Created and managed Interactivity to reports by using Reporting Service SSRS
• Monitor and SQL profiler and tuned queries and procedures to boost database performance.
• To work toward designing OLAP/MOLAP SSAS , identify the dimensions, to plan schema designing strategy for implementing Cubes.
• Actively participated in user acceptance testing and troubleshooting various production issues
• Responsible for database backups, data replication, encryption and database security
• CRM Salesforce.com Data Integration with MS Office using macro's and .net technologies.

Environment: SQL Server 2000/2005/2008Enterprise Edition, Data Junction, Informatica, MS Access, MS Excel, DTD, Windows, SSIS, Erwin ,Smart draw

Confidential

Sr. SQL Server Developer / Data Analyst

Responsibilities:

• Developed DDL scripts for tables, indexes, stored procedures, triggers and other SQL Server objects
• Provide enhancements and maintenance support to current application
• Involved in queries optimization using tools such as SQL Profiler, Tuning Advisor, and statistics IO.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Deployed SSIS packages to production, schedule them to run on routine basis and monitor the error log for any errors

Environment: SQL Server 2000/2005, VB.Net, ASP.Net, XML, VB Script, VBA, Visual Source Safe, SSIS