SUMMARY

• Result oriented, Oracle 10g Certified Associate with proven track report of over 14 years, specializing in Oracle9i and Oracle10g.
• Strong understanding of entire Software Development Life Cycle Process (SDLC) including Data Analysis, Design, Development, Testing and support using ORACLE, SQL, PLSQL, MS SQL Server 2008 and Business Objects.
• Over 9 years of experience in Telecom domain.
• Expert level knowledge of GSM, UMTS and LTE Technology.
• Strong knowledge in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings.
• Strong experience in design & developing ER - Diagrams, Packages, Stored-Procedures, Functions & Triggers.
• Experience in building complex reports and working in very large Databases.
• Worked on Confidential Fusion Works Mediation Systems for Confidential
• Having good knowledge of end to end architecture of Mediation, Service Provisioning, Revenue Assurance and Fraud Management applications. Also worked closely with Billing, CRM and Order Management team in different projects. Know overview flow of PCRF, Charging & Rating.
• Excellent analytical skills for understanding the business requirements, business rules/processes, and detailed design of the application.
• Excellent experience of Database Administration, Backup & Recovery
• Worked on RAC in Active-Active mode.
• Experience in Migration of Databases example Oracle 9i to Oracle 10g Release2 migration.
• Excellent team management, resource allocation and communication skills.
• Experience in doing planning and architecting new release at different stages of product.
• Hand on experience on Oracle Spatial for Confidential at Southampton, UK.
• Experience of working in both centralized and decentralized DATABASES interacting with each other to meet different business requirements

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, PL/SQL, XML, UNIX shell scripting, Perl scripting

Operating Systems: Win NT/2000/XP, Solaris and Unix

Tools: TOAD, PL/SQL Developer, SQL Loader, SQL Server Management Studio, Business Object BO, Eclipse, STATSPACK, SQL Loader, MS-Visio, Tableau, ATG/ACC/BCC

Databases/RDBMS: Oracle 11/10g, Oracle 9i, SQL Server, My SQL

Billing Systems: FusionWorks Confidential Mediation & Billing Product

GUI related Languages: HTML, XML, DHTML

Business Domain: Telecom, Governance, Finance (Trade Tax)

PROFESSIONAL EXPERIENCE

Confidential, Redmond

Sr. Data Analyst

Responsibilities:

• Providing technical solutions and determine direction of application development based on Enterprise Customers’ Service Level Agreement.
• Participating in strategy meetings and business meetings
• Evaluating the business and technical proposals, by developing ad hoc reports as needed and advice management based on profound data analysis.
• Design and Development of Custom Wireless Performance Report (CWPR) reports using SQL queries and pivot in Excel.
• Calculate the KPIs values associated with MOU (Minute of Usage), Answer Calls & Dropped Calls related to GSM, UMTS, and VOLTE CDR summary data.
• Calculate the KPIs values associated with Attach and PDP related to GSM, UMTS, and LTE Probe data.
• Complete track of BSC, RNC, eNodeB and MME count in regard to the IMSI/Market analysis through SQL scripts using PL/SQL Developer.
• Analyze the Voice and Packet Data results prior to publication to maintain the completeness and integrity of the data.
• Prepared weekly report regarding 2G, 3G & LTE Packet Data/Voice Retainability and Accessibility.
• Analyze, Generate and Publishing CWPR Monthly Market, National Trend Reports.
• Analyze, Generate and Publishing CWPR Metrics Reports for all Enterprises.
• Design data audits and ensure the integrity of data.
• Analyze, Generate & Present weekly Decipher report for Tektronix in regard to vendors like Nokia, Ericsson, Lucent using pivot table formulas skills in MS Excel & PL/SQL, MS Access
• Data loading of CSV files into Oracle tables using SQL Loader.
• Developed customized canned reports for network performance investigation using PL/SQL.
• Using SDLC Concepts for data generation and end user Reports.
• Open trouble tickets with SQM on problems identified related to validity of KPI data.
• Maintain information for SGSN using data Mapping techniques and interlinking it with the existing Reports for through investigation.
• Created case diagrams to explain the flow of events and how different schema tables interact with each other using MS Visio.
• Troubleshoot identified data anomalies by examining SQL code and data processes. Communicate effectively with diverse Technical and Operations team members with recommendations for corrective actions.
• Creating oracle Packages, Procedures and functions to automate recurring reports.
• Tuning SQL queries using Explain plan.
• Respond promptly to client and internal ad-hoc report requests. Use role as SME (Subject Matter Expert) to provide interactive guidance to decision makers during report development, ensuring requested reports meet business requirements.

Environment: Oracle 11g, Business Objects XI, PL/SQL Developer, Visio

Confidential

Software Engineer

Responsibilities:

• Understand the requirements, arrange meetings with business users.
• Transformation of Functional Requirements into technical requirements.
• Worked in the development, deployment, environment build-up/configuration, Release Notes, ADD (Advance Design Document) & code review for IPUB (IP Usage Billing) project.
• Reviewing and researching policy charging rule issues for resolution.
• Responsible for configuring the statistical definitions (types, SLA, KPI, Log messages, Alarms)
• Reviewing Data statistics and Alarms generating and storing in databases to resolve issues.
• Design and Development of Daily, Weekly and Monthly reports using SQL queries.
• Responsible for installing workspace, XML component files.
• Responsible for creating Price plans on ATG ACC.
• Responsible for writing SQL functions, procedures and packages.
• Responsible for reference data installation (create table, indexes, upload data using SQL loader).
• Responsible for maintaining table partitions.

Environment: Oracle 11g, Oracle SQL Developer, ATG/ACC, Putty, VNC Viewer

Confidential, Bothell

Sr. Data Analyst (Lead)

Responsibilities:

• Identifying and creating new tools using Perl scripts to support data management and other critical functions within the B2B e-commerce Group.
• Reviewing, researching routing production issues for resolution.
• Coordinating and supporting new requests for Device, Accessory, Rate Plan, Features, and Promotion using ATG/ACC/BCC.
• Coordinating, creating and maintaining stored procedures, data reports using Toad, T-SQL, SQL and Business Object.
• Scheduled recurring reports using Perl and Business Object (BO).
• Following roles performed to maintain SQL Server 2005/2008:
• Implementing and managing database security (Create and maintain Users and roles, assign privileges).
• Maintain Backups.
• Snapshot of the database.
• Data refresh for Developers.
• Database tuning and performance monitoring.
• Migrated database from SQL Server 2005 to SQL Server 2008.
• Managing workloads to ensure tasks are completed on time with 100% accuracy.
• Training team members

Environment: Oracle 10g, SQL Server 2005/2008, PL/SQL Developer, Business Object, Toad, XML, HTML Perl and ATG/ACC/BCC

Confidential, Bothell

Software Engineer (Lead)

Responsibilities:

• Involve in various discussions with Mediation, Billing, CRM and other teams for solution development & impact analysis in RA & FMS applications for any new Network Element
• Creating Fusion Works Environment for testers by applying different patches provided by developers for a specific projects.
• Developed environment for Bid-Based, Nokia MMS, C-SMS Processor and Data Scalability etc. projects.
• Resolves different tickets rose by testers and production support team and also re-assign some tickets to developers.
• Created different dummy Correlators & Collectors for testing.
• Parse raw feed files using Correlators and Collectors and insert data into Oracle tables.
• Maintaining Partitions and Indexes.
• Provide the necessary data for testers from Production based on the requirements.
• Created different dummy Correlators & Collectors for testing.
• Coordinate with FW Mediation support and Database support team in deployment of patch in production server.
• Checking out different branches from CVS & creating a tar ball for production deployment.

Environment: Oracle, Fusion Works, dsd, PL/SQL Developer Toad, Sun Solaris, WebTrax

Confidential, Redmond

Lead Database Administrator

Responsibilities:

• Mining the data warehouse for ad-hoc reports.
• Develop complex reports by crunching data from 250TB fact table using SQL, PL/SQL.
• Developing customized canned reports in Business Objects
• Designed Data Interface from CDRlive to the Planning and Forecasting Division of Confidential .
• Analysed the reports and identify network bottlenecks, subscriber churn, device performance
• Evaluate Enhancements / Change Request implemented to the application and advice management
• Propose improvements to the application.
• Responsible for taking all kind of backups i.e. cold backup, hot backup and export Backups.
• Responsible for creating Tables and indexes.
• Analysis and implementation of partitioning of the database tables. Designed a partition management script for data warehouse.
• Designing and developing new interfaces.
• Wrote packages, stored procedures, function to support the system.
• Overall performance management of different datamarts.
• Providing Database support to other developers or database administrators.
• Performance reviewer for the project.
• Coordinating man power resource requirement for Databases.
• Doing regular database administration job.
• Achieved wireless competency level2 certificate from organization.

Environment: HP-UX, Solaris 9 - Oracle 9i/10g, SQL Server 2005, PL/SQL, SQL Plus, UNIX shell scripts

Confidential

Database Administrator

Responsibilities:

• Performed regular database administration job.
• Transformation of Functional Requirements into technical requirements.
• Help to developer in writing code and Review of code created by other team members.
• Loading data into database using Go Loader tool based on SQL-Loader.
• Tuning SQL and Database initialization parameters.
• Back up & recovery of Databases.
• Maintaining database environment.
• Managed users and roles, writing triggers and functions.
• Creating tables with Partitions.
• Dropping and creation of indexes for processing.
• Automated queries by shell scripts.

Environment: Solaris 8, Oracle 10g with spatial option, PL/SQL, SQL Plus, and UNIX shell scripts

Confidential

Database Administrator

Responsibilities:

• Administration and Monitoring Of the Oracle Databases.
• Responsible for creating oracle database with managing logical and physical structure of the database.
• Responsible to manage tablespaces, datafiles, Logfiles, control files and logical objects.
• Responsible for creating Tables and indexes on appropriate table’s columns and to analysed tables and indexes periodically.
• Managed users and their privileges and roles.
• Responsible for taking all kind of backups i.e. cold backup, hot backup and export Backups.
• Explored knowledge regarding RMAN utility for backup and recovery.
• Responsible to tune the parameter file parameters.
• Responsible of taking Oracle snapshots using Statspack. Diagnose the result and make the changes in the database.
• Analysed all the users and there roles in the database.
• Find the SQL queries, & tune them which suppressed the indexes or degrade the performance of the database.
• Have identified bottlenecks and providing recommendation for solving critical performance issues and database problems.
• Created stored procedures and SQL queries.
• Responsible to test the Load Balance on parallel server.

Environment: Sun Solaris 8, Sun Cluster 2.2, Windows 2000 adv. Server/NT 4.0, Oracle 9i (RAC)

Confidential

Database Administrator

Responsibilities:

• Gathered and understand the requirements.
• Understand the other developed modules.
• Code the requirements.
• Installation of Power Builder 4.0
• Performed regular Database administration work.
• Installation of Oracle Enterprise Edition 8.1.5
• Creation of Database & its associated parameter file (initSID.ora), redo online log files, control files, tablespaces, datafiles, Rollback Segments, schemas, users, tables, indexes etc.
• Established connection between client and oracle database by configuring respective files at client and server side both.
• Create and organize tables, indexes and synonyms.
• Writing views and oracle procedures.
• Involved in making backup strategies and performed export backup and cold backup.
• Tuning of database.
• Porting of data provided by third vendor to Oracle database.
• Involved in development and testing of Registration module subsystem (TRADES R), Assessment Module subsystem (TRADES A) and Documents Dispatch and Referencing subsystem (Drams)

Environment: Windows 98/NT, Power Builder 4.0, Oracle 8.1.5