SUMMARY

• Information technology professional with over 20 years of experience in Media, Medical Device, Pharmaceuticals, Investment Banking, Insurance, Telecom, Publishing and Utility companies.
• Experienced in all the phases of the Data warehouse life cycle involving requirement gathering, analysis, solution design, development and testing of Data warehouse using ETL, Data Modeling, Online Analytical Processing & reporting tools.
• Extensive experience in gathering requirement, developing logical and physical data modeling, maintaining databases, analyzing data - warehouse data, data governance, testing applications, installing software, tracking new software releases and scheduling the implementation/roll out of software upgrades.
• Managed large-scale projects with budget of multi-million USD, led teams of cross functional individuals. Strong team builder with creative thinking skills and a desire to make a difference.
• Expertise in project management - project planning, risk management, resource management, configuration management, scope management, schedule and budget management.
• Responsible for interacting with business partners to identify information needs and business requirements for project. Ability to effectively reach all stakeholders - from executive directors to team developer levels with ease
• Drive to Learn new tools and new ways of visualizing / displaying data and insights
• Experience with Reporting tools like OBIEE 11.1.1.7.150120 and SAP HANA
• Special expertise in working with Oracle database as well as other RDBMS
• Hands on experience in Big data projects on AWS and Hadoop

TECHNICAL SKILLS

ETL Tool /Software/Programming Languages: Hadoop, HIVE, AWS, Aginity Workbench for Redshift, Teradata, Microsoft SQL server, Alteryx, JIRA, Oracle, SQL, PL/SQL, Tableau, Cognos, Informatica Analyst, Share Point, Kanban, OBIEE 11.1.1.7.150120 , Oracle ERP, SAP, SAP HANA, BW, Qlik Sense, Siebel Analytics 7.5.3, 7.8.2, DataStage, Informatica, Siebel, Trillium, FirstLogic, Toad, DTS, Oracle9i Discoverer, Act 5,6, GoldMine 5,6, Super Nova, Crystal reports, JQL, HTML, ASP, SQL, Visual Source Safe, Visual Basic, C++, C, Power Builder, Assembler, Pascal and FORTRAN 77, Quality Center, Power Point, Microsoft Excel

Databases: Oracle 11.2, 8i, 9i, UDB2 7.0, MS-Access 2000, 98, 97, 2.0, Sybase, MS-SQL server 2000 and Gupta

Case Tools: Erwin 4.1, Select Systems Engineer (LBMS), Silver Run, Power Designer, Microsoft office Suite and Microsoft Visio

Operating Systems: Windows 10, 7, XP, 2000, 95, NT 4.0, 3.11, Millennium Edition, MS-DOS 6.22, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Lead Data Steward / Business Analyst

Responsibilities:

• Partnered with data governance, data stewards, and subject matter experts to create and maintain business definitions/business glossary for data used within the EBI Solutions.
• Evaluated existing solution data dictionaries for duplication, gaps and/or quality issues to ensure that the most accurate business descriptions are available for consumption by the analytics team.
• Responsible for creating use cases and test cases for the new billing system.
• Completed GAP analysis of the new billing system and the legacy data warehouse tables.
• Completed GAP analysis of QA testing and standard testing for different subject areas (Customer, Account, Product etc.)
• Mapped the Personal Information tag (PI) file. File was loaded to the MetaVolt. Which was used for generating the CPP report for consumer.
• Worked on data profiling using the sql for the CPP project.
• Analyzed the BigID file for the PI tagging gaps.

Confidential, Somerville, NJ

Lead Data Steward / Business Analyst

Responsibilities:

• Responsible for creating Data Discovery documents that involved extensive data analysis by providing source data insights
• Written Business rules-based data profiling and source data insights from scratch.
• Worked closely with the development team to make sure business rules are correctly translated into the data transformation.
• Data Validation between multiple sources (Legacy Data warehouse, other data lake, Transactional database etc.)
• Data integrity gap analysis and data profiling to detect data anomalies
• Identified the canonical model attributes and involved in creating Logical Data Modeling for 1MD 2.0 Data Lake.
• Conducted working sessions between Business and Technical teams to gain full clarity of the Business Requirements
• Used different tools (Aginity Workbench for Redshift, Teradata, Microsoft SQL server, Alteryx, Oracle, SQL, PL/SQL, Qlik Sense, Cognos) for the data analysis.
• Worked with Agile team
• Written test script and preformed business UAT (User Acceptance Testing) on the data lake.

Confidential, North Wales, PA

Project Manager/ Business Analyst

Responsibilities:

• As a project manager worked on complex, major and highly visible tasks.
• Gathered reporting requirements for Commercial (Chargeback, Returns, Medicaid, Government Pricing, Product Management, Bid & Tender, Pricing and Sales & Marketing) and Supply Chain (Inventory Management, Supply Chain Planning, Manufacturing and Warehouse Management) business areas for OBIEE.
• Worked on Control Tower, Inventory Optimization, Line Item Fill Rate, Backorder, Forecast Accuracy, Fulfillment Analytics, Material Review Board, DC Planning, Supply Chain Planning, Manufacturing, IMS, Product Management Analytics, Sales Reporting, Pricing and Chargeback reporting projects.
• Worked Closely with Business users, vendors and delivery teams to understand business requirements that drive the analysis and design of business analytics and reporting solution.
• Assisted in developing best practices for data presentation and data governance across the organization.
• Conceptualized, designed and developed data visualization solutions that synthesize data concepts into clear communication for key business stakeholder.
• Developed reports and given presentations to senior management as needed.
• Provided technical leadership, coaching and mentoring to team members.
• Provided technical guidance or system process expertise.

Confidential, Hopewell, NJ

System Analyst

Responsibilities:

• Created SRS (System Requirements specifications) documents based on the business requirements and reviewed those documents with business users. Also involved in signing off process with business.
• Worked on delivering CRM solutions to other groups that involved data mapping, designing new real time interface, to improve the Call Center process.
• Created high-level design documents for BISS Billing System invoice enhancement.
• Tested the enhancement of the BISS Billing System for the Retirement group.
• Created high-level and low-level design documents for various data warehouse projects
• Mapped data from different sources to the data warehouse.
• Wrote the test script for the different projects and tracked the testing result in Quality Center.
• Created and Tested different reports based on the business requirements.

Confidential, NY

Business/Data Analyst

Responsibilities:

• Created user training documents for the Siebel Analytics 10G and dashboard report training documents.
• Created reports and provided the recommendation to reduce the number of reports by using the global filters.
• Created the data dictionary for eleven subject area.
• Analyzed all the existing reports in different platforms and provided the recommendation to reduce the number of reports.
• Designed the help desk database and forms to track the help desk activity.
• Gathered report requirements and created requirement documents.
• Wrote SQL queries to test the sql server database for data discrepancy between legacy and data warehouse.

Confidential, Middletown, NJ

Business Analyst Data warehouse

Responsibilities:

• Gathered business requirement and created requirement document for Global Sales Enablement (GSE) Project.
• Download data into access database and created ad-hoc queries and reports.
• Created Ad-hoc report process and tracked the database for ad-hoc report issues in access database
• Completed Business Verification Testing (BVT) for upgrade of Seibel Analytics 7.5.3 to 7.8.2. Tested the new and existing functionality.
• Created Process to clean up the Siebel analytics catalog and the Meta data.
• Created Siebel analytics dashboard with the global filters and deployed the reports on the dashboard. Used hierarchy visibility to ensure the data security of the reports.
• Designed, created and tested Siebel analytic reports for Cycle Time, Volume, Active Time, Work Load and Win Loss.
• Wrote SQL queries to test the oracle database for data discrepancy between legacy and Data warehouse.

Confidential, NY

Business/System/Data Analyst

Responsibilities:

• Analyzed magazine campaign database using Oracle Discoverer. Crosschecked the mapping rules and calculated the value for different tables.
• Created data load rules for ETL tools
• Created reports in Oracle 9i database using Oracle Discoverer
• Analyzed SAS report for the data load
• Wrote documentation for data analysis process
• Crosschecked Main Frame (Legacy) data and Magazine Campaign Management data warehouse (Oracle 9i) data.