SUMMARY

• Over all experience of 8+ years in Data Analysis/Product Manager/Project Manager
• Extensively contributed to Analyst, Product Management, Product Marketing, Sales Engineer and Engineering
• Skilled in problem solving, pre - and post-sales customer interaction, business metrics for growth campaigns
• Experience with Looker, Tableau, Salesforce, CRM tools, KPI reports, A/B testing-Adobe test and target, Splunk
• Experience in SQL, Hive QL, Python, JSON, javascript, jQuery, REST API,A/B testing, game development in Unity and SmartAds
• Substantial amount of data analysis, statistical analysis, delivered insights, dashboards, analytical framework
• Product development with go-to-market strategy, market research, and voice of customer analysis
• Experience with Software Development Life Cycle, Agile methodologies, Scrum, Kanban, Plan-driven using JIRA
• Customer presentation, platform demo, gathered feedback, solved technical issues working cross-functionally
• Presented technical content, demo video at Conferences, Early Access Program, Customer visit, Webinars, blogs
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.

TECHNICAL SKILLS

Web technology: HTML, PHP, CSS, XML, AJAX, ASP.NET, Sharepoint - WSS v3.0, MOSS2007

Database: Oracle8i/9i/10g/11g, SQL Server 2k/ 2005/2008/2012 , Sybase, MySQL and MS Access., SAP HANA, Teradata, Hbase, MongoDB, Python

Operating System: LINUX (Red Hat);

Languages: C, C++, JAVA, MATLAB, SQL, TSQL, PL/SQL

Software tools: File maker Pro, Adobe CS4-Suite, NS-2, OPNET, VMware Player, Tableau, MS Visio, MS Access, Splunk, Looker

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr Data Analyst / Modeler

Responsibilities:

• Gaming analytics with deep data analytics SaaS platform
• Supported and evangelized sales by running product demonstration and development community
• Worked with customer’s technical team, resolved customer issues through integration process
• Developed test applications and code to support customers in SQL,Python, javascript and JSON to monitor KPIs
• Documented and maintained customer presentation, FAQ as well as support documentation
• Created tables, views, sequences, indexes, constraints and generated sql scripts for physical implementation.
• Contributed to Confidential ’s future growth through innovative new approaches to development and technology
• Developing Conceptual, Logical and Physical Data Models.
• Executed quality assurance and quality control of project data
• Performs application/ data / technical-related forensics work
• Work closely with management to prioritize business and information needs
• Trace data from source (PaaS vendor) system, through conversion routines, to destination system; ensuring accuracy and completeness
• Consolidate data findings of legal documents
• Interact with business team and identify the business expectation from the "Data" and help the Data Governance Council to define the scope and priorities for developing, deploying and/or improving data management standards, policies and processes to enhance the quality and completeness of the organization's data
• Integrated Policy and Customer data from Guidewire and MS dynamics (CRM) into the MDM Solution.
• Performed Metadata Migration of MDM Change List from one environment to another to facilitate Informatica MDM code migration.
• Partner with vendor and data conversion teams to understand and document conversion data flows, especially with an outcome towards on-going system data analysis

Environment: Hadoop, Hive, Erwin, MS Sql Server 2008,SQl Scripts, Zena, Jira, Teradata Sql, ALM, Microsoft Visual studio 2013, IBM Mainframe

Confidential, Sunnyvale, CA

Sr Data Analyst / Modeler

Responsibilities:

• Documented and maintained customer presentation, FAQ as well as support documentation
• Reviewed production data, production operations by querying Hadoop/HDFS
• Generated Data Maturity Analysis/ Assessment. Identified and Escalated Data Quality issues and deficiencies. Provided recommendations to resolve challenges.
• Built ETL programs with SQL*Loader, PL/SQL to populate Oracle tables with data supplied in CSV format.
• Extensively testing ETL experience using Informatica 9.1/8.6.1/8.5 (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Developed data metrics to measure data availability, ETL performance. Developed log, web-page scrapers
• Performed Data Analysis, Data Migration and data profiling using complex SQL on Various sources systems including Oracle and Teradata. Design documentation and its delivery management
• Participated in Requirement gathering for data modeling purposes
• Manipulated data from website using Vlookups, Match from MS Excel to obtain accurate data feed for visualization
• Participated as Scrum member during SCRUM calls while following Agile Methodologies, to ensure that product
• Drafted a document of requirement analysis which was used to build website's user interface
• Conferring with clients to verify their financial/credit transactions and to resolve their complaints assessing, analyzing and interpreting complicated financial information
• Preparing reports about the degree of risk in lending money to clients
• Developing Deployment Scripts to prepare stage gate Environments.
• Developing ETL Design Approach Documents
• Identification of Business Processes and respective Data Elements.
• Designing Multidimensional schema and developing Data Marts

Environment: Windows 7.0, Oracle9i,ETL Design, SCRUM, SQL, PL/SQL,FAQ, UNIX shell scripts, Java, SQL*Loader, MS SqlServer 2008, Teradata, Net Framework 4.0, Windows workflow Foundation 4.0, Erwin, Oracle 10g

Confidential, Sunnyvale, CA

Data Analyst / Modeler

Responsibilities:

• Extensively contributed to Product Management for PRD, MRD, functional specification, pricing/quote tool;
• Experience in ETL process, monitoring, tracking and analyzing Business metrics
• B2B Product Marketing with launch activities, webinars with partners, sales engineers and engineering team
• Provided field’s feedback to Engineering team and contributed to addition of functionality in next generation
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Supported SEs and Professional services engineer by answering technical and supportability questions
• Customer, Technical presentation, Usability test and demo presentation to customers and Partners across all Geos
• Data Modeling (Conceptual, Logical, Physical Data models).
• Developing Deployment Scripts to prepare stage gate Environments.
• Developing ETL Design Approach Documents
• Work closely with IT, business application and data governance teams to build an enterprise data model and governance framework
• Developing Gateway to provide the Data feed to Smart Care from external data provider (SUNRISE).
• Identification of Business Processes and respective Data Elements.
• Designing Multidimensional schema and developing Data Marts
• Meetings with SMES on Functional Clarifications.
• Developing the multidimensional Reports adhering to the
• Developed and presented technical presentation, demo and hands-on lab; booth activities at Confidential Insight Conference’2014, 2013 and 2012 at US and Macau (2012); Lab Guide for VMWorld’2012

Environment: Windows 7.0, Oracle9i, UNIX shell scripts, SQL Scripts, Java, SQL*Loader, MS SqlServer 2008, Net Framework 4.0, Windows workflow Foundation 4.0, Erwin, Oracle 10g

Confidential, Andover, MA

Data Modeler/ Data Analyst / Technical Analyst

Responsibilities:

• Developing Conceptual, Logical and Physical Data Models.
• Developed and executed development plans and revised as appropriate to meet changing needs and requirements.
• Support data governance, integrity, quality and audit functions
• Own the development lifecycle and managed technical risks throughout the project
• Developing Architectural Design Documents.
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata, in order to ensure accuracy of the data between the warehouse and source systems.
• Performed MDM product evaluations (Master Data Services and Informatica MDM) to determine the best fit MDM tool for Hartford Steam Boiler.
• Developed Data Model for the PEP portal (Conceptual, Logical, Physical Data models).
• Analysis of EDI capabilities of BizTalk vs. Provider Transactions.
• Actively Participated in identifying the HIPAA5010 Impacted Business process in the Health Care provider domain and also Instrumental in defining the remediation strategy
• Effort Estimations for Each phase of requirements.
• Lead the customer status calls
• Demonstrated HIPAA5010 solution to the prospective clients
• Acted as Mentor for the complete Development Team and also provided training to the Team and other stake holders.
• Reviews work of development team.

Environment: Windows 7.0, Sql Server 2008,SQL Scripts, Oracle 10g/11g, Teradata, .Net Framework 4.0,SilverLight4.0 Windows workflow Foundation 4.0, Erwin, BizTalk Server 2010,Visual Studio2010

Confidential, Lawrence, MA

Data Analyst / Modeler

Responsibilities:

• Provided technical direction for the development, design, and systems integration for AFP Europe solution from definition phase through implementation.
• Developed and executed development plans and revised as appropriate to meet changing needs and requirements.
• Own the development lifecycle and managed technical risks throughout the project
• Developing Architectural Design Documents.
• Data Governance, Data Analysis, End-to-end Data Quality
• Developed Data Models for the AFP Europe portal (Conceptual, Logical, Physical Data models).
• Data Analysis and Data loading using Sql Server Integration Services (SSIS)
• Effort Estimations for Each phase of requirements.
• Lead the customer status calls
• Acted as Mentor for the complete Development Team
• Reviews work of development team.

Environment: Windows 7.0, Oracle 10g, Sql Server 2008, .Net Framework 4.0,SilverLight4.0 Windows workflow Foundation 4.0, Erwin, BizTalk Server 2010,Visual Studio2010

Confidential, MA

Software Engineer /Data Analyst

Responsibilities:

• Developing Logical and Physical Data Models.
• Preparing HLD and LLD documents
• Maintaining version of code through Harvest 7.1
• Scheduling of jobs through Control-M
• Reference Data pull
• Data Governance, Data Analysis, End-to-end Data Quality
• Developing ML
• Updating CMFAST and uploading the Ctrl-m tables
• Unit testing, System Testing, Integration Testing
• Developing Design Strategies
• Understanding the Current Architecture of all CIB Interfaces for all 21 applications.
• Testing workability of all Interfaces.
• Control-m - Jobs execution and collecting the statistics
• CPU, Memory and I/0 Utilization calculation
• Developing Capacity blue print doc.
• Performance testing of OSA cube reports using Grinder

Environment: Erwin, Oracle Designer 2000, oracle 9i &10g. UNIX, Harvest, Control-M, Sql Loader