SUMMARY:

• 14+ years of hands - on experience as a Big Data developer, ETL Developer, Tableau Developer, Data Analyst

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Datadase developer/ Analyst

Responsibilities:•

• Interacting with the Business team to understand the requirements, implement agile methods for quick delivery
• Working on SW services migration project with different sources for Install Base, Pricing, Finance and Opportunity data
• Data analysis and gap analysis between different systems
• SQL ETL development, server configuration
• HDFS data load, data analysis using swoop, hive
• Tableau reporting: Structure, develop and create dashboards for CSC reports, data visualization in Tableau.

Front end Tools: Hadoop Business rules manager, QlickView 360 reporting tool, Unica, Business Intelligence (Services BI, Finance BI), HP QC, Mantis, Tableau

Confidential, Cupertino, CA

Oracle Developer / Data Analyst

Responsibilities:

• Create adhoc reports as per requirements from end users using google analytics
• Extensive A/B testing for web site traffic analysis
• Data query using Java
• Analyze data for production issues
• Support UAT testing for upcoming applications.

Front end Tools: Developer web portal, Google Analytics

Confidential, San Jose, CA

Data Analyst, SME

Responsibilities:

• Active participation in all the stages of project life cycle including concept commit, business commit and execute commit following Cisco standards. Worked successfully on multiple cross functional back to back quarter releases
• Worked on project plan development to capture all the required tasks and timelines. Conducted status meetings with IT team and closely monitored the project status as per project plan. Resolved the issues, showstoppers etc. Updated management with the status on weekly basis
• Requirement gathering:
• Worked with Cisco customers, end users from different domains and Cisco acquisition companies for gather business requirements. Interviewed stake holders to tap new business opportunities Proficient in creating sequence diagrams, activity diagrams and Visio data flow diagrams.
• Documented flow charts, algorithms instructions for tech team.
• Understanding the Business objectives/requirements, review BRD/ARD, interaction with users to ensure capturing all the requirements as per business needs
• Worked with the Solution delivery team to review the business requirements in order to make them understand the complete requirements and reviewed the solution design documents
• Data quality management: Worked on install base, pricing and opportunity data profiling taking care of data consistency, data integrity. Validated data as per requirements. Plan, document and execute data cleansing/manipulating activities.
• Being SME on the project, shared complete process knowledge on all the components with the new teams from both IT as well as business
• Testing:
• Created test case documents for business acceptance testing
• BAT and UAT testing planning and execution.
• Supported completely during BAT/UAT cycles acted as interface between user/stake holders and IT team, provided complete analysis for all the defects/issues to ensure the smooth and pleasant interaction between the teams

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL/HiveQL, Stata, R, MySQL, Java, Google API

Confidential, San Jose, CA

Business/Data Analyst

Responsibilities:

• Participated in complete project life cycle starting from vendor selection process in the foundation releases. Worked successfully on multiple cross functional back to back quarter releases
• Involved in project planning and complete execution. Hosted status biweekly meetings with the IT teams and reported management team
• Requirement gathering: Hosted meetings with System Integrator users across Cisco to capture requirement gaps and current issues. Translated it in business requirements in BRD
• Data analysis: Completed data analysis between old and new system. Validated data during production migration

Front end Tools: DRM, Finance BI (revenue, Bookings, Expenses), Hyperion cubes (Revenue, Bookings Expenses), ERP Tools, System Integrator Tool, HP QC

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL

Confidential, San Jose, CA

Data Analyst, IT Analyst

Responsibilities:

• Involved in project planning and complete execution. Hosted status meetings with the IT teams for management reporting
• Requirement gathering: Interviewed acquisition POCs for Cisco integration. Worked closely with POC to understand acquisition data and current process to covert it for cisco reporting.
• Data analysis: Completed data analysis between acquisition data for cisco integration. Validated data during production migration
• Generated upload template with extensive use of excel formulas and macros for monthly uploads
• Supported IT during deployment. Let BAT UAT efforts.

Front end Tools: Business Intelligence (services BI, Finance BI), Data Relation Manager (DRM) Tool, HP QC

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL

Confidential, San Jose, CA

Data Analyst, IT Analyst, SAS Analyst, SME

Responsibilities:

• Involvement in the complete vendor selection process in the foundation releases. Active participation in all the stages of project life cycle including concept commit, business commit and execute commit following Cisco standards. ERMO representative.
• Involved in project plan development to capture all the required tasks and timelines. Conducted status meetings with the IT teams and closely monitored the project status as per project plan. Resolved the issues, showstoppers etc. Updated management with the status on weekly basis
• Worked with Cisco customers, end users from different domains to gather business requirements. Interviewed stake holders to tap new business opportunities
• As part of IT analyst responsibilities, prepared Functional requirement document after complete functional analysis and data analysis. Extract data from different sources using Java and SQL queries. Developed mock - ups for the User Interfaces. Prepared, reviewed test strategy, test plan and test case documents. Worked on data assess. Socialized, reviewed and walked-thru with the IT team to understand Functional requirements and to get sign-offs from the respective teams. Participated in technical solution process to influence the solution to capture the complete functional requirements. Worked in offshore environment with teams from multiple vendors
• Being SME on the project, shared complete process knowledge on all the components with the new teams from both IT as well as business
• Participated functional testing at unit testing and at SIT level
• Data validation between source and target using SQL query
• Provided hand over document for next level of testing to Business and Users
• Supported completely during BAT/UAT cycles acted as interface between biz/user and IT team, provided complete analysis for all the bugs/issues to ensure the smooth and pleasant interaction between business/users and IT team
• Migration Support:
• Participated in migration plan development to ensure smooth deployment
• Supported development team during deployment. Validated the migration in production
• Communicated with business and management team on deployment progress
• Production Support:
• Knowledge transfer on functionally with the support team to bring them up to the speed
• Worked with support team during warranty period
• Provided post migration support in production as and when required from analysis prospective.

Front end Tools: Business Intelligence (services BI, Finance BI), SAS Profitability Management(SAS PM) Tool,, ERP Tools, System Integrator Tool, HP QC, Web analytics

Analytical/communication tools: MS Words, MS Excel, MS Power point, MS Visio, MS Project plan, SQL

Confidential

Software Engineer

Responsibilities:•

• Design, development and coding with ORACLE, SQL, PL/SQL Developed complex Informatica mappings and defined transformation code rules.
• Tuned the mappings and ETL procedures optimize load and query Performance.
• Developed dimension loads change mappings and defined mapping and session updates.
• Designed reusable transformations and shortcuts to share different mappings.
• Handle the development, QA and production folders and production data load validations
• Scheduling the sessions and Start the Informatica Sessions and Monitor the sessions.
• Troubleshoot the loading failure cases, including database problems.
• Estimated the data sizes for cache and index files.
• Involved frequently with management and business unit to learn new requirements.
• Implemented load strategy procedures to improve mapping dependencies

Technology:- Informatica Power Center 6.2, Oracle 8i/9i, PL/SQL, SQL

Confidential

Analyst / Quality assurance engineer

Responsibilities:•

• Requirement gathering from the business clients and stakeholders, data analysis and documentation
• Worked with IT team on execution plans
• Wrote BAT/UAT test plans and test cases, define processes, and determine steps necessary to ensure a high quality software product. Execute test checklist and scenarios to test new product features and functionality. Analyze test results to determine test success or failure. Record defects found in testing using the defect tracking software
• Provided business support in the deployment activities
• Performed production validation and post production support

Technology:- MS Excel, MS Word, Bug Tracking System, Oracle Database, HTML