OBJECTIVE:

In quest for a position through which I can utilize my skills of Business Intelligence and Data Warehousing to contribute to a success of an organization’s Information System architecture. To acquire a challenging position that would allow me to enhance my skills while delivering excellent results.

PROFILE SUMMARY:

• Over 12+ years of extensive experience in the design, development and implementation of business and data warehouse projects.
• Good exposure to Data Virtualization and jagged data reporting.
• Expertise in applying best practice to satisfy business requirements for Organizational Data warehouses and operational systems.
• Worked with end - users to identify business needs and draw out proof of concept strategies.
• Experience in working on large multi-tier data warehouse projects for various industry segments.
• Have experience in defining Master Data Management policies to maintain organization-wide knowledge base.
• Experience in working with Multi-Dimensional Data Model
• Exposure working with IBM DataStage V8.5 and earlier versions.
• Expertise in Informatica Power Mart/PowerCenter 10.2/9.6 (ETL Tool).
• Over 3 years of experience in ETL development using Informatica PowerCenter and power mart tools.
• Worked with multiple databases like Oracle, SQL Server and Sybase.
• Experience in programming R, PL/SQL, T-SQL, MDX, DMX & XMLA. Designing analytics using SSAS and Data Mining Algorithms.
• Good logical and physical data modeling skills.

WORK EXPERIENCE:

Confidential

Director - (Database Development & Reporting), Jersey City, NJ

Responsibilities:

• Handle historical data conversion effort, since the volume of this information is too large. The SSIS process is supported keeping in mind the hardware sizing and capacity of resources.
• Built a common interface process that will act as a data bus using SSIS to bring in claims & expenses information from Enterprise Data Warehouse.
• Built Financial Reconciliation SSRS Reports to validate data loads against General Ledger on quarter over quarter basis and ITD.
• Create Multi-Currency conversion process to calculate various measures in applicable currency forms that follow corporate standards.
• Design ETL (SSIS) processes to bring over data from various sources to build central Financial Reporting Database.
• Improve database design that will be able to hold policy & claim aggregated information which will be further used for end user reporting.
• Support process changes & plan for long term impacts on efficiency on the processes when they are moved to production.
• Suggest changes to SSIS package that can extract & load large volumes for information which will be used for UAT.
• Designing subsystem to store accruals and spread unallocated expenses which will help us sunset a legacy system and support ADW development efforts.
• Created earnings routine for upcoming Arch Datawarhouse project, which calculates transaction based earnings for multiple systems.
• Built SSIS process to load policy transactions into ADW, this has been integrated into daily transaction load process.

Environment: MS SQL Server 2016/2012, TFS, QlikView, Cognos, Informatica 10.2, WINS, Tableau

Confidential

Vice President

Responsibilities:

• Responsible for delivering key sales reporting for senior management on a daily basis.
• Design reporting environment for delivering key metrics so that can be used for cross functional analysis at banking center levels.
• Migrate ETL processes designed for SSIS 2005 and redesign them to be utilized for SSIS 2008.
• To come up with processes that are easy to maintain & configure for new SQL server 2008 Environment.
• Participate in implementing ETL processes and maintain JAMS jobs so that the processes meet SLA requirements.
• Designed new SSIS packages that could move data & files between various systems and effectively report on the health of the process.
• Worked on System Space Management Reporting project that was responsible for getting information about space used by various systems and users.
• Designed space management reports in SSRS 2008 that were to be used by senior management.
• Working on E2E Data Migration project to analyze performance of new accounts by creating a repository in Teradata environment.

Environment: SQL Server 2005/2008 Suite, SSAS, SSIS, Visual C#.net 2008, Teradata 13.11, JAMS

Confidential, NY

Sr. Data Warehouse Engineer

Responsibilities:

• To design ETL specifications in DataStage for the moving data from Confidential Business Systems to ODS.
• Implement Agile methodology to DataStage job development and co-ordinate with off-shore & on-shore development teams.
• Perform source system analysis and create test plans for data audits and design automated testing scripts for standard reporting.
• Use DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
• Troubleshoot DataStage jobs, fixing bugs and addressing production issues like performance tuning and enhancements.
• Developed SQL Queries for implementing Complex business rules and transformations.
• Participate in Data Vault design and Business Data Marts for various company initiatives.
• Evaluating Data Virtualization tools for creating Cloud Computing environment as a Business System of future.

Environment: Oracle 10g, SQL Server 2005/2008 Suite, Visual Studio.NET 2005/2008, IBM DataStage v8.5, SSAS, SSIS, ER Studio 9.1,Visual C#.net 2008

Confidential, NJ

Manager Data Strategy (Data Warehouse)

Responsibilities:

• To analyze users’ reporting requirements and discover data in the source system that can be utilized to do so.
• Design a new integration process using SSIS that will work with the existing integration architecture & be flexible for future data load process changes.
• To add claims related data into the existing data warehouse architecture and ensure that it correlates with policy and relevant information.
• Ensure development follows SOX standards and be responsible for getting relevant approvals and support internal audit process.
• Work with report development team using Information Builder to deliver expected information for senior management.
• Support ad-hoc reporting requirements and develop new views for the purpose.

Environment: Windows 2003 Server, SQL Server 2005/2008 Suite, Visual Studio.NET 2005/2008, Information Builder, SSAS, SSIS, MS Visio

Confidential, NJ

Enterprise Applications Architect (Business Intelligence)

Responsibilities:

• To design staging database for capturing key information from various data sources like JDE, Corrigo, BuildPro etc.
• Create a relational database that adheres to business rules, and define MDM policies based the organization’s business.
• Design the Star Schema for purchasing department’s data warehouse and also to promote and update the data in the data warehouse.
• To design various SSIS packages that supports the extraction, cleaning and transformation of data to feed the staging database and data warehouse.
• To design OLAP architecture via SSAS to support analytics requirement for the company’s ad-hoc reporting and data mining needs.
• To design and create major reports using SSRS to support managerial reporting from the DW and OLAP Cubes. Write MDX queries to extract data out of Cubes.
• Meet end-user to survey their reporting needs and their business habits; to understand their specific requirements so that future development to the DW can be smooth.
• To developed unified reporting environment using SSRS to support BizTalk Reporting, B1440 Sales Reporting.
• To define security policies for the reporting environment that complies with companywide SOX policies.
• Helped in converting data from legacy and acquired systems to various systems used by the company.

Environment: Windows 2003 Server, SQL Server 2005/2008 Suite, Visual Studio.NET 2005/2008, Crystal Reports, SSAS, SSRS, SSIS, Linq, MS Visio, IBM DataStage v7.5

Confidential, NY

Data warehouse Developer

Responsibilities:

• To design a data warehouse solution keeping in mind the organizational needs. Define various processes to procure the data.
• Creating the necessary dimension tables to store & update the data.
• Create fact table loading scripts in PL/SQL to cleanse and load data in target tables. For the purpose I have used triggers & cursors extensively.
• Create DTS packages to handle data load & updates.
• Write Stored Procedures to manage data and also create stored procedure that feed Views for reporting purposes. Create MDX scripts to deliver analytical reporting
• Design and define reports that suffice business goals of various business groups in the company.
• Designed reports using reporting services, have extensively used Dynamic SQL and SQL Injections to allow dynamic parameterization of reports & also defined the user security rules for each report.
• Created data-Cube in SQL Server Analysis Services to accommodate ad-hoc queries from senior management.
• Responsible for understanding the business process of various business groups and design business rules to update & hone the Data warehouse.
• Designed a data warehouse using Ralph Kimball Model to capture data from Pivotal CMS 3.1 CRM system & the existing financial system in Great Plains.
• Integrated IMS Marketing database with the DW in an effort to optimize versatility of the DW reports. Also to look for other databases in the organization that can add value to the existing data warehouse.
• Developed the layout for data-mart that will accommodate data from three different off-site sources.
• Helped create business rules to qualify data to be included in the data-mart.
• Worked with a team of consultants to code the required stored procedures for DTS packages that will build the physical data-mart.

Environment: Windows 2000 Server, SQL Server 2000, Visual Studio.NET 2003, Crystal Reports, Reporting Services, MS Access, SOAP, SQL Server Analysis Services, SQL Server Data Mining, Web Focus 5, Alterian 2.3 SP3, Pivotal CMS 3.1, ERWIN