PROFESSIONAL SUMMARY:

• Over 9+ years of IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, Business Intelligence, Database Management, Programming testing and documentation.
• Extensive experience in Installation, Configuration and Updates of SQL Server.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications and Hyperwallet Platform Data Model.
• Designing and Deployment of Reports for the End - User requests using Web Interface & SSRS.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Knowledge on Microsoft Azure Analytics platform-Azure Data Factory, Storage, Azure Data Lake etc,.
• Includes experience with Architecture, Design and Installation of large scale Business Objects Enterprise (Clustered Environment).
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Experience in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
• Experience in deploying SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Working knowledge of automation scripts which used REST APIs to extract data from blob storage of Azure Cloud Services
• Involved in migration of SSIS Packages 2012 SP1 CU5 and troubleshoot migration issues.
• Experience of SQL Server 2008 R2, 2012, SSIS, SSRS, PL/SQL, Oracle 10g/11g , Teradata, DB2, Stored Procedures and Functions.
• Expertise over preparing report specifications, database designs to support the reporting requirements.
• Expertise in the Analysis and Data Warehousing Development of ETL data flow design by using Business Objects Data Services XI 3.2/Business Objects Data Integrator 11.7.2.
• Experience in creating customized and complex reports using Business Objects.
• Strong skills interfacing Business Objects with Databases like Oracle, Sybase, Teradata, Netezza and SQL Server.
• Extensive experience working in Agile driven environment with emphasis on Test Driven Development.

TECHNICAL SKILLS:

OLAP/BI Tools: SQL Server 2008 R2/2005/2012, SSIS, SSAS, SSRS, Power BI, SAP Business Objects XI R2/XI 3.1/ BI 4.0 (WebI, Universe Designer, Xcelsius2008, Infoview/BILaunchpad)

ETL Tools: SSIS (Designer, Workflow Manager, Workflow MonitorRepository manager and Informatica Server)

Languages: SQL, T-SQL, MDX, .Net, C# and PL/SQL

RDBMS: Oracle 10g, 11g and 12c, SQL Server 2008 R2/2005/2012, Sybase, Teradata, Netezza

Other Tools: : MS Office (Word, Excel, PowerPivot, PowerPoint), JIRA

PROFESSIONAL EXPERIENCE:

Confidential

MSBI Consultant

Responsibilities:

• Create various database objects (tables, indexes, views, stored procedures and triggers) and implement referential integrity constraints for enforcing data integrity and business rules.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
• Developed SSIS packages for migrating data from staging area of SQL Server 2008R2 to SQL Server 2012.
• Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS various features like multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.
• Built reports in SSRS for errors generated by SSIS Packages.
• Worked on escalated tasks related to interconnectivity issues and complex cloud-based identity management and user authentication, service interruptions with Virtual Machines (their host nodes) and associated virtual storage (Blobs, Tables, Queues)
• Build relationship with team and individuals at all levels of the organization.

Environment: Windows 2008, MS SQL Server, MS Office, Visual Studio, Database Engine Tuning Advisor, MDX, SQL Server Management Studio 2010, SSIS, SSRS, Power BI, Azure Cloud.

Confidential

MSBI Developer

Responsibilities:

• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Reverse engineered backend database to change the T-SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance drastically.
• Experienced working in the Agile methodology.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Involved in creating VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created various types of performance reports from the TFS server database using SSRS.
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
• Build relationship with team and individuals at all levels of the organization.

Environment: SQL Server 2012, SQL Server Integration/Reporting Services, Power BI, Visual Studio 2010, MDX, C#, Jenkins, SQL Server BI Development Studio 2012, Windows 2008 Server.

Confidential

Business Intelligence Developer

Responsibilities:

• Gather business requirements from the stakeholders, analyze the requirements and generate Universe based on Data Model using Star flake Schema.
• Develop Web intelligence reports on top of Claims Universe/DataMart using Open documents, Cross tabs, slice and dice for generating master/detail and tabular reports.
• Create dashboard, charts and pivot table in Excel by connecting to SSAS cubes.
• Create dashboard, charts and pivot table in Excel by connecting to SSAS cubes and Power Pivot.
• Created KPI reports by analyzing data.
• Gather requirements from business stakeholders and convert them to technical specs and functional spec.
• Implemented complex reports including sub-reports, graphical reports, formula base and well-formatted reports according to user requirements.
• Support system and reports after go live.
• Monitoring and tuning jobs/queries and monitoring performance.
• Utilized Designer functions like @Select, @Prompt and @Aggregate Aware with summary tables for query optimization.

Environment: SQL Server 2008 R2, SSAS, SSRS, Business Object XIR3.1, BI4.0, Information Design Tool, BI4.0, Designer, Netezza, Aginity, CMC, MDX, MS SQL Server 2012, SQL, PL/SQL, Windows 7

Confidential

Business Intelligence Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Developed SQL scripts/queries in backend testing of Databases
• Write SQL code to Analyze data and check data transformation.
• Performing Business Objects (MI Reports) testing through Business Intelligence.
• Verifying migrated Account and Customer data across the data warehouse systems.
• Created KPI reports by analyzing data.
• Experience in implementing SAP Authentication with Business Objects and creating reports.
• Running SQL Profiler to monitor process /queries behind application or queries.
• Build relationship with team and individuals at all levels of the organization

Environment: Business Objects XI 3.1, Hadoop, Sqoop, Oracle 10g, SQL Server 2008, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX

Confidential

BI Consultant

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Involved in Architectural aspect, sizing, clustering, Mapping AD users and Single sign of Business Objects.
• Create universes (classes and objects) from SAP and Non SAP data sources and defined the necessary connections.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.

Environment: Business Objects XI 3.1, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows.

Confidential

ETL Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load.
• Create Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.

Environment: Informatica Power Center 8.6/8.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational Tools, Clear Case, UNIX Shell Scripts.

Confidential

ETL Developer

Responsibilities:

• Design, develop, test and maintain Universes, DeskI and WebI reports.
• Extracted data from Oracle as one of the source databases.
• Followed Star Schema to design dimension and fact tables and also experienced in handling slowly changing dimensions.
• Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Scheduled the tasks using Autosys, and Loaded the flat files data using Informatica to the staging area.

Environment: Windows XP/NT, Informatica Powercenter 9.1/8.6, Oracle 11g, Oracle Data Integrator, SQL, PL/SQL,SQL Developer, ER-win, Business Objects XI R2, Designer, Oracle Designer, Autosys, Quality Center 10.