SUMMARY:

• Microsoft Certified with 12+ years experience in Business Intelligence, Enterprise Data warehousing & advance analytics implementation within several business areas like Pharma Life Science commercials, finance, Compliance & Clinical Trial Management System, Banking Finance - Home Equity (loans, Collections, Loss Mitigation), Equity & Derivatives, Commercial Card, CRM, Accounting, Supply chain management, Engineering, retirement management systems, spend tracking mechanisms relevant to aggregate spend and federal reporting using Sunshine Act, B2B integration & Healthcare.
• Proficient in Data Modeling (conceptual, logical & physical data models), Enterprise Data Warehouse Design, Datamart Design, Metadata, Data Quality, Master Data Management and Data Governance.
• Experience in implementing of BI\EDW project with designing of star\snow flake schema, Data Integration ETL (SSIS), Analysis service cube (facts, dimensions, hierarchies) SSAS, data analytics & mining, ad-hoc & analytical reports \dashboard design, development, automation, error handling, administration & implementation of Devops strategies.
• Expert in designing, development and maintenance of data analytical applications (metrics, reports, analysis, KPIs& dashboard for data visualization) using report tools like Tableau, Power BI, SSRS, SSAS, Power Pivot, Excel & Spot Fire.
• Extensively worked ETL tool SSIS with extracting, cleansing and transferring the data from various data sources likeSQL Server, Oracle, DB2, Access, Excel, Csv, Flat Files, Hyperionetc. that includes error handling, logging and encryption.
• Proficientin DBA activities like SSAS, SSRS Administration, database installation, configuration, maintenance, monitoring, backups & recoveries, Replications,SQL Profile for event and logs for query performance, login and usage, Bulk Copy (BCP), Indexing, performance tuning, partitioning of large tables, query optimization and managing alerts.
• Extensive Experience in designing complex dashboards, reports and publishing it on web browser for data visualization and help systematically analyze data and share insights.
• ProficientinMicrosoft Cloud Database Services - SQL AZUREandArchitecting SQL Server Instances UsingAmazon Cloud Database ServiceRDS\EC2.
• Experience in a Compliance organization, successfully contributing to the submission of U.S. aggregate spend reports.
• Experience of Hadoop, analyzing/transforming big data using HBase, Hive/Pig and data integration between RDBMS & HDFS using Sqoop.
• Ability to quickly learn new systems, adapt and refocus in a fast paced, agile development environment.

TECHNICAL SKILLS:

Business Intelligence\Data warehouse: Microsoft BI tools Sql Server Analysis (SSAS), Integration (SSIS), Reporting Service (SSRS)

Database: - Microsoft SQL Server ( ), Oracle (10g, 9i,8i), DB2, Hyperion, Access

Analytics and Data Mining: - Sql Server Analysis Service(SSAS), Azure Analysis Service

Data Visualization Tools: - Power BI, Tableau, Sql Server Reporting Service (SSRS), Spot Fire

Design Tools: - MS Visio, Erwin

Cloud Database Service: - Microsoft (SQL AZURE), Amazon RDS\EC2

Programming: - Microsoft Visual studio ( ), .net, VB.NET, VB 6.0, ASP, Sql, Tsql, PL/Sql, MDX, DAX, HTML, XML, Python, TOAD, Rapid SQL, Vbscript, Java Script, Python

Big Data Eco System: - Hadoop, HDFS, Mapreduce, HBase, Hive, Pig, Scoop

Source Control Program: - Team Foundation Server (TFS), Visual Source Safe (VSS)

Web Tools: - SharePoint, Internet Information Server(IIS), FTP

Other: - Office365, ProClarity, Crystal Reports, MS Project, Performance Point Server, Precision Point Tool, ERP Microsoft Dynamics

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Business Intelligence Consultant

Responsibilities:

• Gathered and documented business requirements for analytical reports. Participated in the requirement meeting and data mapping sessions to understand business needs.
• Developed multiple visual options for each report for discussion with stakeholders.
• Integrated the custom visuals based on the requirements using Power BI Desktop.
• Developed complex calculated measures using Data Analysis Expressions (DAX).
• Published reports on the app and managed the access reports and data for individual users using roles.
• Provided continued maintenance and development of bug fixes for existing and new Power BI reports.
• Admin activities: Authorization, RLS, Accounts and Roles setup

Environment: - Office 365, Power BI, Microsoft BI Tools (SSAS Tabular model), SQL SERVER 2016

Confidential, CA

Sr. Business Intelligence Consultant

Responsibilities:

• Designed, developed, implemented, supported Enterprise Data-warehouse (EDW) & Business Intelligence Solutions by consolidating the data from various business areas like commercials, finance, compliance (data Integration in Client Enterprise Solutions such as Concur, Porzio, Veeva, Great Plains), clinical trial management system (EDC, CTMS, IVRS) to analyze and visualize business data quickly and easily using Data visualization tools. The solutions included strict HIPAA rules for data governance.
• End-to-end development using BI tools (ETL, Reporting, Analytics), implementation of data management strategies that supports Devops, building data analytics & mining, reconciliation, dashboard design, optimization, automation and administration.
• Integrated Custom Visuals based on business requirements using Power BI desktop
• Developed complex calculated measures using Data Analysis Expression language (DAX)
• Created and shared complex dashboards, reports and published on website to help systematically analyze data and share insights. Setup Role based security so that certain users have certain access to certain sets of information. Supported the development, optimization, and enhancement of the BI Reporting Tools Power BI, SSRS, Excel Pivot and SSAS.
• Managed multiple projects and tasks concurrently and work under minimal supervision.

Environment: - Microsoft BI Tools (SSIS, SSAS, SSRS), SQL SERVER ( ), Oracle, Hyperion, Power BI, Excel Pivot, Spot Fire Medpro, NPPES NPI Registry, Porzio, AWS, DAX, Office 365

Confidential, CA

Sr. Software Engineer

Responsibilities:

• Participated in the analyzing and understanding the business requirements. Worked with the Business Users to understand the existing process.
• Responsible for creating conceptual, Logical and physical database model and extraction, transforming and loading data with error handling and logging features.
• Worked on integration of HL7 data from Mirth Interface Engine (which was the interface for the Orchard Harvest LIS System) and the pre-diabetic calculated data for generating the predex diabetic report by maintaining HIPAA Confidential guidelines.
• Designed, developed and supported the interactive Tableau dashboards.
• Performed Unit testing and User Acceptance testing (UAT) and documented detailed results. Verified input labinformation from Harvest LIS system and the output results after calculation.

Environment: - SSIS, SQL SERVER 2012, Tableau

Confidential, CA

Software Engineer

Responsibilities:

• Integrated the data from various operational systems into one coherent set of reliable information.
• Extensively worked on data modeling, designing SSAS cubes and also worked in ETL process to extract data from Microsoft Dynamics, error handling, logging and data validation\comparison.
• Extensively worked in designing the reports using SSRS, power pivot and XL Publishers.
• Played partial DBA role like SSAS Cube, SSRS Reports and SSIS Package administration, granting access to the users, job scheduling, performance tuning, email notifications and DMV programming.
• Used Precision Point Reporting Tool to monitor the business and for the analysis.

Environment: - SSAS, SSRS, SSIS, SQL SERVER 2008, Precision Point Tool, Microsoft Dynamics (AX, FSA & CRM Module)

Confidential, CA

Lead SQL Software Engineer

Responsibilities:

• Extensively worked on advance database programming using SQL, DMV, MDX query and Cubes in Analysis Services, Integration Services and on power pivot.
• Done partitioning of large tables (size of 200 million records) & provided the aggregated values.
• Implemented the analysis service utility that tracks and logs events which is useful for understanding query and system performance, login events and usage.
• Worked on migration from SQL Server 2008 R2 to SQL server 2012 and did performance analysis and tuning.

Environment: - SSAS, SSRS, SSIS, SQL SERVER 2012

Confidential, Cheyenne, WY

Sr. Lead SQL Software Engineer

Responsibilities:

• Designed the ETL process for loading the legacy data which was in TPS files to SQL server 2008 R2 further and after cleansing again the process runs to load the clean data
• Extensively worked on the reconciliation of reports.

Environment: - Visual Studio 2010, SSRS, SSIS, SQL SERVER 2008 R2, Viso 2010 and ERWIN

Confidential, Jefferson City, MO

Lead SQL Software Engineer

Responsibilities:

• Worked on ETL process for loading the legacy data which was in Foxpro to SQL server 2008 R2.
• Created critical and major reports using SSRS on the Economic Impact Reports and COLA and conducted the data research to answer the end user queries on the data as well as on reports.
• Worked on the complex rules of economic impact, cola & benefits.

Environment: - Visual Studio 2010, SSRS, SSIS, SQL SERVER 2008 R2

Confidential, Boston MA & Phoenix, AZ

Sr. SQL Server Developer/ Data Analyst

Responsibilities:

• Extensively worked on Microsoft Reporting Services and Integration Services with backend database as Microsoft SQL Server 2005, Oracle and DB2 in both OLTP and OLAP environment.
• Heavily involved in database programming (Common Table Expressions, Stored procedure, Cursors, Views, function) in SQL Server, Oracle and Db2 using respective technology or using Toad and Rapid SQL
• Worked on the calculation, productivity, goals and forecasting with KPI’s using analytical tools like Excel Pivot Table, ProClarity and CUBES of Microsoft Analysis Service (including MDX development).
• Designed and developed the ETL process (SSIS Packages) to make the data available from the different servers and data sources for OLAP and reporting purpose within the production environment.
• Auto scheduled the daily execution of SSIS packages and procedures for data loading using SQL Server Agent or third party tool like Autosys with a confirmation emails to the business.
• Worked on other tools like ProClarity, Microsoft Office Pivot table reports for analytical purpose.
• Translated business rules and data processing activities into requirements and models suitable for system design and development
• Worked on architecting, designing solutions using SQL Server, SSIS (ETL), SSRS(Reporting) & SSAS(Analytics). Created dashboard which provides user the supplier performance areas targeted goals\ forecast.
• Demonstrated knowledge of data integration techniques such as ETL to create an integrated enterprise data Warehouse. Extracted, transformed & loaded the Source Data Excel & CSV format into the internal data warehouse system using ETL.. Task performed were data analysis, cleansing and validation before loading the data into the database to make sure the incoming information meets the required standard.
• Responsible for scheduling jobs of execution of SSIS packages & commercial card data loading from different server to streamline and automate the repeated tasks using SQL server agent.
• Reports were published using SQL Server Reporting Services and extensively worked on all the phases using analysis, design, development, deployment, scheduling, subscribing the reports and email notifications.
• Created parameterized matrix report using analysis OLAP cubes in SSRS for the segmentation analysis of the suppliers, summary information, targeted goals & forecasting & B2B Merchant opportunities. Created supplier performance areas targeted goals\ forecast dashboard and published it on the SharePoint Site.
• Performed DBA activities Roles creation, SSRS Administration, database backup & recoveries

Environment: - Visual Studio 2008(BI Visual Studio), Microsoft SQL Server, SSIS (ETL), SSRS(Reporting), SSAS (Analytics), VISO, Web services, MS office SharePoint 2007, ProClarity.

Confidential

Sr. Business Intelligence / SQL Server Developer

Responsibilities:

• Designed multi-dimensional model using Star Schemas and Snow Flake Schema.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Used Shared point for uploading the project related files and maintaining the project status and generated daily, weekly monthly trigger based reports regarding assigned projects to designated managers and clients.
• Gauged the effectiveness & efficiency of existing reporting systems. Developed & implemented strategies for improving and further leveraging these reports in order to convert existing crystal & access reports to SSRS.
• Created different type of reports & automated the process of data loading and emailing reports.
• Worked on the data migration from Ms Access to SQL Server as well from Oracle to SQL Server. Extensively worked on the database programming, SSRS(Reporting) and SSAS using OLAP Cubes and MDX queries

Environment: - MS SQL Server 2005, MS SQL Server Reporting Services 2005, SQL Server Analysis Services, DB2, SSIS, MS Access, Oracle 10g, Toad Tool, Erwin, MS Project, .net framework, Web services, Share Point, Tableau

Confidential, Mc Lean, VA

Sr. Software Engineer

Responsibilities:

• Participated in design and implementation of custom data database solution for client.
• Extensively worked on database migration, advance database programming and migration of report(crystal to SSRS).
• Played lead role in selecting & creating high performing team & maintaining safe environment & equal opportunities for participation by all team members. Identifying & evaluating the potentiality of each team members, determining need & arranging the needs for each team members, regularly communicating with the Client for removing obstacles for the team.

Environment: - SQL Server 2005, SSRS Reporting Services, .net framework, Web Services, Crystal Report