Summary

• Working with Oracle SQL, Pl/SQL code using TOAD and Ms SQL server management Studio T-SQL with SSRS/SSIS tool.
• Solid IT experience as a Business Analyst in deployment of web-based, Client-Server applications, developing business processes and system used on various projects from conceptualization to implementation.
• Excellent technical writing skills to create Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Cases Specifications.
• Strong process modeling using UML Use Cases, Sequence Diagrams, Activity Diagrams, etc.
• Strong in writing SQL queries and reporting the results to the business team.
• Excellent conceptual and working knowledge of System Development Life Cycle, OO Models and UML Methodologies.
• Fluent in a broad range of technologies, including business process tools such as MS Project, Excel, Access and Visio.
• Strong database integration experience analyzing data needs, identifying relational databases and coordinating the modeling.
• Well versed in Requirements/Change Management, Impact Analysis and Gap Analysis.
• Interacted with SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Requirements gathering with strong Analytical and Problem Solving skills with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.
• Worked with SAS Visual Analytics for better data visualization, easy predictive analytics and business intelligence to explore data and build reports.
• Working in conjunction with testers QA , developers and other team members in validation and testing of complex projects and in the maintenance of Quality Standards of projects as a Business Analyst in deployment of web-based, Client-Server applications, developing business processes from conceptualization to implementation , Production support, Troubleshooting, Systems analysis.

Work Experience

Confidential

Business Intelligence Analyst

• Automated and scheduled the reports based on the customer requirements.
• Working with requirements gatherings with creating Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Cases Specifications.
• Working in conjunction with testers QA , developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
• Developing and designed executive management reports, to support the information needs using oracle version 11i SQL, PL/SQL procedures, functions and triggers with toad.
• Working on Production support which is related mainly any defects or Change request By changing the existing code or add new code using oracle SQL and PL/SQL resolving the trouble tickets everyday basis.
• Working with oracle SQL, PL/SQL writing complex queries and generating reports based on customer needs.
• Working with SAS Visual Analytics for better data visualization, easy predictive analytics, business intelligence and a full range of on-premise and cloud-based deployment to explore data and build reports.
• Responsible for DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, definition with client and day-shift groups.

Confidential

Senior BI Data/Report Analyst

• Worked with Strong database development used SQL writing SQL queries and reporting the results to the business team with Strong Requirement Traceability Matrix mapping.
• Worked with requirements gatherings with knowledge of System Development Life Cycle, RUP, OO Models and UML Methodologies. Fluent in a broad range of technologies, including business process tools such as MS Project, Excel, Access and Visio. .
• Worked with Strong database integration experience analyzing data needs, identifying relational databases and coordinating the modeling and well versed in Requirements/Change Management, Impact Analysis and Gap Analysis.
• Worked with a fast-paced, collaborative, project oriented environment.
• Worked with SQL server management Studio using Microsoft Sql Server 8 to develop reports.
• Worked with DBIS Reporting tool to Automate and Schedule some of the Reports.

Confidential

Database Developer/Report Analyst

• Designed and developed new application to automate the process for few internal applications.
• Responsible Worked with oracle PL/SQL and my sql database writing sql queries and generating reports Automated and scheduled the reports based on the customer requirements.
• Wrote PL/SQL procedure using oracle version 11i based on the business rules on customer needs of very large multi-terabyte data environment.
• Provided support to required Business Intelligence which includes Business Objects, SAS, Tableau.
• Worked with Business Analyst to understand to business rules for the write deliverable.
• Worked with Informatica ETL project to perform ETL architecture, solution and mapping and development.

Confidential

Business Intelligence Analyst / Report Analyst

• Created Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Cases Specifications.
• Worked in conjunction with testers QA , developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
• Developed and designed executive management reports, to support the information needs using toad, using oracle version 10g and 11i SQL, PL/SQL procedures, functions and triggers with toad.
• Assisted in developing and implementing policies, processes and procedures for project management and the development organization using Oracle on very large multi-terabyte data environment.
• Created Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Cases Specifications.
• Worked in conjunction with testers QA , developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects Worked with Requirement Analysis, , Business and Systems reviews and working sessions to understand the requirements and system design.
• Worked with building data warehouses, ETL architectures used Informatica tool to extract, transfer and load data on very large multi-terabyte databases.
• Worked with running semi-automated standard daily /weekly/monthly reports using Oracle application entering requests into tracking tool using workflow, delivering reports via email, project management activities.
• Used Business objects to support the senior Program Manager by working with report stakeholders and recipients e.g., labs, fundamental network planning, mobility PMs, engineers, etc. on an ongoing basis to collect feedback, assess report effectiveness and validate the accuracy and comprehensive reflection of program status.
• Used SQL Loader to Load millions of records to oracle table and also extracting data from oracle database by writing shell script to generate the management reports from there based on their requirements.
• Responsible for DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, definition with client and day-shift groups.

Confidential

Data Architect / Reporting Analyst

• Worked on P L Profit and Loss Daily Status CR related Defects on daily basis for Care/Telegence billing systems by fixing the code using oracle 10g. SQL, PL/SQL with toad and SQL server in the front end.
• Created Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Cases Specifications.
• Worked with Requirement Analysis, JAD sessions, Business and Systems reviews and working sessions to understand the requirements and system design.
• Created Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Cases Specifications.
• Worked in conjunction with testers QA , developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects Used ETL tool Informatica for data manipulation in Oracle tables and schemas by creating Informatica mappings to extract data from source databases to target database.
• Worked on Change Request for Technical design Document and development based on Functional Requirements Document with Traceability for AT T Agency Model/Networx module to Allocate BAN level to CTN level.
• Worked on Production support which is related mainly any defects or Change request from production. by changing the code or add new code using oracle pl/sql procedures.
• Responsible to make sure system test has been completed for CRs related defects and also all test cases have been executed and have passed the validations in dev before migration to QA through Kintana process.
• Developed and designed executive management reports, to support the information needs using toad, Oracle 10g SQL and PL/SQL and SQL server 2005 SSRS/SSIS both windows and UNIX environment..
• Supported Senior Program Manager with data from multiple external databases used to create ad hoc reports
• Used Business objects to support the senior Program Manager by working with report stakeholders and recipients on an ongoing basis to collect feedback, assess report effectiveness and validate the accuracy and comprehensive reflection of program status.
• Responsible for DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, definition with client and day-shift groups.
• Developed plans for testing, implementing, and validating delivered reports, creating reports according to project specifications, addressing data quality issues with users, vendors and management.
• Worked with WLNP Wireless local Number portability Using Clarify CRM tool to update the cases and sub cases with open Escalation and closed functionality.
• Generated daily. Weekly, monthly reports based on upper management needs.
• Created new tables, procedure to insert data into table on a timely manner using SQL server.
• Used SQL Profiler for monitoring and troubleshooting database activity and performance.
• Proven tracked record in high-transaction, high-volume, web/e-commerce and/or high-availability 24/7/365 SQL Server environment s .
• Worked in physical and logical design of medium-large databases 100GB .
• Worked in functional / cross-functional teams.

Confidential

Software Engineer

• Developed and designed executive management reports, to support the information needs using toad, Oracle 9i SQL and PL/SQL procedures, functions and triggers and packages.
• Worked in conjunction with testers QA , developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
• Created logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin.
• Wrote Oracle SQL queries MS Access/Excel and Crystal reporting to extract data from Oracle RDBMS. Also worked with creating an internal Web sites using Dream weaver, JSP and HTML.
• Worked on production support by resolving error messages shows up during phone activations on daily and weekly basis for different partners for Care and Telegence billing systems.
• Developed, designed a database schema based on a web based application tool, also management reports, to support the information needs using Oracle 9i SQL, PL/SQL.
• Developed and designed this web based Application tool using CGI/PERL in UNIX sun Solaris environment for patch writer/Patch approver to create and approve patches for GPS /CDMA wireless software solution group.
• Worked with CDMA group with their products to gather required information for designing the database.
• Wrote Oracle SQL PL/SQL queries, stored procedures and functions and cursor to extract data from Oracle RDBMS.
• Applied business analysis processes to the development and creation of reporting requirements.
• Performed data validation tasks via system and process flow analysis using SQL Query.
• Created various types of internal Web sites using CGI/PERL, Java Script and HTML. On UNIX server.
• Deployed web pages to intranet sites for internal customers.

Confidential

Application Developer/Data warehouse

• Developed, Designed and generated ad hoc reports, standard management reports or system files, to support the information needs using application tools Oracle SQL, MS Access and Crystal Report.
• Wrote SQL PL/SQL stored procedures and functions to extract data from Oracle RDBMS.
• Used Informatica tools for data manipulation in Oracle tables and schemas by creating Informatica mappings.
• Created various types of internal Web sites using ASP, Java, VB Script, Java Script, XML and HTML.
• Deployed web pages to intranet sites for internal customers.
• Applied FrontPage with Paint Shop Pro and Photoshop to create web page graphics.
• Created various types of Web based Reports using Java based tool Called WebFOCUS with WebFOCUS OLAP Online Analytical Process for Information Technology Department.
• Placed and assisted internal and external customers in defining new or enhanced reporting requirements.
• Retrieved data from Oracle RDBMS using Oracle 8i by creating SQL queries, PL/SQL cursor, functions and stored procedure to extract data from Oracle server.
• Developed plans for testing, implementing, and validating delivered reports, and assisted in carrying out plans to successful completion.

Confidential

Reporting Analyst/Data warehouse designer

• Established Web based reports using Java servlet, Java script and HTML, XML.
• Placed web-based reports on MCI Intranet for internal and external customers in production support.
• Responsible for the design, maintenance, and support of Data Warehouse Systems which includes data warehouse configuration, methodology, design, and modeling
• Retrieved data from Oracle RDBMS using Oracle 8i by creating query, using PL/SQL statements with logical and physical design on the back end and also used JDBC connection from Java servlets to Oracle database to extract data from Oracle database.
• Documented requirements and applied business logic to the development and creation of reports.
• Established, Built and maintained reports and databases used MS Access and Oracle PL/SQL and SQL Server.
• Developed, designed logical and Physical model, maintained, transferred data from Oracle to MS Access and Excel.
• Performed data validation tasks via system and process flow analysis using SQL Query.
• Involved in data warehouse project with some data mining by sorting through data to identify patterns and establish relationship and utilizing Data Stage.
• Created logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin. Used database macros and modules to automate process, restructured and analyzed ad hoc reports.
• Added and updated data and transfer the updated merged data as input to SAP MM module
• Worked with application developers to design and develop database objects and structures according to project specifications, addressing data quality issues with users, vendors and