PROFILE:

Data Modeling (Dimensional & 3NF/Relational/OLTP), Data Warehouse (DWH) Architect (ETL & Reporting) (OBIEE, MSBI (SSAS/SSIS/SSRS 2012 & 2008 R2), OFSAA FSDF Data Model Consultant, OLAP - SSAS, ETL-SSIS, Informatica, Reporting - SSRS/OBIEE, SQL Server 2016, 2012 & 2008 R2 T- SQL, ORACLE 11g/8/8i/9i PL/SQL

PROFESSIONAL SUMMARY:

• Ahardworking, passionate and results-driven DWH - Architect (ETL & BI Reporting) with 17+ years of software industry experience with domain expertise across Insurance, OFSAA EPM (ALM, PFT, FTP, PM Etc.), Banking, Financial, Healthcare, Publishing, Travel, ERP-MMS with extensive business insight, consultative and analytic skills.
• Acquired a position of SME currently on MSBI (SSAS/SSIS) at Confidential in USA for GRR Cube and enhancement from legacy Cognos and New LSM (aka LRM) OLAP Data Mart on SSAS along with SSIS for ETL & SSRS for BI Reporting.
• Expertise gained over extensive hands-on experience across technical areas including creating various transformation rules to validate Extracted Data, Data Integration strategies, Data Cleansing, Data Quality Check. Confidential Practices Coding standards for ETL with SSIS & Informatica.
• Tracking dimensional data changes by slowly changing dimensions types 1, 2 and 3. In ETL with SSIS & Informatica. E2E SSIS ETL solution design & development with handling of file with dynamic named columns, SFTP set up, writing complex SQL procedure for the SSIS ETL for loading to SQL Server Data Warehouse from the file with dynamic column.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes forlarge-scaleDataWarehouses with validations, Strong error handling, Data Flow Design, Auditing, SSAS Cube refresh, Handling of excel data files with dynamic named columns with Windows PowerShell Scripts, .Net(C# & VB.Net) scripting language and logging using SSIS. usingDataTransformation Services (DTS) and SSIS with MS SQL
• Extensive experience gained on developing end to end OLAP Application on SQL Server Analysis Services, SSAS with Dimensions, Cubes, Aggregations, KPIs, partitions, Actions to invoke SSRS reports URLs through MDX expressions, Drill through, Partitions, Roles, multi-dimensional expressions (MDX) queries for calculated members, SSRS Reports for
• Experience in Providing the SSAS cube level security (Datalevel, Column level, dimension hierarchy ) using MDX Expressions.
• Developed and implemented data visualization on DSP Web parts with Drill Down, Drill through SSAS OLAP data for Confidential Bank i-On Reporting, Data Core.
• Expert in creating several types of complex reports using SSRS (SQL server reporting services) from OLAP with and OLTP such as Graph, Linked, Dashboard, Scorecards, Drill-Down, Drill-through, Parameterized, Cascading, Conditional, Tabular, Matrix, Ad-hoc, Sub-Reports, and Charts for
• Extensive technical and analytical skills with hands on experience with Multidimensional Data Modeling with Logical, Physical Data Model (LDM & PDM) using Erwin and Oracle SQL Developer Data Modeler along with Relational ER modeling and designing DWH Architecture for
• Confidential - US Global Reserve Repository (GRR) and Liquidity Stress Modeling (LSM aka LRM)
• Designing Architecture for EDW (enterprise data warehouse) using Bill Immon’s and Kimball methods.
• Performance tuning, Query Optimization and Indexing of database using SQL Profiler and Query Analyzer.
• Tuning ETL procedures and STAR schemas to optimize load and query Performance.
• Implemented Automated Excel Spread sheet Power Pivot Refresh for SSAS Cubes & Dimensions with good experience on Excel Pivot, Power view for slicing and dicing the data.
• Gained extensive experience of inside OFSAA EPM (ALM, FTP, PFT, LRM) as an ETL and Custom BI Reporting Solution Architect with Surrounding ETL/ELT and Custom BI Report development apart from Out-Of-Box OFSAA reports along with
• OFSAA OFSDF Data Model, Batch Runs, Excel Upload, SCD, T2T, T2F, Batch, PLT, DQ
• Technical Design for ETL/ELT and BI Reporting
• Dimensional modeling for Custom BI Data Mart for OFSAA PFT
• Building Custom BI Reports using OBIEE including dashboard
• DQ Check Framework and data Cleansing for ELT/ETL
• Confidential practices standards
• Automation framework
• Building ETL solutions on Informatica with workflow, data flow diagram, data flow transformation plans and techniques
• Strong working knowledge of Excel, PowerPoint, Visio, SharePoint Designer, ER/Studio
• Highly experienced on database programming with writing stored procedure, triggers, indexes, synonyms, sequences, views, functions. Subprograms, packages, designing schemas, maintain security n SQL Server T-SQL 2008/2014 n PL/SQL on Oracle 9i/10g/11g
• Experience in schema structure design and involved in estimation and optimization of data storage.
• Extracted data from different sources including SQL Server, Oracle, Excel, Flat Files and XML Files.
• Profound experience in Data Loading from Flat files to SQL Server using SSIS and External Table.
• Hand on experience using SQL Server 2016 new features PolyBase, Data Masking, Row Level Security, Native JSON Support and Stretch Database.
• Excellent conceptual and working knowledge of Oracle, SQL, SQL Server, C, C++, C#, VB.Net. (Oracle 10g, SQL Server 2008 R2/2012/2016)
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Getting responsible for building reports in Power BI from the Scratch and publishing on dashboards in Power BI server and Power BI reports.
• Getting responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Proficient to write calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Technical lead of the development team, mentoring development, performing Design reviews, Code reviews, support teams and work as individual contributor.
• Experienced in handling large projects spread across multiple geographic locations and providing leadership to successfully work in a team environment and communicates effectively across a variety of stakeholder groups.
• Ability to identify opportunities and transform them into quantifiable and achievable initiatives
• Proven ability to create and document business requirements, business processes, and project plans to support strategic and/or tactical projects
• Dynamic and self-starting individual who can work independently or as part of a team with minimal guidance and direction.
• Continuously update new skills to keep abreast of industry trends and state of the art technology.
• Effectively prioritize and assign work in order to meet deadline and demonstrate excellent written, verbal, and presentation skills.

TECHNICAL PROFICIENCY:

Data Modeling tools: Oracle SQL Developer Data Modeler, Erwin

DWH Architecture Design: Building Architecture of Data Warehouse Solution

DWH - OLAP: MS BI SSAS 2017,2008 R2 on SQL Server 2012,2008 R2.

BI Reporting & Reporting Tools: MS BI SSRS on SQL Server 2015/2012, IBM Cognos 8.0/8.4, OBIEE, Crystal Reports.

ETL: MS BI SSIS 2017, 2008 R2 on SQL Server, Informatica 9.6

DWH/ Databases: SQL 2016/2012/2005 T-SQL (XML processing, Dynamic SQLs, Stored Procedures, Triggers, Performance Analysis and Tuning (Execution Plan, SQL Profiler, Index Tuning, Query Optimization, complex queries), DBA activities etc.

DWH/ Databases: Oracle 11g/9i/8i PL/SQL (Stored procedures, triggers, packages, functions, Data Transfer with SQL Loader etc.), TOAD Tools

Database Tools/Utilities: SQL*Plus, TOAD, SQL Developer, SQL Navigator, Oracle Enterprise Manager, SQL*Loader, import / Export utilities

Version Control: Bitbucket, VSS 8.0, ClearCase 3.2

Languages: C, C++, VB, SQL, PL/ SQL, UNIX shell scripting, HTML, XML VB Script, Java script.

Middle ware: MS SharePoint 2010/3.0, MS Commerce Server, ASP 3.0, DSP Web part.

Data Analytics (through training): Big Data, Sqoop, Hive, Qlik View Reporting. trained

PROFESSIONAL EXPERIENCE:

Confidential, NY

Data Warehouse & ETL Architect and Lead Developer

Responsibilities:

• Covered requirement analysis executed the multidimensional logical and physical Data Modeling of the LSM Reporting Data Mart & GRR EDW for the development on MSBI Stack with SSAS, SSIS & SSRS.
• Designed the ETL architecture of multiple SSIS packages for different new SSAS Cube related activities for Incremental processing, full processing, index processing etc.
• Built high level SSIS solution with advanced feature of Environment variables for automated process of SSAS cube building for legacy system with SSIS.
• Built the automated feature of SSAS Cube refresh in Excel for Analytical Pivot Table reporting for GRR.
• Designed, developed and streamlined File Transformation process to LSM with dynamic columns from Kyriba Upstream Application for maintaining Cash in Bank process in LSM (a.k.a. LRM). SFTP set up of file transfer and building complex SQL procedure for the ETL packages in SSIS to load the data mart on SQL Server from the file with dynamic column names using complex PowerShell Script, complex C# .Net script task,
• Implemented Automatic refresh Power Pivot in Excel for new SSAS cubes refresh.
• Written and used IBM Tivoli Workload Scheduler (aka Maestro) for automated job scheduling for Dev/Int/UAT.
• Designed and developed SSRS (SQL server reporting services) reports from OLAP and OLTP such as Graph, Linked, Dashboard, Scorecards, Drill-Down, Drill-through, Parameterized, Cascading, Conditional, Tabular, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Mentoring junior team members.
• Coordination between Project Management and offshore team.

Confidential

Data Warehouse BI Reporting & ETL Architect and Lead Developer

Responsibilities:

• Analyzed Data & Mapped between Source system data and OFSAA Staging Area as target.
• Developed the ETL architecture of the surrounding integration environment to provide the data to the OFSAA Engine through OFSAA Staging Area.
• Designed and developed the architecture of the Automation process of ETL Batch Executions through configuration of dependency, parallelism between the workflows.
• Carried out Performance Tuning & Monitoring of ETL Workflows.
• Resolved data extraction and loading issue by troubleshooting.
• Installed and configured OFSAA OFSDF Data Model for EPM Module (LRM, ALM, FTP, PFT)
• Configured Batch Runs SCD, T2T, T2F, Batch, PLT, DQ for Dimension loading, Hierarchy loads, Fact Loads.
• Designed the process for Excel Upload for GL reconciliation, Balance adjustment.
• Created Multidimensional Data Model for PFT Custom BI Data Mart in OFSAA engine.
• Designed the Custom BI Reporting Architecture on OBIEE for the Custom BI Reports on OBIEE apart from Out-Of-Box OFSAA Reports.
• Developed Custom BI Reports using OBIEE including dashboards.
• Led the development team for Custom OBIEE BI Reporting and ETL on Informatic.
• Worked flexibly under the crucial tight environment with developer teams, vendors and other parties responsible for resolution of issues.
• Anticipated, addressed and alerted the issues before it gets escalated by the client.

Confidential

Data Warehouse Architect and Tech Lead

Responsibilities:

• Did the Multidimensional Data Modeling for dbDataCore Data Warehouse with 5 Cubes
• Analyzed the Data and designed the Architecture of the Data Warehouse Solution
• Designed the ETL Architecture, Dataflows, Control flows for SSIS ETL..
• Designed the OLAP warehouse with 14 Dimensions & 5 Cubes.
• Lead the Development Team for ETL, OLAP
• Built BI Reports on Cognos.
• Conducted daily basis communication, status calls with clients, team for requirement gathering, support and maintenance with the CA/L4-L3 Tech team, new issues encountered and the resolutions.
• Worked flexibly under the crucial tight environment with developer teams, vendors and other parties responsible for resolution of issues.
• Carried out the monitoring of ETL loading Tasks Execution and Performance.
• Executed of Daily Database Maintenance Tasks
• Anticipated, addressed and alerted the issues before it gets escalated by the client.

Confidential

Data Warehouse Architect and Project Lead

Responsibilities:

• Finished the Multidimensional Data Modeling for Fund Services Data Warehouse.
• Analyzed the Data and designed the Architecture of the Data Warehouse Solution
• Designed the ETL Architecture, Dataflows, Control flows for SSIS ETL.
• Designed the OLAP warehouse.
• Created the technical design document for ETL and Star Schema Data Warehouse
• Lead the Development Team for ETL, OLAP
• Executed the project on Agile, conducted daily basis communication, status calls with clients, team for requirement gathering, support and maintenance with the CA/L4-L3 Tech team, new issues encountered and the resolutions.
• Worked flexibly under the crucial tight environment with developer teams, vendors and other parties responsible for resolution of issues.
• Carried out the monitoring of ETL loading Tasks Execution and Performance.
• Executed of Daily Database Maintenance Tasks
• Anticipated, addressed and alerted the issues before it gets escalated by the client.

Confidential, Boston

Lead Developer

Responsibilities:

• Built the Data Mart / specific Data Warehouse on Oracle 11g database, support and maintenance.
• Worked on troubleshooting database related problems and resolved.
• Worked flexibly under the crucial tight environment with developer teams, vendors and other parties responsible for resolution of issues.
• Monitored of Data Loading Tasks Execution and Performance developed on Oracle PL/SQL
• Execution of Daily Database Maintenance Tasks
• Had Weekly status calls with the CA/L4-L3 Tech team, updating on the new issues encountered, and how those new issues were addressed.
• Lead and carried out the responsibility of mentoring the Team and worked fully with hands on development activities along the team members.
• Anticipated, addressed and alerted the issues before it gets escalated by the client.

Confidential

Lead Developer and Tech Lead

Responsibilities:

• Worked on Multidimensional Data Modeling, Building the DWH, ETL and OLAP design
• Conducted requirement gathering calls with clients on daily basis, issue escalations etc.
• Developed and built OLAP Dimension & Cube SSAS 2005 of 43 dimensions and 6 cubes.
• Worked on Oracle PLA/SQL database development and support, maintenance.
• Troubleshooted database related problems and resolved.
• Worked flexibly under the crucial tight environment with developer teams, vendors and other parties responsible for resolution of issues.
• Was monitoring of Database Task Execution and Performance.
• Executed of Daily Database Maintenance Tasks
• Had weekly update calls with the CA/L2 Tech team, client on updating on the new issues encountered, and how those new issues were need to be addressed.
• Lead the Team.
• Need to anticipate and address/alert any issues before it gets escalated by the client.
• Anticipated, addressed and alerted the issues before it gets escalated by the client.

Confidential, New York

ETL Team Lead

Responsibilities:

• Developed and built SQL 2005 T-SQL and OLAP database and supported later.
• Resolved issue through troubleshooting.
• Worked flexibly under the crucial tight environment with developer teams, vendors and other parties responsible for resolution of issues Monitoring of Database Task Execution and Performance.
• Executed Daily Database Maintenance Tasks
• To have a Weekly update meeting with the CA/L2 Tech team, updating on the new issues encountered, and how those new issues need to be addressed.
• Leading the Development Team.
• Anticipated, addressed, and alerted the issues before it gets escalated by the client.
• Developed SQL2000/2005 T-SQLs and worked on support and maintenance.
• Troubleshooted database issues and resolved.
• Was responsible for monitoring Database Task Execution and Performance.
• Executed Daily Database Maintenance Tasks
• Had weekly update meeting with the CA/L2 Tech team, updating on the new issues encountered, and how those new issues need to be addressed.
• Lead and mentored the development Team.
• Anticipated, addressed, and alerted the issues before it gets escalated by the client.

Technology: SQL Server 2005, SSAS, SSIS

Confidential, Boston, MA

ETL Team Lead

Responsibilities:

• Developed SQL2000/2005 T-SQLs and worked on Data Warehouse and provided support and maintenance.
• Troubleshooted database issues and resolved.
• Attended daily meeting with the CA/L2 Tech team, updating on the new issues encountered, and how those new issues need to be addressed.
• Lead the Development Team.
• Anticipated, addressed and alerted the issues before it gets escalated by the client.

Technology: SQL Server 2000, MS Analysis Services, DTS

Confidential

Senior Software Developer

Responsibilities:

• SQL2000/DWH database development and maintenance.
• Troubleshooted database programming issues and resolved.
• Worked flexibly under the crucial tight environment with developer teams, vendors and other parties responsible for resolution of issues Monitoring of Database Task Execution and Performance.
• Developed ETL task, data flows, control flows on DTS and was responsible for Execution and Performance review.
• Executed of Daily Database Maintenance Tasks
• Attended weekly status calls with the CA/L2 Tech team, updating on the new issues encountered, and how those new issues need to be addressed.
• Lead the Development Team.

Technology: SQL Server 2000, MS Analysis Services, DTS, Commerce Server, BizTalk Server

Confidential

Database Lead Developer

Responsibilities:

• Worked on SQL2000 database T-SQL development with stored proc, triggers, views, functions.
• Worked on Performance tuning.
• Attended weekly update meeting with the CA/L2 Tech team, updating on the new issues encountered, and how those new issues need to be addressed.
• Worked as Team Leader of the Development Team.

Technology: SQL Server 2000, VB 6.0, QTP, ASP.net, C#.net