SUMMARY:

• Highly motivated IT professional with 10+ years of experience as a EDW, BI, ETL & BIGDATA Architecture and Developmentin Telecom, Media Entertainment and eCommerce domains.
• Vast experience in Agile, Scrum and Waterfall SDLC models for multiple full life cycle projects.
• Highly Proficient in working with Business Intelligence and Reporting tools like SAP BO, Tableauon Windows and Linux Environments.
• Expert in using SAP Business Objects Web Intelligence/Desktop Intelligence/Universe Designer/CMS/Central Management Console/Web Intelligence Rich Client.
• Expertise in Enterprise ETL tools like Talend Big Data, Talend Data Integration, Talend MDM, SSIS and Oracle PL/SQL . Experienced in doing testing anddata validation from various source to target systems.
• Administered and managed Reports/Dashboards development on SAP BO and Tableau performed Patching/Fixing, Reports migration, Optimization, Enhancementsand Upgrades.
• Excellente documentation of Business Requirements gathered using Client interactions, Brainstorming Sessions ; Evaluating Data Sources, Translating Requirements into Business Use Cases.
• Highly proficient in the use ofRBDMS Oracle and NoSQL DB like MongoDB, Cassandrafor querying and reporting purposes
• Expert in Interface Development for Data Migration from Legacy systems like AS400 to SAP BO/BW
• Facilitated Change Management and Conflict Resolution Confidential various stages of the project life cycle by streamlining communication among the project stakeholders and end users.
• Testednumerous reports generated in SAP Business Objects, Tableau systems by comparing results with back end DB.
• Solid SQL skills, can write complex SQL queries; functions, triggers and stored procedures for Backend testing, Database Testing and End - to-End testing.
• In-charge for knowledge management/transfer to Ensure technical and Production Support from offshore
• Responsible for Developing Oracle Scripts Jobs/procedures/packages as well Mongo optimization.
• Managed Onsite/OffshoreETL & Analytics teams encompassing SAP BO/MongoDB implementation.
• Good experience with source version control tool such as SVN, Visual Source Safe, GIT, PVCS.
• Expertise in Functional Testing to ensure a Data Quality after Migration and experience in conducting User Acceptance Testing (UAT) to ensure business requirements have been fulfilled.
• Strong ability to thoroughly documentUser Manuals after subsequent releases and conducting User Training Workshops to familiarize Business users to the changes in Reports and Dashboards
• Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment.
• Good analytical thinking, Critical thinking, Problem solving ability to translate technical requirement to test plans. Ability to work seamlessly with Onshore/Offshore teams
• Strong communication and team skills, ability to work independently with minimal supervision.

TECHNICAL SKILLS:

Reporting and Analytics: SAP Business Objects 6.5/XI R2, XI R3.1, Tableau 8.x/9.x, Power BI, SSRS, Actuate Reporting, Seagate Crystal reports, R Studio 3.4

ETL & OLAP: Talend Open Studio, Talend Big Data, Talend Data Integration, Talend MDM,Microsoft DTS, SSIS

RDBMS: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2005 and 2008, DB2/400

NoSQL: MongoDB 3.X, Cassandra 2.X

Columnar DB: HP Vertica

Operating System: Windows NT/XP/2000, UNIX, Linux

Version Control: GIT, Visual Source Safe 6.0, PVCS, JIRA, HP ALM

Domains: Telecom, Media, Entertainment &eCommerce

PROFESSIONAL EXPERIENCE:

Sr. ETL/BI/Bigdata Architect

• MongoDB implementation for Order Capture Engine Landscape. Includes software/infrastructure/Licensing planning till implementation.
• Design and Architect the Dimensional Data Model and ETL process.
• Acquire and interpret business requirements on data integration across heterogenous environment, create technical artifacts, and determine the most efficient/appropriate solution design, thinking from an enterprise-wide view.
• Responsible for MongoDB OLTP data migration to Oracle DW for reporting and analytics. (Real-time as well ad-hoc)
• Data manipulations/transformations/integration across MongoDB, Cassandra, Vertica and Oracle. involved with monitoring and support for ETL jobs.
• Responsible for Oracle Jobs/procedures/packages optimizations.
• Managing Reporting and analytics over tableau for Shared Services and Customer Service management team.
• Onsite POC for 2 teams Confidential offshore encompassing MongoDB implementation as well ETL & Analytics.
• Documentation for knowledge management. Ensuring technical and production Support from offshore.

Skills Utilized - Oracle 11g, Cassandra 2.0/2.2, MongoDB 3.2/3.4, HP Vertica, Talend Open Studio 6.3/6.4, Tableau Desktop 10.x, Tableau Server 10.x

Lead EDW/BI/Bigdata Architect

Confidential, Burbank, California

• Single POC for development and maintenance of reporting needs across Inventory Operations, Customer Service as well finance and accounting departments.
• Design & Architect ETL & ELT data modelsand documentation.
• Improved performance of existing ETL jobs as well involved with monitoring and support for ETL jobs.
• Onsite POC for 3 offshore teams encompassing SAP BO, Talend, Tableau as well legacy reporting needs.
• Responsible for requirement specification, analysis and detailed level designing for the enhancements.
• Training & Supporting end-user reporting needs using Business Objects.
• Responsible for reviewing the deliverable to ensure quality. Documentation for knowledge management. Ensuring technical and production Support from offshore.

Skills Utilized - BO XI R3.1, Talend Open Studio for Big Data 5.X, Tableau Desktop 8.2/9.1, Tableau Server 8.1/9.0, Crystal Reports 2011, Web Intelligence, Info View, CMC, Xcelsius, QaaWS, Web Intelligence Rich Client, SQL Server2008/2012, Oracle 9i/11g

Sr. EDW/BI/ETLArchitect

Confidential, Burbank, California

• Played role of Solution and Implementation Lead for Digital Avails Project.
• Analyzed business problem and formulated the technical architecture.
• Lead the development team for entire solution in two phases including the historical data ingestion and automatic data import for future announcements.
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Skills Utilized - Tableau Desktop 8.2, Tableau Server 8.0, SQL Server 2010, SSIS, VSS, Talend

• Developed PoC for extracting licensing information from 3rd party websites using API call and manual scrapper techniques
• Developed a dashboard in Tableau with sample data to visualize the “to-be” form of the solution and showcased to client
• Explored the options of using 3rd party vendors to have a uniform data extraction for quick solution implementation.

Skills Utilized - TOS 5.X, Tableau Desktop 8.2, Tableau Server 8.0, SQL Server 2010, VSS, Talend

Technology Lead

Confidential, Burbank, California

• Worked as Analyst and senior developer for Rights and Restrictions, Deals, Business Partner and Release windows Legacy to SAP conversion.
• Architect the data model and requirement gathering.
• Managed the UAT project efficiently and helped business rollout projects in multi-channel by quickly resolving issues through the aid of technical& functional knowledge

Skills Utilized - Oracle 10g/11g, PL/SQL, TOS 5.X

Technology Analyst

Confidential, New York, New York

• Reference Data migration from GCDM to Talend and from Talend to JAZZ.
• Rights data loading into Talend and then from Talend to JAZZ.
• Ensuring the interfaces takes care of all the business rules for Rights and reference data management.
• Interface error reporting and mailing.
• BO Upgrade from 6.5 to XIR2 to XIR3 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Extensively worked with security issues and user maintenance in XIR2/XIR3.1

Skills Utilized - SAP DS, Talend MDM 5.X,BO XI R3.1, Crystal Reports 2011, Web Intelligence, Info View, CMC, Xcelsius, QaaWS, Web Intelligence Rich Client, Oracle 10g

Technology Analyst

Confidential

• Business objects administrator
• Migration of BO reports/Dashboards/Universes from BO 6.5 -> BO XI R2 -> BO XI R3.1
• Resolving incidents/tickets with meeting the timelines
• Scheduling & tracking the change requests. Status reporting Confidential key milestones.
• Universe Design & Design reviews.
• Coding for complex requirements and Code reviews.
• Configuration controller and Release management activities.

Skills Utilized - BO XI R2, BO XI R3.1, Desktop Intelligence, Web Intelligence, Info View, CMC, Xcelsius Oracle 10g/11g, Sql Server 2005

Confidential

• Requirement Gathering and analysis
• High level and Detail design
• Development of application
• Integration testing
• Training the WMI UK Finance End Users on Business Objects Reporting capabilities and application handling.
• Maintenance of applications

Skills Utilized - BO XI R2, BO XI R3.1, Desktop Intelligence, Web Intelligence, Info View, CMC, Xcelsius Oracle 10g/11g, Sql Server 2005

• Requirement Gathering and analysis
• High level and Detail design
• Coding using C#, .Net framework 3.0/3.5,Oracle 10g,Pl/Sql
• Integration and System Testing

Skills Utilized - Desktop Intelligence, Web Intelligence, Info View, Oracle 10g/11g, Sql Server 2005

Senior Systems Engineer

Confidential

• Development of interface over Legacy systems ranging from AS400, Oracle, Power Builder to the staging area for ETL Interfaces to populate data in SAP Business Warehouse using SAP Business Objects Data Services.
• Documentation for knowledge management. Ensuring technical and production Support from offshore.
• Responsible for end to end development and presentation of applications (Music streaming, Mobile Wallet, Web service consuming) designed on Windows Mobile 6.5 professional.
• Responsible Application Support and Maintenance.
• Development and testing for the enhancements.