SUMMARY:

• 15+ years of experience in operational, business intelligence, data warehousing, reporting, analytics and enterprise data architecture.
• Technical and Business in - depth in all phases of project life cycle from strategic road maps and business case analysis to estimation, technical architecture, conceptual prototyping, business process engineering, requirements elicitation, and business analysis.
• Seasoned professional in Architecture, Administration, Design, Development and implementation of multiple Reporting Systems.
• Experience includes Data Warehousing using Kimball methodology.
• Architect the Enterprise Data Warehouse and Business Intelligence Reporting Solutions.
• Scope, Design, and Implement enterprise-wide Systems.
• Experience in BigData architecture in building scalable distributed data processing solutions with Hadoop, Hive, Talend Big Data monitoring, debugging, benchmarking and performance tuning of tools of ecosystem.
• Architect the BI Solution with respect to multiple BI tools (Qlickview, OBIEE, OBIA, Informatica, Data Services, Business Objects (WebI, SAP HANA and BW), Cognos, DataStage OWB, SAS, SSAS, Tableau etc.) in the market.
• Architecture/Infrastructure, Design and Configuration of Tools and Technologies.
• Certified BI Professional.
• Experience with Cloud Computing and Data Management using AWS, Azure, Rackspace and other technologies.
• Conceptual Modeling, Data Modeling, Data Quality, Data Integration, Master Data Management, Big Data and Meta Data Management.
• Database development using Oracle 11g and 12c versions.
• OLAP, Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP) and Hybrid OLAP (HOLAP).
• Design Data Integration Solutions for Predictive Analytics.
• Extraction, Transformation and Loading using ETL tools.
• Design Metadata/Presentation Layer for query, reporting, and analysis.
• Gather, Analyze and Document As-Is vs Future Assessment, Business Requirements, Functional Requirements, System Test Cases and Use Cases, Performance Testing Requirements and Data Specifications.
• Strong analytical skills and in depth experience in Business Process analysis coupled with interpersonal, communication, documentation and self organizing skills.

TECHNICAL SKILLS:

Operating System: Windows, UNIX, Linux, DOS

Data warehousing Tools: Qlickview, Business Objects, InfoBurst, Dashboards, Crystal Xcelsius, WebI, ZABO, SAP HANA, Crystal Reports, SAP BW,SSIS, SSAS, SSRS, Cognos, BODS, Data Manager, Micro Strategy, Actuate, Informatica, MDM, Data Stage, Hyperion (Forecasting), OBIEE, OBIA, OWB, SAS, SSAS, SSRS, SSIS and DAC.

Web Server: JWS, Web Logic, IIS, WebSphere, JSDK.

Server Side: Java Server Pages, PERL, Servlets, and Active Server Pages.

Internet Applications: J2EE, SDK, JDBC.

Languages: C, C++, Java, SQL, PL/SQL, TSL, Visual Basic, Essentus, COBOL.

Databases: Oracle, SQLserver, DB2, Teradata, My SQL, Sybase, MS-Access, dBaselll+.

ERP: PeopleSoft HR/Finance, Oracle EBS, SAP, Hyperion.

Development Tools: FrontPage, Visual J++, Symantec Caf, VisualAge.

Version Control: Visual Source Safe.

Other Tools: Erwin, LECCO SQL Expert, Toad, WinSQL, Power Designer, Power Builder, Informatica Data Quality (IDQ), Jira, Clear Quest, SQL Developer, IaaS, SaaS, Spark, Hadoop, Discoverer, Amazon Web Services, Rackspace, Azure.

Architectural Frameworks: TOGAF, Zachman

PROFESSIONAL EXPERIENCE:

Confidential, TX

Data Architect (Consultant)

Responsibilities:

• Analysis on current as-is environment.
• Assessment, Solution/Architecture and Implementation of data projects.
• Evaluate current reporting pattern in use with Tableau, Demandware, Amperity and evaluate the improvements for future needs.
• Establish Data Governance to bring all the stake holders on to one understanding.
• Design conceptual, logical and physical data model using Oracle Designer.
• Evaluate the need for Data Lake and Data Warehouse, propose the solutions to the leadership.
• Evaluate the API needs to share the data between Social Media and internal systems. API Post of data to Facebook Offline Conversions to evaluate customers view the ads and visiting the stores to purchase.
• Coordinate with Infrastructure and Data teams on tools and technologies. For Example: Zapier tool used to collect data from source database and send to Facebook.
• Improve the load of data from external systems to internal Data Analytics systems, ETL tool Pentaho is used in this implementation.
• Implementation of a new Agile project methodology. Follow through Project expectations and deliver the responsibilities at daily scrums and management meetings.
• Master Data Management Customer Centric 360 implementation using Amperity.
• Administration and development of Analytics as needed for the leadership teams.
• Solution the Integration of data related to Sales Event Payment Reporting.
• Coordinate with Network Team on Rackspace Cloud Install, Setup and Management of Tools and Services.

Environment: SQL Server, MySQL, Pentaho, Azure, Rackspace, Designer, Jira, Tableau, Power BI, SSIS, KWI, Demandware, Amperity, Custora, Oracle, Oracle Retail Insights.

Confidential, TX

Data Architect (Consultant)

Responsibilities:

• Analysis on Project Scope and individual department wise requirements.
• Analysis on current reports delivery system and evaluate the need for future analytics.
• Establish the Data Governance and Profile data.
• Evaluate the analytics tool Microsoft Power BI for reporting and Dashboards, ETL tool SAP BODS for ETL and Power Designer for Data Model.
• Identify the business leads and establish the data governance process.
• Implement Meta and Master data management capabilities, introduce Data Quality rules at source and integration step.
• Architect and design the data warehouse.
• Establish Agile project methodology on timely execution and delivery of tasks.
• Data Modeling for Operational and Analytical systems. Design the conceptual, logical and physical data model using Power Designer.
• Implement the Data Lake and Data Warehouse for the purpose of near real time and aggregated analytics.
• Design and implement the reports and dashboards as needed for Business and general public.
• Coordinate with Network Team on Azure Cloud Install, Setup and Management of Tools and Services.
• Solution and Implement the public facing analytics using .Net Integrated SDK.
• Introduce the Best Practices and Standards related to technology and tool.
• Establish the timely availability of data with planned Schedule, Process and Publish of analytics across people in organization.
• Solution and Implement verifiable Audit on Data stored at analytical environment.

Environment: MySql, SQL Server, SAP Data Services, Power Designer, Jira, Business Objects, Pentaho, Tableau, Power BI, SSIS, SSRS.

Confidential, TX

Practice Architect

Responsibilities:

• Define the Project Scope and come up with SOW.
• Assessment to include current state and define future state.
• Develop and present the Project Road Map.
• Aid Project Management with estimation and planning.
• Engaged key stakeholders within functional areas to capture business pressures, pain points and long-term visions
• Assessment including current and future state of project with details on Processes, Technologies, Planning and Deliverables.
• Conduct source data analysis, user interview and creation of use cases and requirement gathering.
• Data profiling of source systems to find accuracy and trust worthiness of the data.
• Architect and Implement the Enterprise Data Warehouse(EDW).
• Data Management using Big Data Technologies like Hadoop.
• ETL solutions and establish processes/methodologies using best practices and standards.
• Experience as Cloud Computing Advisor that provides BI solutions on the cloud for different verticals with an initial focus on Healthcare.
• Solution and Manage the Infrastructure, Applications and Security of Data, Analytics and Services and decisions.
• Establish Data Governance, Data Quality and Master Data Management.
• Creation of Proof of Concept for demonstrating MDM capabilities to the client.
• Data Modeling, Data Warehouse Architecture, ETL Architecture, and Informatica Administration
• Design ODS layer, Dimensional modeling using Kimball Methodologies, of the Data Warehouse sourced from MDM Base tables and other Transactional systems.
• Design Fact tables, dimension tables, role playing dimensions and slowly changing dimensions to meet business needs.
• Business Rules and Definition of ETL instructions to load the MDM Landing Tables
• Performance tuning of SQL Queries, Informatica mappings and the workflows.
• Conduct thorough code reviews and ensured that the outcome is in line with the objective and all the processes and standards are followed.
• Write project documentation using Microsoft VISIO for different diagrams.
• Developed both conceptual and logical architecture to support new the data analytics environment, including Architectural frameworks Togaf.

Environment: Oracle, Tera Data, SQL Server, DB2, MySQL, Sybase, Hadoop, Informatica, SAP Data Services, ERWIN, Power Designer, ODI, Oracle Data Modeler, Jira, AWS, Tableau, Qlickview, Business Objects, AWS, OBIEE, OBIA, Cognos, SSIS, Oracle ERP.

Confidential, Minneapolis, MN

Sr. Data Architect

Responsibilities:

• Dimensional modeling of EDW following Kimball methodology (Star Schemas) with Erwin data modeling tool for Data marts and data warehouses in Star Schema, with conformed dimensions.
• Designed, implemented and maintained information architecture and technology for a very large volume Enterprise Data Warehouses sourced from Heterogeneous databases and file systems
• Design of fact tables based on various measures that are required by the business users.
• Design of Slowly Changing Dimensions (SCD).
• Involved in complete Data Warehouse Lifecycle starting from requirements and data profiling to data modeling, data loading, capacity planning, production data validation and user training.
• Define and implement Data Retention Mechanisms, framework for generating stats on tables at periodic intervals. Perform Capacity planning by estimating the data volume, growth of data volume & Data Retention policies.
• Model ODS (Operational Data Store) Layer to stage the data before loading into the Data Warehouse/ Data Mart.
• Maintain metadata, naming standards and warehouse standards for future application development.
• Effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
• Analysis and profiling of source data to find the source data quality and relationships, and to see if all the needed data, to meet the business requirements, is available in the source.
• Setting up of data governance plan, Data privacy and security Frameworks.
• Create ETL instructions (Source to Confidential mapping document) which will be used by the ETL development team to load the data into the warehouse.
• Collaborate with data science teams in understanding data points and design a solution to acquire and load them into HDFS from disparate data sources.
• Migration of high volume data from different data sources to Hadoop using relevant connectors.
• Architecture experience in designing large data processing frameworks with Hadoop, Spark, Hive, MapReduce and NoSQL,
• Expertise in building Real-time and Near-Real-time complex stream processing platforms using tools like Spark for a scalable and fault tolerant systems.
• Data Management and Master Data Management.

Environment: Oracle 11g, DB2, SQL, PL/SQL, SAP, Erwin, Power Designer, Hadoop, Tera Data, Informatica, Data Stage, Visio, Toad, Java, .Net, ER Studio, Toad, Data Stage, Informatica, IDQ, Cognos, and Windows.

Confidential, Minneapolis, MN

Enterprise IT Architect

Responsibilities:

• Evaluate BI Mobile and Upgrade with vendors.
• Evaluate the Customer related Financial, Consumer Loans and Mortgage Data.
• Recommend the solutions for the multi level security useful across multiple projects.
• As part of KSC (Knowledge Service Center) effort recommend the Best Practices and Standards for BI Initiatives.
• Cloud Computing solution that provides BI software accessible and analytics through cloud.
• Architecture, Scoping and Design following the Configuration and Change Management.
• Meet with the technical and non-technical teams on the requirements.
• Provide the estimations to the project team as required.
• Data modeling design.
• Involve in Metadata Manager Process and Implementation.
• Advance techniques in designing the universes.
• Analysis on the reports inventory across organization.
• Lead the team in providing the reporting solutions to the Business.
• Train the users on the ad-hoc reporting.
• Identify and document the current issues and gaps.
• Involve, discuss and estimate the future workload.
• Provide status to the Business Team and the Project Team as required.

Environment: DB2, Oracle 11g, SQL, PL/SQL, Qlickview, SAP, Business Obects, Informatica, IDQ, Hadoop, Visio, Toad, Word, Excel, Microsoft Project, Java, .NET, ER Studio, Xcelsius, SAS, OBIEE, Sharepoint, AWS, Toad, SQL Developer and Windows.

Confidential, Minneapolis, MN

Principal BI

Responsibilities:

• Architecture, Scoping, Design, Administration, Development and Support.
• Involved in the requirements gathering.
• Meet with the technical and non-technical teams on the requirements and systems information.
• Architect the Enterprise Data Warehouse.
• Provide the estimations to the project team as required.
• Provide the inputs on the Oracle design and development standards.
• Data modeling using the power designer to design the DAR data model.
• Create the ETL mappings using business objects Data Integrator.
• Lead the team in providing the reporting solutions to the Business.
• Train the users on the ad-hoc reporting.
• Analyze the post recruitment survey (PRS) requirements.
• Discuss and provide solutions for the new Business Intelligence tools purchase.
• Analyze on the Report Distribution tools in the market.
• Evaluate, present and configure the InfoBurst tool.
• Administer and configure the InfoBurst tool to integrate with the Business Objects.
• Get along with Configuration and Change Management process as per the need for new business rules.
• Implement the reporting solutions on top of Oracle EBS and Hyperion data sources using OBIA out of the box packages.
• Create and maintain the Meta data across the systems.

Environment: Oracle 10g/11g, SQL, PL/SQL, OWB, Business Objects, Visio, Toad, Word, Excel, Microsoft Project, Power Designer, InfoBurst, Xcelsius, .NET, SQL Developer, InfoBurst, Hyperion (Financial Forecasting), Informatica, Data Stage, Cognos, OBIEE, OBIA, DAC, Discoverer (EBS Reporting) and Windows.

Confidential

BI/Data warehouse/Data Architecture (Consultant)

Responsibilities:

• Meet the users across the geographies to understand the requirements.
• Analyze the current process for generating metrics.
• Analyze the source system across the geographies.
• Road map to initiate the new implementations.
• Discuss and provide solutions for the new Business Intelligence tools purchase decisions.
• BI Solutions for Customer Billing System.
• Discuss and document the current and desired ETL.
• Identify and provide the solutions for the MDM initiative.
• Gather, analyze, and transform the current reporting requirements into business intelligence reporting specifications.
• Data profiling on all sources to baseline the current data quality.
• Identify and document the current issues and gaps.
• Document and discuss the desired state.
• Create the data model based on the requirements
• Aggregate tables will be created based on the dashboard requirements.
• Create and maintain the Meta data across the systems.
• Involve, discuss and estimate the future workload.
• Provide status to the Business Team and the Project Team as required.
• Define and enforce standards and conventions (definition, naming, abbreviation)
• As an SME (subject matter expert) provided the information to the SQA, System Test and Performance testing teams on the scenarios and test cases.

Environment: Oracle 9i, DB2, SQL, SSIS, SAP, Business Objects, OBIEE, OBIA, DAC, Power Builder, Power Designer, Erwin, OWB, Lotus Notes, Data Stage, Visio, Provision, Toad, Micro Strategy, Cognos, Microsoft Project, Unix, Erwin, Teradata, Informatica, Crystal Reports, Xcelsius.

Confidential

Sr Developer

Responsibilities:

• Understand and discuss the complete BI systems.
• Gather the information on Business Objects Architecture.
• Analyze and Document the impact analysis.
• Prepare the process steps and Estimate the Migration Plan.
• List all the repository information and the parameters for Universes, Reports, Connections and Documents in the repository.
• Backup the repository.
• Verify all Business Objects products are installed and properly configured, according to a supported deployment configuration.
• Test the functionality of all the desktop and server products.
• Verify the size of repository, reports, and universes.
• Open each universe; test the connection, parameters, joins.
• Open each report and test the functionality and export it again.
• Data Model including logical and physical process.
• Extensive use of SQL Server tools in the process.

Environment: SQL Server, Oracle, DB2, PL/SQL, SQL, SAP Business Objects, Visual Basic, Informatica, Data Stage, Abinitio, Actuate, Microstrategy, Cognos, Toad, Word, Excel, Microsoft Project and Windows XP.

Confidential, NY

Sr. BO Analyst/Designer (Consultant)

Responsibilities:

• Design of Universes, Classes and objects for investment management system.
• Create Cardinalities, Contexts, Joins and Aliases for resolving Loops.
• Involved in Installation and Configuration of all Components of Business Objects.
• Managed the Security in Business Objects Product Line Using Supervisor Module.
• Involved in Development and Deployment of Complex Reports.
• Created reports for various Portfolios using the Universes and Free hand SQL as Data providers.
• Analyzed reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s.
• Worked on Universes Query Panel, Prompts and Report Layout and re-formatting
• Helping in maintenance work related to reports.
• Designed and Created the Data warehouse database for business intelligence reporting and monitoring including writing ETL processes.
• Created Add-Ins and Macro’s based on the end users requirement using VBA.
• Generated web reports using Web Intelligence (Integrated using WIBEAN) to popup in Java Server pages.

Environment: Oracle 8i, SQL, PLSQL, Business Objects 5i (Supervisor, Designer & Reporter) with Web Intelligence 2.6, IIS 4.0, Broadcast Agent Server, Visual Basic6.0, COM, Java, JSP, EJB, VB Script, Java Script, Web Logic, HTML, Acta, and Windows NT4.0.