SUMMARY

• 7+years of Telecom industry experience with expertise in Business Intelligence, Busines/ Systems Analysis, Data Analysis/ Requirement Manager/Data warehousing/Data Modeling.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
• Experienced in Workflow Analysis, Gap Analysis for implementing trading system
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server database.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Extensive experience in Sybase Database Servers, developing and maintaining automated software used to monitor the database
• Responsible for creating the XSD for various services.
• Familiar with SQL. Conducted presentations, training & support using online meeting software MS - Live Meeting & SharePoint
• Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical models.
• Expertise in writing JavaScript, HTML, DHTML, VBScript, XML and XSLT.
• Extensive experience in configuring data mapping between different Databases.
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
• Extensive experience in conducting Joint Application Development (JAD) sessions.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
• Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
• Good knowledge and problem solving skills in LAN/WAN, TCP/IP protocol.
• Proficient in Functionality Testing, Black Box Testing, System Testing, Integration Testing, and Regression Testing.
• Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) Extensive experience in User Acceptance Testing (UAT).
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema
• Proficient in programming languages like C, C++, Java and .NET TECHNOLOGIES
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Efficient in converting the systems database from Sybase to oracle & vice versa.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS

• ERWIN
• ETL: Ascential DataStage (7.x 6.x 5.x)
• Star-Schema Modeling
• Snowflake Modeling
• FACT and dimension tables
• Erwin 4.0
• Business Objects
• Erwin 4.x
• C/C++
• Java SE 1.4
• TURBO PASCAL 7.0
• VB.Net
• HTML
• TCIL/CobiT
• COBOL
• SQL Server
• MySQL
• Oracle
• Sybase PowerDesigner (v4 - 11)
• Sybase System 10
• Sybase ASE (11 - 12) and Sybase ASA (6 - 9).ASP/ASP.net
• PHP
• Microprocessors 8085 & 8086
• TCP/IP
• LAN/WAN
• Wi-Fi
• Unix
• MVS
• MS Windows/95/98/NT/2000/XP
• MS Project
• MS Visio
• MS DOS
• MS Office 2000

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Business Systems Analyst

Responsibilities:

• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Involved in development phase meetings for business analysis and requirements gathering for the Common Claim Layout (CCL).
• Used SOAPUI for validation of WSDL, XSD, XML of Web Services and XML files for the request and responses
• Work with Telecommunication carriers with regards to Telecom expense management, Telecom resources auditing and management.
• Creating unique customer Clipbook environments utilizing HTML and XML
• Configuring and maintaining of test setups involving Windows, SUN VPN by applying all roles and policies.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Collected information and requirements about different Entities and attributes from FDS.
• Completed GAP analysis in detail on all entities in CCL for a source system.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Produced Salesforce reports monitoring group progress.
• Generated Statements of Work for the Design and Implementation of CRM solutions based on Salesforce.com Methodology.
• Support is provided by multiple means using remote utilities such as VNC and MS Live Meeting for remote users.
• Responsible for gathering system requirements, Technical writing, documenting works and process flows between Oracle Payables 11.5.8 and Oracle Cash Management 11.5.8
• Requirements Gathering/Documentation - Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
• Developed front-end using JSPs, HTML and used JavaScript for client side validations.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Performed a gap analysis between the current TWG control framework and COBIT.
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Used JSP, DHTML, AJAX and java script for presentation layer.
• Designed/implemented corporate wide LAN/WAN /infrastructure
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Performed workflow analysis, developed process diagram, and gathered the requirements for the new system.
• Configured the Data mapping between Oracle and SQL Server.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Provided data modeling support for numerous strategic application development projects.
• Documented the meeting minutes with issues of about discussed and solutions resolved.
• Completed the documentation of Claims Scenario’s for the source system.
• Presented the mapping document with all business logic applied for the system to Project Manager.
• Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
• Created the test cases for all the Use Cases using EA tool.
• Created test scripts for all the test cases in PL/SQL.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, Autosys 4.1, WinCVS 1.3, Enterprise Architect 4.5, Sybase, Java Script, Toad 8.0, HTML, DHTML, XMLErwin, Business Objects, Windows NT 4.0,UNIX, Oracle, PL/SQL, DOS and UNIX Sequential Files, TCIL/CobiT, MS Access, MS Live, MS Visio, CSV Files, XML File

Confidential, Bellevue, WA

Systems Analyst

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Gathered and documented business requirements for existing and future business systems.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Conducted JOINT APPLICATIONS DEVELOPMENT (JAD) sessions with the participation of the users and the stakeholders to gather requirements.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Performed Gap Analysis to review the existing XML XSD and make necessary changes.
• Supported Telecom and Computer systems for call center, doctor and nurse referral programs.
• Created source table definitions in the DataStage Repository by studying the data sources by importing the data from Mainframe.
• Conducting live training and review sessions with business partners using MS Live meeting.
• Extensively used CFS, MFS stages.
• Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Facilitated JAD sessions and used WebEx, MS-Live Meeting and Skrbl Whiteboard for discussions and sharing ideas.
• Involved in the documentation and technical writing of the requirements in an elaborate way
• Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.
• Responsible for troubleshooting and resolving LAN/WAN problems users encounter during the workday
• Created and handled sales reports (Salesforce), activity reports, forecasting, referral summaries and other miscellaneous ad hoc reporting.
• Coding screens, client forms, Servlets and client side validations by Java Script
• Used CSS, HTML and Javascript for GUI front end designing and validations.
• Created surrogate key tables to map the required dimensions.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Implemented and oversaw the ongoing execution of the ITIL/ COBIT best practice frameworks.
• Network LAN/WAN design and implementation
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Generated XML documents using the XML Output Stage.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences.
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, DataStage BASIC language Expressions, SQL Server, ITIL/COBIT, Business Objects, Windows NT 4.0, Sybase, UNIX, Oracle, PL/SQL, Java Script,, IBM DB2, Dbase3, Erwin, MS Live, MS Access, XML Files, MVS, IMS.

Confidential, King of Purusia, PA

Systems Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Reverse Engineered the existing ODS in to Erwin.
• Responsible for GUI design, Workflow analysis, Prototyping and Business development
• Conducted meetings for the Data Modeling and Analysis.
• Enforced naming standards.
• Worked with XML files and suggested changes to the XSD.
• Facilitate training of new product telecom roll-outs for cellular and paging services by vendors.
• Created the logical models and generated the physical models in the databases using Erwin.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Worked on exporting data using Teradata.
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
• Created Hash tables referencing the Surrogate Key tables for quicker and more efficient lookup to Dimensions.
• Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file, Transformer stages.
• Evaluated, analyzed, and made recommendations for global IT management processes using CobiT maturity models.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Imported and exported Repositories across DataStage projects.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Trouble-shooted jobs using DataStage Debugger.
• Worked on performance tuning and enhancement of DataStage job transformations.
• Summed key performance indicators using Aggregator stages as an aid to Decision Support Systems.
• Used DataStage Director Run time engine to schedule and execute developed jobs and job sequences, and use Log events to monitor job progress and performance.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: Ascential DataStage 6.0(Manager, Director), MS Project, Visio, Office, Business Objects,IBM DB2/UDB Universal Database Oracle, MS SQL Server 7.0, CobiT, HTML, XML, UNIX, Windows NT, Sybase.

Confidential, Boston MA

Sr. Systems Analyst

Responsibilities:

• Drive the completion and complete alignment of system design from business requirements and architectural design.
• Track, drive and coordinate program development activities, per requirements and design, with Business owners, IT PMO, and IT Development teams across US and EMEA.
• Document and analyze business requirements, functional requirements, system capabilities, and detailed design.
• Responsible for the offshore project infrastructure co-ordination/testing/setup - VPN, tools, environment etc. Plan and perform integration testing activities.
• Involved in the system workflow analysis and contributed to the overall work flow diagram for the website.
• Inventory all telecom equipment for all U.S. cost centers.
• Ensure consistent and effective communication among all parties.
• Proactively identify and resolve issues by working with all portfolio teams.
• Create and publish periodic executive reports.
• Conducted and participated in Review & Peer Review sessions with SMEs and vendors to gather business and technical requirements using MS NetMeeting, MS Live Meeting, email and conference calls.

Environment: Ascential DataStage 6.0(Manager, Director), MS Project, MS Word, Excel, PowerPoint, MS Live, MS Visio, Business Objects,IBM DB2/UDB Universal Database Oracle, MS SQL Server 7.0, CobiT, HTML, XML, UNIX, Windows NT, Sybase.

Confidential, Dallas, TX

Systems Analyst

Responsibilities:

• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Propose process improvements to documentation and technical writing procedures.
• Developed Parallel jobs using Stages, which includes Aggregator, Join, Transformer, Sort, Merge, Filter and Lookup.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Generations of Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
• Responsible for assisting clients in resolving various network and systems management problems using ITIL. Assignments.
• Followed the adaptive RUP framework for the whole Project life cycle (PLC)
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
• Worked as Senior Software Engineer in Telecom domain
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Implemented local containers to simplify the job design.
• Implemented shared containers to use in multiple jobs, which have same business logic.
• Involved in writing Job Automation process i.e. writing shell scripts using Korn shell, as scheduled daily, weekly, monthly, and sending these jobs to clients’ email-ids.
• Involved in DBA tasks such as table creation and maintenance, create indexes, optimize queries, and grant privileges.
• Involved in creation of Database Tables, Global Temporary Tables, Cluster Tables, Partition Tables, and Index-by Tables using storage parameters.
• Wrote many stored procedures, stored functions, Packages and used in many Forms and Reports.
• Created indexes on tables and Optimizing Stored procedure queries.
• Involved in interaction with the End Users and implemented reviews of the application.

Environment: Data Stage 5.2, Oracle, Windows NT, SQL Server, CobiT/ITIL, MS- excel, CSV files, UNIX, Sybase.