SUMMARY

• Overall 11 years of IT experience in the field of Business/Data Analysis, Data Modeling, Database Programming, Data Warehousing, Data Migration, Data Integration, Quality Control and Team Management.
• Global experience in delivering data solutions in Oracle and SQL Database Server Technologies for Telecom, ERP and CRM domains.
• PMP certified, experienced with Software Development Life Cycle (SDLC) and Scrum Agile development methodology.
• Hands on experience in analyzing and writing business requirements, functional specifications, translating functional specifications to technical specifications, creating database design and mapping document, reviewing documents, coding, troubleshooting, debugging the code, testing and resolving issues.
• Experience of working with management and subject matter experts to halp define new reporting requirements.
• Experience in Conceptual, Logical and Physical Database modeling with different modeling tools including ERwin data model.
• Proficient in defining ETL processes from Heterogeneous sources as databases, file system.
• Experience of building data warehouse and good knowledge of Star/Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de - normalization, data extraction, data profiling and cleansing, data manipulation.
• Hands on experience in ORACLE, MS SQL server, MySQL in writing complex PL/SQL, T-SQL Stored Procedures, Triggers, Tables, Views, User defined Functions, Pro*C, SQL*Loader and Oracle Import/Export utilities.
• Experience in creating utility scripts with Unix/Shell scripts and scheduling it via Cron jobs.
• Very well conversant with Informatica Power Center ETL mappings, mapplets, sessions and workflows.
• Good knowledge of SAP Business objects and WebI reports.
• Experience with Unit testing, Integration testing for data validation of source to target data.

TECHNICAL SKILLS

Operating Systems: Unix, Linux, Windows NT, Windows Servers

Languages: SQL, PL/SQL, T-SQL, C, Pro *C, Perl, Java, Unix Shell Script

Databases: Oracle 6/7/8i/10g/11g, MS SQL Server and MySQL

ETL Tools: Informatica Power center 9

BI Technologies: SAP Business Objects, Tableau

Tools: /Utilities: ERwin, Visio, Turbo Analyst, TOAD, PVCS, VSS, SCCS, Git, Jira

Reporting Services: Oracle Reports, Business Objects WebI Reports

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Helped the pre-sales team with proposals, proof of concepts and data architecture after analyzing the corporate data warehousing needs.
• Defined data model for new initiatives related to development of executive dashboard for campaign management, customer service systems and sales analytics.
• Created best practices document for data quality management and conducted training sessions on data quality, ETL, data warehousing etc.
• Performed data validation, ETL processes, reviewed queries and coding standards to ensure delivery of quality builds to multiple clients across AdTech, eCommerce and CRM domains.

Environment: Erwin, Linux, Oracle10g/11g, MySQL, Informatica 9.1, SAP Business Objects, Tableau.

Confidential

Data Analyst & Tester

Responsibilities:

• Reviewed the business requirements for the campaign analytics data warehouse and analyzed the multiple channels/networks source data in the form of API/web services, excel files, databases to come up with data extraction strategy and the data model.
• Mapped the data from various source on to the target data model.
• Implemented shell scripts for reconciliation of data from web services to generate daily load files.
• Provided support in developing and maintaining ETL processes to extract data from multiple sources and standardizing the data set for site, page and placements.
• As a hands-on QA Analyst coordinated the functional testing effort. Documented the test cases; performed data validation using SQL queries and back-end testing of source to target data.
• Developed report queries for campaign performance against various dimensions/facts.

Environment: ERwin, Linux, Shell Scripts, MySQL, Excel, Java, Ruby On Rails, Highcharts, AWS

Confidential

Business/Data Analyst

Responsibilities:

• Discussed and analyzed the project requirements and created the specification documents for the online storage system.
• Reviewed and enhanced the base data model for the application using ERwin.
• Coordinated the daily meetings with the development team to review the implementation progress and assist with queries related to the data model.
• Performed integration testing and provided support to resolve any issues identified during UAT.

Environment: Linux, J2EE, JSP, Servlets, ERwin, MySQL.

Confidential

Data Analyst/Lead

Responsibilities:

• Facilitated in the overall management of the 3 projects, eService 6.0, eGain-Mail, eGain-Campaign, including defining milestones, deliverables, establishing success factors and status reports.
• Interacted with the product management team, created requirement documentation, functional specifications, design documents of the new product eService 6.0.
• Analyzed and designed new enhancements for eGain-Mail release. Coordinated the implementation with the development and QA team. Successfully delivered multiple releases.
• Created the data model, optimized and implemented queries/scripts of Rules and Routing engine, the core of the eService 6.0 platform. This engine was used to apply the workflow rules to the incoming emails/webform enquiries and route the same to the destination queue or customer agent according to SLA.
• Reviewed, optimized and tuned the eGain-Campaign Management System database and T-SQL scripts to deliver high volume of campaigns, significantly reducing the execution time.
• Worked with the QA team to develop test strategies, load test cases, defect reports, traceability matrices and test environments. Managed the testing process, issue reporting and analysis of test results.
• Trained the support team in installing, configuring eGain-Campaign system and eService 6.0-workflow engine.
• Conducted periodic team reviews and generated proficiency reports.

Environment: Windows NT 4.0, IIS, MS SQL Server, T-SQL, COM, ASP, JScript, Linux, C, Weblogic 7.0, J2EE, Oracle, PL/SQL, VSS

Confidential

Business/Data Analyst

Responsibilities:

• As a Business/Data Analyst, discussed the requirements of the automation process with SMEs, analyzed the business processes and created the Requirement Design Document, Data Flow Diagram and ER data model.
• Reviewed the requirements with the development team and assisted in creation of test strategy document.
• Performed Code reviews and Unit Testing.

Environment: Windows NT 4.0, MS SQL Server, Visio, MS IIS, ASP, JavaScript and VBScript, PVCS

Confidential

Data Analyst & Programmer

Responsibilities:

• Designed and implemented the database backup and recovery modules.
• Implemented the shell scripts and PL/SQL for the backend processing which were invoked from the front-end Oracle Forms.
• Designed new reports for metering and billing in Oracle Reports.

Environment: Sun Solaris, Oracle 8i, PL/SQL, Oracle Reports, Forms 4.5, Oracle Application Server 4.0.6, Oracle Developer Server 6.0, PVCS

Confidential

Data Analyst & Programmer

Responsibilities:

• For the monthly enhancement releases, interacted with the British Telecom subject matter experts; analyzed requirements, provided estimation for the enhancements and designed the new features.
• The system performance was slow, so studied the database, created indexes wherever needed and tuned all the SQL queries and PL/SQL scripts, wrote new PL/SQLs which enhanced the response time significantly.
• Developed the DCE/RPC servers in C to be invoked by the VB client of the system.
• Managed the change requests; developed integration test scripts and performed system testing.

Environment: Unix, C, DCE, Entera, Oracle 7, PL/SQL, TOAD and VB

Confidential

Data Analyst & Programmer

Responsibilities:

• As their was no documentation for the existing data warehouse, analyzed and documented the existing system, reverse engineered the current data model using Turbo Analyst tool and created the source to target data mapping.
• Performed the impact analysis of the new Home Highway requirements, estimated the work efforts and worked with the project management team to create the implementation plan for the Home Highway Data Warehouse.
• Developed the design document for ETL process to be implemented by SQL*Loader scripts, PL/SQL batch processes and cron jobs.
• Implemented and performed the code review of the new SRS data loading scripts. Optimized & tuned complex PL/SQL batch processes to improve the performance for loading large data sets.
• Worked closely with the QA team to clarify the functionality, provided feedback for timely resolution of issues and performed system integration testing of the Home Highway DW enhancements.
• For the frontend UI conversion module, analyzed the complexity of UI forms and created a strategy document for conversion of Oracle Forms 3.0 to Oracle forms 4.5

Environment: Unix, Oracle 7.3, Oracle Forms 3.0, Forms 4.5, SQL*Loader, PL/SQL and Unix Shell Scripts, SCCS, TURBO Analyst case tool

Confidential

SQL Programmer Analyst

Responsibilities:

• Maintained and enhanced the Purchase & Finance Systems.
• Designed and developed a system in Pro*C and PL/SQL to schedule all the operations of planned Customer Orders for a given period. This significantly reduced the manual work of shop floor users.
• Designed and developed the data model of vendor approval and qualification module.
• Optimized the performance of Purchase Module PL/SQL scripts and implemented the PL/SQL procedures for yearly database trimming.
• Worked with management and subject matter experts to halp define new reporting requirements and developed ad/hoc SQL reports.
• Created data migration strategy and scripts to migrate Purchase system database objects from Oracle 6 to 7.
• Provided training and technical support of the new enhancements to the end users.

Environment: Unix, Oracle 6, Oracle 7, PL/SQL, SQL*Forms 3.0, SQL*Report Writer, Pro*C, SQL*Loader, SQL*Plus, Import and Export utilities of Oracle, TURBO Analyst case tool.