SUMMARY:

• Over 14 years of hands on experience in the software industry with the know - how of the complete product cycle through requirements, design, development, testing, documentation and delivery .
• Over 8 years of experience in Data Modeling/Architecture and Data/Business Analysis.
• Extensively worked on Data Quality Solutions.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME’s to obtain domain level information of projects.
• Experienced in all facets of Software Development Life Cycle, Business Process Models with focus on Waterfall and Agile methodologies.
• Experienced in gathering Business Requirements, Data Requirements, Functional Specifications and work with technical team to create, interpret and implement business rules into technical specifications/data design.
• Worked on the data and functional modeling phases of the database design, by defining the data entities and their attributes, classifying the relationships among the objects and drafting the general data entity hierarchy.
• Expertise in Relational Data Modeling with very good focus on creating physical models and Dimensional Data Modeling in designing Datamarts and Datawarehouse using Star and Snowflake Schema models in implementing decision support systems.
• Experienced in design and implementation of Star Schema, Snowflake Schema, Multi Dimensional Modeling and Relational Database Modeling.
• Strong experience in Meta Data Management and Data Governance Techniques.
• Proficiency in Data Modeling using ERwin and Power Designer tool for creating Conceptual/Logical and Physical Data Models.
• Well versed with various Informatica transformations and implemented complex mappings.
• Expertise in using Oracle 9i/10g/11g/12i database and PL/SQL programming to develop stored procedures, packages and advanced features like Function Overloading, Dynamic SQL, Query Optimizer, Nested Loops .
• Experience in writing Packages, Stored Procedures, Functions, and Database Triggers using SQL and PL/SQL in oracle.
• Experienced in tuning of complex SQL statements using oracle Hints, Explain plans and Trace Sessions and in partitioning of tables and indexes.
• Strong programming and debugging skills in PL/SQL, SQL, Pro*C, UNIX Shell Scripting, Perl Scripting .
• Development experience with Java, C, C++.
• Excellent Analytical, communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment.
• Ability to quickly learn programming languages and other applications/software and work in fast paced environment.
• Have worked in both development and maintenance projects.

TECHNICAL SKILLS:

Programming Languages: C, C++, JAVA, PL/SQL, TSQL

Scripting Languages: Unix-Shell Scripting, Perl, TCL/TK

Databases: ORACLE 12i/11g/ 0g, MS SQL Server 2000/05, MSAccess

Project Management Tools: Caliber, Rational Unified Process (RUP), MS Project, MS Visio, SDLC, Rally, DOORS, Quality Center

Data warehouse Tools: IDQ Analyst,Informatica, Cognos, Erwin 4.X,7.x

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Sr Business Analyst

Responsibilities:

• Extensively worked on Data Quality(DQ) Solutions for Transaction Management, DUS projects.
• Frequent interaction with the business users to gather, interpret and analyze business requirements
• Organized and participated as a lead in Joint application Development sessions for developing the application and created business requirements document by communicating with end users and developers
• Perform cross functional business analysis from compiling data from multiple database sources and developing medium to complex reports/analysis
• Analyze the requirements from the business users and convert them into functional specifications
• Analyze the extracts coming from different sources to identify the new data elements, map them to the physical elements and update them in the metadata repository
• Based on the functional/technical specification documents, involved in design and creation of logical/ physical data models using Erwin to support the warehouse and the data marts
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Developed Data Flow, Workflow, Process Flow, and Entity Relationship Diagrams in Visio
• Worked as an Interface between the end users and the different teams (Development Team, Testing Team, System Architect Team) involved in the application development for the better understanding of the business and IT processes
• Involved in the data migration, data lineage and also studying the data impact analysis.
• Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment using Informatica Data Quality,BE Studio. Developed working documents to support findings and create data quality rules.
• Understand the data and develop reporting/dashboard requirements
• Developed and generated PL/SQL and SQL queries for ETL processing, reporting and data analysis
• Created Test Case Specification document for UAT and worked as UAT Lead
• Created Requirement/United Traceability Matrix to make sure the project requirements are being met.
• Prepared analytical and status reports and updated the project plan as required.
• Integrated the work tasks with relevant teams for smooth transition from implementation to testing.
• Prepared user training material and release notes.
• Involved in production support and resolve the issues within the defined SLA

Lead Data Analyst

Responsibilities:

• Frequent interaction with the business users to gather, interpret and analyze business requirements and test, certify results, and deploy solutions
• Created business specification documents based on the user requirements gathered from the business users for both design and development
• Performed cross functional business analysis from compiling data from multiple database sources and developing medium to complex reports/analysis
• Worked directly with developers, Project Manager and Business contacts to produce Test Scripts and Test Conditions.
• Established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
• Created Data Flow Diagram for the identified elements and prepared the scope and requirements document.
• Prepared the physical mappings for these elements from source to stage to target in the Operational Data Store
• Researched through the existing code and compiled SQL scripts to provide completeness,consistency and accuracy checks
• Documented the exceptions occurred from the checks and further researched into the code to apply filters
• Provided detailed analysis of data issue, mapping data from source to target, design and data cleansing on Data Warehouse
• Analyzed the extracts coming from different sources to identify the new data elements, map them to the physical elements and update them in the metadata repository
• Worked as a team in conducting Gap Analysis on requirements traceability matrix to identify data anomalies and determined the cause/scope for these anomalies and suggested options for conversion and cleanup of data
• Based on the business requirements, prepared the Data Acquisition and Disposition Design documents for applying business logic in source to target data mapping for the entire Group subject area
• Plan, design, and implement operational data store (ODS), data warehouses and data marts including capacity planning, data modeling, data analysis, schema design, batch and real-time load processes.
• Implemented the data model changes using Erwin for the project.
• Responsible for setting up weekly meeting and walkthrough’s for project updates and to detect bottlenecks and devise a plan to handling the bottlenecks.
• Assigned groups with weekly/monthly tasks needed to ensure completion of project.
• Performed unit test and regression test for Informatica IDQ mappings and workflows in both development and test environments

Environment: Informatica 9.1,Oracle 11i, Toad, MS SQL Server 2000/2005, SQL, PL/SQL, MS Office 2007, MS Visio, Erwin Data Modeler7.2/7.3, UNIX, PL/SQL Developer, Rational Unified Process (RUP), HP Quality Center

Data Analyst

Responsibilities:

• Involved in requirement gathering, functional specifications and also frequent interaction with end users.
• Gathered business requirements from the users and transformed and implemented into database schemas.
• Used ERWIN as the data model tool to design Logical and Physical data, Objects define relationships, implement business rules as constraints for normalization / de-normalization of entities.
• Created Technical specifications documents for the data warehouse design and data mapping from the source to target applying the business rules
• Analysed the extracts coming from different sources to identify the new data elements, map them to the physical elements and update them in the metadata repository
• Prepared the physical mappings for these elements from source to stage to target in the Operational Data Store
• Defined primary and foreign keys to ensure referential integrity between tables.
• Performed DML commands to make changes to the database based on business requirements.
• Created and loaded temporary staging tables for validation and to enhance performance.
• Created and executed SQL scripts to validate, verify and compare the source data to target table data.
• Created complex scripts using sql functions, joins and nested queries.
• Emphasized on Optimization techniques using triggers, indexes and partitions for high volume transactions.
• Organized review sessions with key stakeholders/development group to clarify on Business Requirements / Technical Requirements.
• Utilized Power Designer 15.0 and Erwin 7.2/7.3 for design and development for different contracts/projects.
• Involved /participated in Technical Review Sessions with the Development Team/ Architecture team to go over the Data Designs for various projects
• Conducted data modeling, data analysis and designed Star and Snowflake schema design.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts.
• Worked with various Informatica PowerCenter objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Created and modified Oracle Schema objects like Tables, Indexes.
• Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
• Worked on creating batch programs using Perl and Shell.
• Responsible for production support and mentored developers on issues pertaining to PL/SQL.
• Written korn shell scripts to develop batch pl/sql scripts to be run as Control-M jobs.
• Configuration Management using PVCS. Creation of SMR’s and DCR’s for DBA.

Environment: Informatica 9.1, Oracle 10G/11G, Shell Script, PL/SQL Developer, ERWIN, Toad, PVCS, and CVS

Data Analyst & Oracle Developer

Responsibilities:

• Involved in analysis, design and gathering of requirement for project.
• Involved in gathering requirements and created Architecture/ design documents for the project based on the analysis of the requirements
• Actively involved in design sessions for conforming enterprise data architecture.
• Created standards document for ETL design.
• Created Functional and Technical specifications documents for the data warehouse design and data mapping from the source to target applying the business rules of Facilities and Utilizations
• Designed the physical data models in ERwin based on the logical model identifying the relationships
• Ensured referential integrity within each of the subject areas and conformity across all the subject areas
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Production Support for Service Center Tickets, Code Tickets and Analysis, coding & Testing and Implementation of Project Enhancements.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Involved in Writing Backend Procedures, Functions & Packages in PL/SQL.
• Used Materialized Views for query - rewrite for reporting, and Execute immediate to execute dynamic SQL.
• Used Bulk collect, Forall to process large volume of data.
• Data migration and conversion done utilizing Oracle utilities: SQL Loader, Export/Import.
• Extensively used SQL *Loader to load Data from flat files to Database tables in Oracle.
• Developed pl/sql packages to pass the data to downstream systems for look up against the downstream systems reference tables.
• Involved in performance tuning and optimization.
• Extensively used Joins in Interaction with backend database using PL/SQL.
• Written UNIX shell scripts in K-Shell for automatic notification of status of daily cron jobs.
• Written korn shell scripts to develop batch pl/sql scripts to be run as Control-M jobs.
• Configuration Management using PVCS. Creation of SMR’s and DCR’s for DBA.
• Providing production support as needed offering timely, instantly sound problem resolution.

Environment: Oracle 9i/10G, Shell Script, PL/SQL Developer, Toad, ERWIN, PVCS, and CVS

Oracle Developer

Responsibilities:

• Onsite Co-ordinater
• Migration of RADIS GUI from PowerBuilder 6.5 to 11.0
• Coding in PL/SQL for the backend changes and upgradation from Oracle 9i to 10g
• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Environment setup
• Coding in Proc*C for the backend
• Makefiles to compile *.pc files into object files and executables.
• Shell scripts which execute batch SQL scripts to be set up as jobs in Control-M.
• Shell scripts to load data files into database using ftp commands and SQL-Loader
• Resolved Production tickets .
• Writing shell scripts to execute Proc*C executables
• Deploying the new changes in production

Environment: Oracle 9i, Shell Script, PowerBuilder 6.5, 11.0, Proc*C, PL/SQL Developer, Putty,

Oracle/Java Developer & Onsite Co-coordinator

Responsibilities:

• Understanding the system and create documentation
• Onsite co-coordinator
• Migration of IROSS GUI from PowerBuilder 6.5 to 11.0
• Coding in Java
• Building of the jar files and deploying builds in test environment.
• Write build scripts in ANT
• Environment setup
• Configuring and Creating domain in weblogic server
• Deploy the applications in weblogic 7.1
• Code changes for backend for Upgradation from Oracle 9i to 10g
• Writing PL/SQL code using the technical and functional specifications generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primarykeys, indexes, constraints, packages, sequences, grants and synonyms.
• Unit Testing of the application
• Reviewing of the code changes done by offshore team.

Environment: Oracle 9i, Java, J2EE, Shell Script, Weblogic 7.1, PowerBuilder 6.5, 11.0, PL/SQLDeveloper, Eclipse, Ant

Oracle Developer

Responsibilities:

• Involved in extracting, discussing, and refining business requirements from users and team members.
• Implementation of the requirement.
• Designed database tables, Relationships and Views.
• Loaded data into main staging table and lookup tables through set of INSERT statements.
• Worked on PL/SQL Packages, Procedures, Objects, VARRAYS, Functions, and REF Cursors.
• Extraction of the CDR from SIP server to MIS Server using Shell programming
• UNIX Shell scripts and commands for file management, job automation and administration tasks.
• Loading of the data into tables from the MIS server using SQL Loader
• Coding in PL/SQL using Packages, Stored Procedures
• Generation of Reports at MIS website based on date input from the summary tables
• Design, Develop, Customized various Reports using PL/SQL and SQL.
• Generating web based reports using Java scripts.

Environment: Windows NT, Oracle 9i PL/SQL, JSP, Shell Script, SQL Loader, PL/SQL Developer

C/C++ Developer

Responsibilities:

• Involved in implementation and coding of real BSC changes of P12 project into SEA-BSC, BT and CLE along with the client.
• Implementation of the P13 project of real BSC and BTS changes in SEA-CLE.
• Written new BSC components RHTRHR, RHLAPD using C++ and COM.
• Device Simulation using C and C++.
• Written a new interface to access the above components using C++.
• Trained people in the team at the functional and technical level in CLE.
• Prepared networks to launch the CLE setup in SEA.
• Responsible for writing test specs and testing at functional level.
• Made modifications in the GUI of SEA tool to support CLE functionality using TCL/TK.
• Written setup files using shell script and UNIX environmental variables
• Responsible for providing support and maintenance of CLE
• Implementing of future changes in real BSC in SEA & CLE.

Environment: Solaris 9.0, C/C++, Tcl/Tk, COM, Rational Clear Quest, ClearCase, C++, Tcl/Tk,Core GSM: L1 & L2 protocols,OML & RSL, 3GPP standards

C,C++ Developer

Responsibilities:

• Understanding the existing System Functionality.
• Requirements gathering and Documentation .
• Feasibility Check and application.
• Prepared the Impact analysis documents .
• Provided the effort estimation.
• Implementation and coding of the requirement.
• Responsible for opening, answering, solving and closing of the time critical Trouble Reports raised by Ericsson and its partners in the web tool Rational Clear Quest.
• Responsible for building and releasing Maintenance releases and Service Packs of SEA.
• Debugged the code efficiently using the debugging tools like GDB, DDD, Forte Workshop,
• Used tools Rational Purify, Purecov to detect memory leaks in the code and fix them.
• Involved in answering the queries of various Ericsson users in any part of SEA.
• Increased the quality and performance of the components and legacy issues by finding the actual root cause of the problem.
• Coding in C. C++, TCL/TK.
• Solved system test bugs.
• Responsible for identifying the defects and changes needed to refine the tool.
• Worked with the various tools used by the Ericsson Testers like STNTools, MGTS, BSS tools like TSS
• Used pipes and filehandles to pass the data from the GUI and to read the data from the Core CP part of the Tool.
• Developed interfaces (*.idl files) using COM Query Interface and library functions and C++ to interact with a component.
• Written MakeFiles to compile the source code
• Written shell scripts to deploy the application,
• Prepared the test cases.
• Involved in fixing the bugs during testing phase.
• Conducted Team Meeting to gather the status of TRs from Team Members .
• Analyze the technical solution proposed for a TR by the team member.
• Helped the team members to solve their TRs so that TR timeline is not crossed.
• Responsible for Code Review activities of other designer features in STE.
• Code owner for some components written in C++, Tcl/TK
• Internal reviewer of IP, RS, Code in the project.
• Involved in complete like cycle of the project
• A faculty in the Training committee of the project.
• Conducted many KSS over a range of topics to build competency in the team.
• Mentor for new members in the team.

Environment: Solaris 9.0, C/C++, Tcl/Tk, Plex-C, ASA, Shell programming, Socket Programming Rational Clear Quest, ClearCase, GDB, WorkShop