SUMMARY

• Microsoft Certified Professional, with over 15 + 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 ( )
• 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 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
• 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, Richfield, MN

Sr. BI Solution Architect / MSBI Consultant

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 HLD 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, Power View, Power Map, Power BI for Office 365, SSRS, SSIS, .NET/C#, Microsoft Visual Studio 2010/12, Team Foundation Server, Maestro Job scheduler, Master Data Services (MDS)

Confidential, IN

Sr. MSBI Consultant

Responsibilities:

• 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.
• Created and managed Interactivity Financials SSRS reports (Parameterized, Linked, Drilldown, Drill through reports) by using MS Tabular Model. Multidimensional model in SharePoint environment.
• 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
• 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, Power View, Power Map, Power BI for Office 365, SSRS, SSIS,SSAS, .NET/C#, Microsoft Visual Studio 2010/12

Confidential, MA

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).
• Created types of SSRS report (Parameterized, Linked, Drilldown, Drill through, Customized, dashboards, KPI reports, graphics) in SharePoint environment.
• Created SLA (Service level agreement) reports in SSRS, scheduling, formatting, Switches, Emailing, Sub report and implemented business working hours and holiday in reports.

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, MD

MSBI Developer/ Architect / Sr. SQL Server Developer

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 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.

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

Confidential, NJ

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.
• 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.
• 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, MA

Senior Consultant - OEM Report Project / MSBI Developer

Responsibilities:

• 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.
• 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.

Environment: SQL Server 2008, T-SQL, C# .Net Programming, Tortoise SVN, .Net, Framework 3.5, SCRUM/RALLY

Confidential, AR

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.
• 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.
• Worked with Tableau Desktop Tool to analyze and obtain insights into large data sets and create Scorecard and Dashboard report and maintain Ad reports
• 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

Environment: SQL Server, SSRS, T-SQL, Business Objects Universe, Crystal ReportWeb Intelligence, Business Objects Enterprise XI Release 2 Info View, Tableau Desktop

Confidential, VA

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).
• 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.
• Design the ETL flow using SSIS and SQL Server 2008 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

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

Confidential, CO

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
• Scheduling and monitoring the ETL packages. Job, Scheduling, batch, alert error-handling, audit process and E-mail notification setting.
• 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.
• Developed Reports in SSRS for Bank scorecard chart and Compliance Dashboard using complex queries.
• 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 2005/2008/2000, BO, IIS,, SQL Reporting Services SSRS, T-SQL