SUMMARY:

• IT professional over 20 years of IT experience with strong ability to implement enterprise wide data warehousing and business intelligence reporting solutions.
• Have a proven record of playing various roles i.e. developer, analyst, technical lead, solution architect, Data Architect. Carry strong interpersonal skills, highly adept at facilitating discussions and negotiations with stakeholders.
• Recognized project management skills, consistently deliver complex, large - scale projects on time and within budget

TECHNICAL SKILLS:

Database/Data warehouse: Teradata, Oracle, SQL Server

Data Modeling tools: SAP Power Designer 16.5, ER/Studio, System architect

BI/Reporting Tools: Business, Objects, OBIEE, Hyperion Essbase

Other Tools: Golden Gate, Teradata data mover, Informatica, TOAD, Share point(Document & Content Management), case and change management tool

Other Skills: Hadoop(HDFS), Hortonworks UI (HUI), NO SQL, Big data, Analytics, Data Integration with Hadoop with Enterprise Data Warehouse systems, SQL,PL/SQL, Perl /CGI, JAVA, MS Project, MS Visio, Unix, Data profiling

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect

Responsibilities:

• Working with business teams and technical analysts to understand project’s business requirements. Determine how to leverage technology to create solutions that satisfy the business requirements
• Serving as a technical liaison for business teams to help define, estimate and recommend optimized solutions for business opportunities
• Providing critical architectural inputs during RFI and RFP process
• Creating High Level Solution Design (HLSD) in support of Enterprise Projects and present HLSD to senior leadership during Capital Assessment reviews
• Determining and validating potential data sources, extract method and building designing Data Model, source to target mapping with appropriate logic for each table’s attribute/column
• Designing the solution to create OLAP cubes, dimensions, business critical KPIs, and MDX queries using Analysis Services.
• Preparing detail Architecture Design document with visual diagrams of system architecture, functionality, and process flows. Presenting solutions to clients, project teams, and other stakeholders adapting style to both technical and non-technical audiences and receiving the desired approvals
• Building a validation plan, assisting development with building informatica workflow scripts, executing the scripts and communicating results in non-production environment
• Working with development, infrastructure, test, and production support teams to ensure proper implementation of solution
• Developed proofs-of-concept and prototypes to help illustrate approaches to technology and business problems
• Attention to detail, time management, work prioritization, multi-tasking, estimate tasks, on-time deliverables and task delegation & follow up

Major Projects milestones delivered

Responsibilities:

• Big data/Hadoop Project - Currently working on Integrated Data warehouse(IDW) migration project to land big amount of data in to established data lake area on Hadoop Distributed file systems. Apply the logic to filter meaningful data and load in to Teradata 3 NF layer.
• Supply Chain Project: Working on 2 device life cycle projects related to device assessment, Device insurance, remorse returns and device trade-ins.
• Consolidated Subscriber Reporting(CSR) project to consolidate various billing systems in to report number of subscribers and their product/feature line they are using. Prime responsibility in this project was to design sourcing data (master, reference and transactional) from 10 different source and land them in landing zone and to move to Teradata staging layers. Close to 130 tables were designed and staged in Teradata in 4 months (4 releases in each month)
• Siebel Replacement project (CRM) This project was done to replace Dealer information in data ware house with SAP CRM without impacting running BO reporting and other downstream.
• Device Recovery Program was related to Supply chain management This is to track the device once it recovered from customer in exchange program, warranty program, lost, insurance etc. and resold back to the customer
• Implemented reporting capability on various prepaid and postpaid data passes sold by Confidential
• Implemented database system to store customer data who are not willing to be contacted by email, phone, address and applying the rules to the database as per legal department

Data Architect/Analyst

Responsibilities:

• Worked as data analyst/architect in Enterprise Identity and Access management group(EIA) to synchronize data between Central Profile database and its downstream/upstream database i.e. partner, HR, manufacturing, customer.
• Analyzed the broken processes and redesigned to make user profile as single source of truth.
• Draw the 150K, 75K and 50K architecture view of Cisco enterprise identity and data access.
• Developed the process to calculate service offering metrics (ITaaS) for EIA
• Led the cross functional team’s architects and PMs to define the strategy and implementation of

Technical Project Manager/Lead

Responsibilities:

• Led the 8 people team to implement data replication solution project to replicate over 1500 3NFtables (5TB of data) to another dedicated server within negligible time in a real time manner.
• Defined the roadmap to increase the data warehouse parity level to 8/9
• Implemented the BAR and fallback process to back up the data under the same project Educated the executives/users of Finance, HR, Sales, Marketing about data resiliency features/solutions of teradata and option of load balancing by using replication server
• Engaged respective data stewards/team to help in analysis and grouping of the tables Involved with infrastructure team to plan, configure and procure the hardware for the project
• Conducted weekly meetings with cross functional teams/stakeholders to review key project milestones, accomplishments, risks and escalations throughout the development life cycle.

Data Analyst/Architect

Responsibilities:

• Worked as an architect to develop a user profiling, policy and access management system.
• Collaborated and conducted detail with finance and marketing business to gather the requirement for application and data access. Documented the business and technical requirement. Presented the user profiling and access management solution to stakeholders to implement.
• Designed and modeled table structure in teradata to authenticate and authorize users to access BI dashboard, BO universe and Essbase cube.
• Defined the various test scenarios to test BI applications in OBIEE, Business Object and Essbase.
• Designed the web based tool to define the user roles, groups and policies and its association with corporate hierarchies for data and application access

Analyst/Technical Lead

Responsibilities:

• Led the migration of Enterprise Booking and associated hierarchy data from Oracle to Teradata data warehouse
• Conducted deep dived sessions with Teradata professionals and data warehouse expertise to define the 3NF structures, semantic views and business views for bookings and expense data
• Involved actively in data modeling changes from conceptual phase to logical and physical design changes.
• Sat with OBIEE, Essbase and business objects developers team to make the required code and environmental changes
• Helped business to write various test scenarios. Planned and coordinated unit, integration and end to end testing with end users. Provided required post production support

Architect/Technical Lead

Responsibilities:

• Responsible for creating and supporting all dashboards/portals/cubes/BO Universes for Corporate finance group.
• Designed/developed the foundation of bookings and expense data and ETL process in data warehouse to bring transactional data from ERP/ODS and other sources and summarized them with hierarchies like sales, product, time and customer. Established the data and hierarchy at enterprise level to make it adaptable and scalable across different business entities
• Led the team to design and develop enterprise Essbase Cubes using ASO & BSO technique. Also designed the underlying data layer in oracle to upload the cube. Wrote the calc scripts to calculate various metrics within the cube. Wrote batch programs to create the user roles and filters in Essbase cubes. To name e few big cubes are Customer Profitability Analysis cube, Attached Rate, Profit & Loss, Worldwide Bookings cube
• Enhanced Finance Business Objects universes to bring new objects and its data in data warehouse. Played a administrator role to create the user and provide the access.

Technical Lead

Responsibilities:

• Designed and developed CA financial reporting applications for application called “CA-Finance
• Financial Reporting System” and “Customer Advocacy Revenue Margin Analysis (CARMA)” using
• Java/J2EE, Perl/CGI technologies. Involved in interacting with business manager, users, gather the requirement, transform them into technical requirement, conduct the user testing, data refresh scheduling using $Universe.