SUMMARY

• Experience in Data analysis, Data integration, Data Modelling, Database designing & Data transformations while migrating legacy system to Next Gen Big Data Technology.
• Experience with Dimensional, Canonical, Rational, Logical and Physical data modeling
• Develops long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap
• Defining and enabling innovative and advanced technologies to organize, manage and enable complex business analytics capabilities
• Insuring the integration of metadata across the tool suite and the usage and development of the Meta Data repository.
• Experienced in system design, data architecture and modelling - relational for OLTP systems and dimensional for data warehouses and data marts, data governance, master data and metadata management, operational and BI reporting solutions for various clients.
• Involved in implementing Big Data technologies including Hadoop ecosystem, Enterprise Data Lakes for semi-structured, and unstructured data.
• Experienced in designing migration and integration solutions for data from disparate sources.
• Experienced in enhancing complex enterprise data models, accurately representing the logical and DB nuances in physical data models.
• Designed data models (ER and dimensional) for database platforms such as Oracle, SQL Server.
• Experienced in metadata preparation using modelling and DB tools and validation with respective stakeholders.
• Experienced in documentation and conducting walkthroughs on data lineage, system specific data flows, UML Diagrams, conceptual and logical data models for project stakeholders at various levels in the organization.
• Experience in design, development, implementation and support of Business Intelligence (BI) Applications.
• Delivered BI reporting solutions in Power BI and Analysis Services (SSAS).
• Worked on classification & comparative analysis, exploratory data analysis, clustering analysis, aggregation, anomaly detection, data cleansing, data stream mapping and ranking.
• Worked on MS CRM Dynamics for Confidential for data mapping, aggregation, cleansing and distribution across enterprise data landscape of up streams and down streams.
• Good knowledge of business process, redesign, integration of technologies, architecture skills. Possesses project technical expertise, problem solving skills and effective communication skills.
• Played a key role in building and deploying production models, visualizing and reporting data findings in a variety of formats, and analysing data sets to draw business insights for Charter Communications.
• Experience as Business Analyst and SME for requirement gathering, JAD sessions and converting the same into Business requirements leading to functional requirements.
• Collaborated with cross-functional teams of data scientists, analysts, and product managers to determine best practices for leveraging massive amounts of data for mining business solutions in an efficient and effective manner, transforming data insights into actionable reports.
• As a SME worked on CRM (Siebel), OSM (Order Management), AIA (middleware) and OCBRM (Billing) integration and customizations.

TECHNICAL SKILLS

Data Modelling Concepts and Tools: ER Studio, Erwin, SQL Developer Data Modeller, TOAD

Programming/Scripting Languages: PL/SQL, Shell Script, Perl, Pro *C, C, Oracle BRM, Hive, Unix, VB

Reporting Tools: Microsoft CRM Dynamics, Crystal Report, Business Intelligence Publisher(BIP), Power BI

Tools: MS SQL Server Integration Services (SSIS)

Databases: Oracle 9i, 10g, MS SQLServer, Hadoop, Vertica, Snowflake

Markup Languages: HTML, XML

Products and Utilities: GIT, TFS, Confidential Quality Center, Confidential Service Manager, Clear Case, Remedy, Visio, MS Office, OCBRMS, Interconnect Billing, Confidential Billing, SVN, Jira, Sharepoint, Confluence

ETL Tools: SSIS, Talend

Operating Systems: Unix, Linux, Win 2000/XP/7

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Technologies: Toad SQL, Excel, Mainframe, Cobol, Informatica, Analytix, Enterprise Data Lake, Jira, FIS Product core Banking

Responsibilities:

• Worked with Digital One and FIS core banking systems to understand configuration of extracts in the future state
• Helped in mapping and maintaining original design of data in the migration project to Enterprise Data Lake.
• Worked with client data architects to help design the entire future state exceptions process
• Handled Transaction code mapping and solutioned the concept of synthetic transaction code so that downstream will have no impact.
• Helped in identifying and resolving issues for the data present in current state and future state.
• Handled Account Opening/Closing selection/exclusion criteria based on various products and services attached to the product to provide the referral credits to self tracking system for reporting purpose.
• Helped Design the entire data pipeline for billable units for both commercial and retail customers
• Lead discussions with business on future state of products and create innovative solutions to data flow issues and core banking functionality
• Discussed with venders to find what source system data would provide the best solutions
• Mapped interface from the future state source system to current legacy system
• Created complex joins to join future state tables to meet the requirements for interface mapping
• Created test cases for mapped interface to check migrated data quality
• Answered tickets and questions from developers
• Worked with legacy system owners to understand functionality of current systems and communicate changes for future state functionalities

Confidential

Data Analyst

Technologies: Snowflake, Metriplex, ServiceNow, Github, Jira, AWS Cloud

Responsibilities:

• Performed end-to-end Data analysis, Data integration, Database designing & Data transformations which involved bringing in Data from D2A and create D2B metrics in snowflake.
• Involved in discovery of requirements of various reports
• Involved in performance tunning and incremental loading of data.
• Engaged in comparative analysis, exploratory data analysis, aggregation, anomaly detection, data cleansing, data stream mapping & ranking.

Confidential

Data Architect

Technologies: ER Studio, SAP Hana(S4), Confidential Legacy Source Systems, UDM

Responsibilities:

• Performed end-to-end Data analysis, Data integration, Data Modelling, Database designing & Data transformations which involved bringing in Data from SAP Hana S4 as Upstream to EDL (Hadoop) Data Lake.
• Involved as Data Modeler to transform the data for both consumption and ingestion layers.
• Involved in creating Data Model for different layers, Data Analysis and Data Profiling using ER Studio.
• Implemented Confidential data policies & standards for the system.
• Built functional and technical design specification documents for the system.
• Mapping all the fields to the tables and preparing feeds for ETL to push data loads to Hadoop cluster
• Involved in discovery of requirements of various reports
• Engaged in comparative analysis, exploratory data analysis, clustering analysis, aggregation, Anomaly detection, data cleansing, data stream mapping & ranking.
• Gained comprehensive functional knowledge of S4 and helped the upstream and downstream support teams in development and Operations.
• Interacted with the business teams for requirement elaborations and gap analysis of S4 data model.
• Facilitated mapping, xsd & reporting of S4 mapped data sources for various down streams.
• Involved in reviewing and mentoring the offshore team while delivering Data Model.

Confidential

Data Architect

Technologies: ER Studio, Hadoop, Hive, MapReduce, MS CRM Dynamics, Power BI PL/SQL, Shell scripting, Oracle 11g, MS SQL, Vertica, Azure pipelines

Responsibilities:

• Performed end-to-end Data analysis, Data integration, Data Modelling, Database designing & Data transformations which involved bringing in Data from MS CRM Dynamics as Upstream to EDL (Hadoop) Data Lake using Talend.
• Involved as Data Modeler to transform the data in Hive Layer.
• Involved in creating Data Model for different layers, Data Analysis and Data Profiling using ER Studio.
• Delivered BI reporting solutions in Power BI and Analysis Services (SSAS) for Ops Analytics
• Played as CDAX functional SME to support all the downstream systems.
• Implemented Confidential data policies & standards for the system.
• Built functional and technical design specification documents for the system.
• Mapping all the fields to the tables and preparing feeds for ETL to push data loads to Hadoop cluster
• Involved in discovery of requirements of various reports
• Engaged in comparative analysis, exploratory data analysis, clustering analysis, aggregation, Anomaly detection, data cleansing, data stream mapping & ranking.
• Gained comprehensive functional knowledge of CDAX and helped the upstream and downstream support teams in development and Operations.
• Interacted with the business teams for requirement elaborations and gap analysis of CDAX data model.
• Facilitated mapping, query & reporting of CDAX mapped data sources for CSIR, IIAEastwood, APJ1 and all other commercial and consumer down streams.
• Handled UAT support for CRs and Defects for coordinated release with CDAX.
• Played SPOC for handling and coordinating all issues, queries and clarifications related to CDAX.
• Helped in reviewing and mentoring the Lithium team for their Data Model.

Confidential

Data Architect

Technologies: Oracle11g, PL/SQL, Shell scripting, Informatica, Oracle BRM, Pipeline, Unix

Responsibilities:

• Reverse-engineered legacy data structures into physical and logical Entity-Relationship models and discovered business rules.
• Mapped data elements using their semantics from legacy systems to the enterprise data model.
• Performed data transformations to develop forecasting reports, by using the data through ETL tables and written the transformation scripts using Oracle BRM FM customizations, Unix and shell scripting So that the report will show the data for future 11 months.
• Designed end to end reconciliation reports using Oracle BRM FM customizations, Unix and shell scripting.
• Configured the products, discount, deals and plans as per product catalogue.
• Participated in discussions to ensure all necessary details for the business requirements are captured and gathering requirements by analysing the current system and then create the high level design document for the project.

Confidential

Data Modeler

Technologies: Oracle11g, BIP, PL/SQL, Shell scripting, Cobol, OBRM, Unix

Responsibilities:

• Created the Data Model for the Charter T3 Users as per there business requirements to prepare the Reports using BIP.
• Involved in discovery of Legacy Biller Requirements by doing Reverse-engineering of legacy data structures into physical and logical Entity-Relationship models and discovered business rules.
• Involved in Data Analysis and Policy Customizations for Charter.
• Developed the reports using BIP as per business requirements.
• Configured the products, discount, deals and plans as per product catalogue
• Opcode customizations to develop reports for Collections using Oracle BRM.
• Involved in writing TDD’s for the business requirements which contains technical details and flows for the modules
• Involved in per to peer and technical reviews to facilitate best practice and bug free delivery.