SUMMARY:

• Possess 8+ years of multi international experience from fortune global companies in various data warehouse domains Health, Insurance, Finance, Sales, Retail, Supply Chain and Logistics .
• Successfully implemented various Data Warehousing projects that had a direct bottom line impact in information technology enterprises in a span of 8+ years, using various versions of sources MS - SQL Server, Oracle, My-Sql, Sybase and Tera data using the tool MS- BI-Stack of SSIS, SSAS (Multi/Tabular) and SSRS .
• Expertise in SDLC life cycle of each level, collecting functional business requirements and documentation which includes business requirements FSD and TSD document mapping, technical planning Designing, Development, Testing and Product deliverables to production
• Having good experience staging phases of the projects with support of Data Dictionaries, Data-Flow Process Models, E-R Diagrams Erwin methodology , unit testing, integration testing methodologies, disciplines, resources planning and scheduling.
• Having extensive experience by applying Agile methodology/Scrum and water fall models of DW complete life cycle projects of design and deployments
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in Tabular and multi-dimensional modeling.
• Having good experience developing Physical data modeling and Logical Data modeling
• Good experience on Data vault model, Data warehousing model and Erwin designing model .
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using MS-Visio
• Having good experience on Performance tuning, Execution plan and SQL profiler.
• Hands on experience on various self-service dashboards Power-BI and Qlik sense with deployments, refreshing dashboards according to user permissions
• Worked on UDW system and possess banking domain knowledge on Reporting Processes, Compliance and Risk Management SQA and QC analysis Processes.
• Extensive working experience on in bug tracking Tools usage - HP ALM Quality center, JIRA.
• Profoundly worked on Version controls of SVN, TFS, VSTS and Visual Source Safe .
• Profound experience on SSIS, SSRS, SSAS deployment’s and maintenance of L1/L3 support with required service and proxies and granular level permissions of regional security levels.
• Experience in s to Users and Stakeholders before UAT and Production Signoffs. Database Optimization (SQL, SSIS, SSRS & SSAS-(Multi/Tabular))-MDX
• Strong experience in SQL Server, SSIS (SQL Server Integration Services) 2014/2012/2008/2005/2000 , SSRS (SQL Server Reporting Services), SSAS (SQL Server
• Analysis Services), Tabular Analysis Services.
• Expertise in “Extracting” data from different source servers SQL, Oracle, MS-Access, Excel, Sybase and. Csv. “Transformation” through (ETL-SSIS), Loading into Staging, Data Mart’s Warehouse and Cubes then having extensive experience on creating SSRS and ad-hoc reports.
• Advanced level of expertise in T-SQL, PL-SQL, Joins with sub query writing views/Materialized views, stored procedures, functions, Table valued functions, Triggers and Cursors 

TECHNICAL SKILLS:

• Data WareHouse Technology: SSIS, SSAS (Multi - Dimensional/Tabular), SSRS
• Databases: MS- SQL Server, MY-SQL, Oracle11g,Sybase,Tera Data, Netezza
• Languages: T-SQL, PL/SQL, X-Query, MDX, DAX, Adv. Excel Functions
• Version Controls: TFS, VSTS, Visual Source Control, SVN
• Testing Tools: HP Quality Center/Test Director, ALM, JIRA
• Automation Tools: SQL Server Agent, Active Batch
• App. /Web Servers: C#, SharePoint 2013,Vb.net, Macro s, IIS 7.5/8 .0
• Visualization Tools: Power-BI, Tableau, Qlik Sense, Qlik-View Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr. MSBI Consultant

Responsibilities:

• Collecting and gathering Business requirements from Business Users and Product Owners.
• Changing and Updating Data mapping documents and creating data dictionaries.
• Creating warehouse marts by using various Stored Procedures, Functions, Views.
• Worked on SQL and SSDT upgradation to 2017.
• Working on ODS sync’s through SSIS Packages while collecting data from different applications.
• Working on C# lookup’s and Hash mappings to create warehouse by using various transformations.
• Creating custom loggings, Event handlers and configurations and deployments
• Creating Entities, Attributes and Members in MDS.
• Loading Star schema warehouse by using various SSIS Package frameworks
• Creating Tabular Cubes and Perspectives with different roles of Securities.
• Analyzing and Profiling data while creating new datasets either for Marts, Cubes and reports.
• Creating In-Memory Tabular cubes, fact less facts, cumulative facts and dimensions.
• Implementing DAX and M-queries for Tabular Cubes and Power-BI Reports
• Changing JSON queries according to Story requirement’s.
• Creating various SSRS reports, Mobile reports and Power BI Dashboards.
• Support dba for production deployments while writing proper deployment notes and scripts.

Involved Technologies: MS-SQL -2017, SSIS SSAS(Tabular), SSRS, Mobile Reports, Power-BI, C # and VSTS.

Confidential, Knoxville, TN

SSAS Lead

Responsibilities:

• Giving and creating awareness of Processing of Cubes in various methods and MDX query writing
• Developing Linked Measures and designing aggregations on partition levels.
• Collecting metadata of SSAS Cubes through DMV queries and keeping documentation for future
• Developing dynamic SSIS Package framework to create SSAS Partitions and Process SSAS Cubes
• Writing Xml, SQL queries to develop SSIS Package Framework
• Improving performance of writing DMV and MDX queries to re-generate stand-alone reports.
• Cleaning of Cube structural wise, members according to Jira Tickets
• Xml code changings in Script task to re-write custom codes.
• Developing User defined functions, Stored Procedures and T-SQL code to call MDX and DMV Queries.
• Developing confirmed dimensions, Role-played dimensions.
• Changing hierarchies and attribute relationships according to business requirements.
• Integrating SSAS Cubes with External Sync’s of data stage jobs.
• Developing Active Batch jobs to synchronize SSIS packages for dynamical runs with external tables.

Involved Technologies: MS-SQL, Netezza, Active Batch, SSAS, MDX, SSIS and C #.

Confidential, PrinceFederick, MD

Senior BI Architect Duration:

Responsibilities:

• Involved in the business requirements understanding, expectations and warehouse development and design.
• Involved in the planning and design strategy meetings partially conducted under agile methodology.
• Involved in prototyping the critical requirements, proof of concept preparation.
• Automation of SSIS Packages for production deployment with xml configurations.
• Created bundled SSIS packages by using for-each loop container and executed with parallel processing
• Developed Historical/Incremental of SSIS Packages with SCD2 concept of Star Schema
• Gathered good knowledge on Incremental load of SCD2 with the implementation of KPI’s.
• Managed the historical and Incremental data in warehouse with support of various Stored Procedures, Table valued Functions and Indexed-Views to meet business requirement.
• Designed and developed various SSIS packages with script component with Custom Check points, Event Handlers Custom loggings for task and package level and created XML Package Configurations
• Experience in Performance Tuning in SSIS packages by using Row, Block and Unblock Transformations.
• Developed SSRS Tablix reports by using grouping for business executive usage and deployed into servers.
• Developed materialized views/stored Procedures/Sql join sub queries based on FSD.
• Wrote Power shell scripts to automate build deployment of reports and packages into production environment.
• Developed reports from Azure database and created different subsets and storing Blob and table storage
• Involved in Qlik-sense report testing and modified few formulas according to financial rules.
• Worked on Qlik-sense dashboard by creating new pages and publishing new pages for executive calculations.
• Involved in the system specification documentation, planning and design strategy meetings.
• Involved in prototyping the critical requirements and work division, test scenario preparation.
• Involved in migration of BO reports into Qlik sense and Power-BI reports

Involved Technologies: MS-SQL, SSRS, SSIS, Qlik-Sense, Power-BI

Confidential

Power BI Architect Duration:

Responsibilities:

• Created Policy Cube in both Tabular model and Multidimensional model with Star Schema vs. 2012.
• Gave User on Power-BI Usage before UAT signoff and Production Signoff.
• Involved in the business requirements understanding and needs of the systems developed in iteration fashion.
• Involved in the planning and design strategy meetings partially conducted under agile methodology.
• Involved in prototyping the critical requirements, proof of concept preparation.
• Involved in the designing of the sub systems and architecturally critical components.
• Developed Tabular Designing of Data modeling for Power view reports with In-Memory and Direct query.
• Created Fact less Fact tables and degenerated dimensions to meet Business logic in SSAS cubes. Designed data warehouse Dimension/Fact tables for Insurance, Policy and Commodity data.
• Analyzed FSD , developed TSD with Data Dictionary writing Operational guide.
• Developed Historical/Incremental of SSAS cubes with SCD1 concept of Star Schema
• Increased the performance while implementing Proactive caching with MOLAP .
• Developed and designed Power - Pivot and Power Map data modeling’s with Cross functional sources
• Gathered good knowledge on Incremental load of SCD2 with the implementation of KPI’s.
• Developed MDX and DAX queries to get calculated measures by using time intelligence
• Managed the historical and Incremental data in warehouse with support of various Stored Procedures, Table valued Functions and Indexed-Views to meet business requirement for SCD1 concept.
• OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Wrote MDX queries using various Mdx functions to implement Calculated Measures .
• Developed calculated members and Named Queries in SQL Server 2012 Analysis Services (SSAS).
• Processing Cubes by SSIS Custom Packages and Xmla scripts.
• To Process SSAS cubes, designed and developed various SSIS packages with Custom Check points, Event Handlers Custom loggings for task and package level and Package Configurations by using Env variables
• Developed materialized views/stored Procedures/Sql join sub queries based on FSD.
• Created multiple hierarchical aggregates for faster performance, developed Non-Clustered indexes to improve query performance and query optimization
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions. Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Implemented Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Involved in the system specification documentation, planning and design strategy meetings.
• Involved in prototyping the critical requirements and work division, test scenario preparation.
• Developed x-query to get metadata from all SSIS Packages and cubes and prepared data dictionary.

Involved Technologies: MS-SQL, SSAS (Multi-Dimensional), Tabular-SSAS, SSIS, Power-BI, Qlikview

Confidentila

Power BI Lead Duration:

Responsibilities:

• Leading Off-Shore team to generate SSRS and Power pivot reports.
• Gathering requirements from business users and converted into TSD and FSD.
• Developed master level SSRS and Power Pivot reports and deployed into SharePoint site.
• Developed Excel macros with VBA code, MDx queries for Pivot tables.
• Gathered Specifications from different countries, designed and developed a Non-SAP based cube.
• Adding calculated measures, Scope’s in the cube level, Hierarchies and Role-Played dimensions.
• SharePoint central administration maintenance, involving in web part designing and Security group level permissions audience targeting and image navigation for user respective files.
• Extracted the data from interfaces (SQL, Excel) through SSIS Package pushed to Staging, used SHA algorithm’s and merge Join to maintain “Historical and Delta” load to pump the data into DataMart with respective dimensions and Fact tables.
• Developed a localized cube with aggregations and respective partitions and deployed with SSIS JOB.
• Developed a small-scale cube with few dimension and facts while adding Aggregations, scope level members and measures and hierarchies.
• Scheduled cube in SQL Agent through SSIS Package and implemented Loggings.
• Created Regional Level Roles and Permissions on cube
• Migrated SSRS reports into Power-BI reports.

Involved Technologies: MS-Sql Server 2012, SSRS-2012, SSAS, SSIS, Sharepoint-2013, Power-BI