SUMMARY:

• 14 yrs. of experience in delivering, enhancing and leading end - to-end enterprise Data Warehouse and BI solutions, with extensive hands-on experience in both ETL and BI.
• Sound Architecture and Dimension Modelling knowledge with expertise in designing and implementing Data-Warehouse and Data Marts.
• An expect in building ETL process, with hands-on in Informatica Powercenter, handling high volume, heterogeneous (Flat files, Web Services, CSV, XML, DB etc.) data sources and targets
• Highly skilled in Oracle PL/SQL and optimizing SQL queries and Database Objects (Indexing, Partitioning tec.) for high performance.
• Very strong SQL knowledge, having the experience of implementing complex analytic and OLAP functionalities using SQL.
• MicroStrategy certified (MicroStrategy Certified Project Designer V9.4.1) expertise in designing and implementing enterprise wide "self-servicing" Business Intelligence apps in MicroStrategy, with highly scalable attributes, metrics, filters etc.
• Extensively worked on implementing schema layer in MicroStrategy, leveraging all MicroStrategy features like VLDB setting, In-Memory capabilities (cubes), Custom Group, Consolidation, Prompts, Advanced Filters, Metrics, Derived Metrics, Attributes etc.
• Have designed and implemented numerous BI Reports and Dashboards with leveraging MicroStartegy’ Confidential advanced analytic capabilities (like VI features, Data Blending, Report Bursting etc.).
• Good experience in UNIX Shell Scripting for file handling, cleansing, scheduling etc.
• Excellent analytical, problem solving skills with experience of estimating, planning, executing and leading many projects adhering to Water-Fall or Agile methodology.
• Good understanding of Big Data tools and technologies (like Hadoop, Hive, Sqoop, Kafka, Spark, MongoDB etc.) along with a good knowledge in Python programing.
• Successfully launched a high performance "Self-service" business intelligence platform in MicroStrategy for enterprise users with in-memory and analytic capabilities.
• Re-engineered highly complicated legacy ETL process achieving tremendous performance improvement (almost 200%) generating high business benefits.
• Designed and implemented a tight security model (row & column level) leveraging Oracle’ Confidential VPD feature, restricting confidential data to un-authorized users through all data accessing tools or interfaces.
• Designed and implemented a highly scalable “Data-Driven Framework” comprising of both ETL & MicroStrategy components for volatile Regulatory requirements which can be accomplished without or very minimal IT assistance.

TECHNICAL SKILLS:

Tools: /Technology: BI

MicroStrategy 10.2: Business Objects 6.5, BOXIR3 Hyperion Essbase

ETL: Informatica Powercenter 9.6.1/10

Databases: Oracle 12C

SQL Server 2005: Programming/Scripting

SQL, PL/SQL and T-SQL: UNIX Shell Scripting

Data Modelling: Erwin Data Modeler r9.64

Other Utilities/Tools: TOAD, SQL Developer REMEDY,VersionOne, hp-ALM

Scheduling Tool: Autosys

Basic Understanding: /Exposure

Python 3.6.1: Hadoop, Hive, Sqoop, Spark

MongoDB: Informatica IDQ

PROFESSIONAL EXPERIENCE:

Confidential, New York City

Technologies/Tools Used: MicroStrategy 10.2, Oracle 10g/12c, SQL, PL/SQL, Informatica Powercenter 9.6.1Business Objects 6.5, BOXIR2, UNIX Scripts.

Responsibilities:

• Understand business requirements and convert to technical specifications.
• Own the project from requirements to delivery.
• Perform feasibility study and proof of concept when and where required.
• Data model and database design for new requirements.
• Develop schema layer for reporting needs in MicroStartegy 10.2
• Build complex reports and dashboards in MicroStrategy .
• Enhance performance by tuning SQLs and database structural changes
• Design and develop ETL and BI solutions aligned to business requirements.
• Develop ETL mappings in Informatica Power Center 9.6.1
• Develop/Enhance UNIX scripts for file handling and audit requirements.
• Coordinate with multiple stakeholders/groups for seamless project execution.
• Providing continuous system improvements like automation, performance improvement etc.

Confidential

ETL Tools: Informatica Power Center 8.6, Business Objects 6.5

Database: Oracle 10g

Operating Systems: Windows, Solaris

Programming Languages: SQL, PL/SQL

Responsibilities:

• Understand business requirements and convert to technical specifications.
• Perform feasibility study and proof of concept when and where required.
• Data model and database design for new requirements.
• Design and develop ETL and BI solutions aligned to business requirements.
• Develop ETL mappings in Informatica Power Center 9.6.1
• Enhance UNIX scripts for file handling and audit requirements.
• Coordinate with multiple stakeholders/groups for seamless project execution.
• Providing continuous system improvements like automation, performance improvement etc.

Confidential

BI Tools: Informatica 8.6, Business Objects 11, Hyperion Essbase.

Database: Oracle 10g

Operating Systems: Windows, Solaris

Programming Languages: SQL, PL/SQL

Responsibilities:

• Lead the Business Intelligence programs and implementing end-to-end enterprise data warehouse applications.
• Responsible for gathering requirements from the business users
• Development of ETL mappings and Reports aligned to business requirements.
• Project estimation & planning, data quality design, data-modeling and development along with documenting Design, Quality and Technical specifications.
• Maintaining status reports and clarification trackers along with monitoring project status and adherence to standards and regulations.
• Implemented data integration tasks by coordinating between various technology/support groups and stake holders.
• Responsible for deployment in production and QA environment for new projects/enhancements providing support for Quality Assurance and post-production support.

Confidential

BI Tools: Informatica 8.6, Business Objects 11, Hyperion Essbase.

Database: Oracle 10g

Operating Systems: Windows, Solaris

Programming Languages: SQL, PL/SQL

Responsibilities:

• Responsible as the single point of contact for all the technical aspects of the system.
• Activities include analysis and identification of data availability in legacy source systems, data profiling and database Tuning.
• Responsible for requirements gathering, project planning & estimation, design, development, test and successful implementation of new ETL and OLAP objects.
• Had automated all possible manual tasks and improved accuracy and response time of Business Intelligence reporting.
• Responsibilities also includes Understanding complex Business Requirements and converting them to Oracle PL/SQL packages, procedures and functions.
• Responsible for Quality assurance support activities along with Product migration and post-production support and infant care.

Confidential

BI Tools: Informatica Power Center 7.1.1, Oracle 9i, Hyperion Essbase.

Database: Oracle 10g

Operating Systems: Windows 2000/ XP, UNIX

Programming Languages: SQL, PL/SQL

Responsibilities:

• Responsible for gathering requirements from the business users
• Design, development, unit/integration testing of ETL and OLAP using Informatica and Hyperian Essbase respectively.
• Activities also include documentation of Business Requirements along with Design, Quality and Technical specifications.
• Had done analysis and study of complex Business Requirements and converted to Oracle PL/SQL packages, procedures and functions.
• Responsible for Quality Assurance support activities along with Product migration and post-production support and infant care.

Confidential

Tools: Oracle Forms9i, Oracle Reports

Database: Oracle 9i

Operating Systems: Windows 2000/ XP

Programming Languages: SQL, PL/SQL

Responsibilities:

• Responsible for requirements gathering from Business Users
• Analysis, Design, development, testing along with documenting Technical specifications, Design artifacts,
• UAT support documents and maintaining status reports and clarification trackers. A
• Activities also include impact analysis for new requirements and prepare the High Level and Low level design for new initiatives.
• Had to develop new Oracle reports based upon the Business requirements along with Test case/data preparation, execution and verification of the test results.
• Was responsible for setting up testing environment data by posting data from various systems and ensuring that the data server good for all test case scenarios.

Confidential

Tools: SQL Developer, Erwin & Crystal Reports

Database: SQL Server & Oracle 8i

Operating Systems: Windows 2000/ XP

Programming Languages: SQL, PL/SQL, T-SQL

Responsibilities:

• Responsible as the single point of contact for all the technical aspects of the system.
• Activities include analysis and identification of data availability in legacy source systems, data profiling and database Tuning.
• Responsible for requirements gathering, project planning & estimation, design, development, test and successful implementation of new ETL and OLAP objects.
• Had automated all possible manual tasks and improved accuracy and response time of Business Intelligence reporting. Responsibilities also include Understanding complex Business Requirements and converting them to Oracle PL/SQL packages, procedures and functions.
• Responsible for Quality assurance support activities along with Product migration and post-production support and infant care.