SUMMARY

• Over 14 years of experience in the field of Information Technology with emphasis on Solutions Architecture, Data architecture, Project Development, Business Requirements and System Analysis, Architecture and Operations Support projects of enterprise N - tier web and windows applications.
• Involve in the design, modeling, building, integrating, administering, and tuning of quality and secure applications, databases, and information technology solutions for changing enterprises.
• Industry experience as Solutions Architect/Data Architect/Database Architect as well as Project Manager in diverse domains such as Retail, Service (Product Development), Transportation (Terminal/Port Operation/Shipping), Banking Payroll and Automobile domains.
• Facilitate Architecture Design, Database Design, Data Management (Organizing/Designing/Manipulating/Reporting), interact with Performance Engineering, Application Integration, Project Conceptualization, and Software Development & Implementation Management in diverse business & technical environments.
• Provided Assessments, Strategy, Timelines, Roadmaps, Resource and Cost Estimates, Best Practice and processes for Data Quality, Master Data Management and Data Warehouses
• Interface with business users from Operations, Finance, Marketing, Business, Other Application Teams and Outside Vendors.
• Proficient in Database Performance Tuning, Database upgrades and migrations from one DB to another.
• Experience in designing Data Models (Logical and Physical design), creating Entity Relationship Diagrams.
• Proficient in Technical and Business Writing, Business Process Flow, Client Meetings and Communication, Business Process Modeling, Business Analysis, preparing Work Breakdown Structure (WBS) and testing various methodologies.
• Determine Customers Business Requirements and establish a strategy/road map for DW/BI solutions to meet Customer needs.
• Proficiency in Data warehousing concepts and designs, as well as in OLTP.
• Experienced in working in Agile Methodology mode as well as Waterfall Methodology.
• Successful management of simultaneous handling of multiple projects from defining requirements through implementation.
• Proven track record of delivering projects on time and within budget, sound ability to conduct and interpret qualitative and quantitative analyses.
• Successful management and motivation of cross functional teams ranging from 5 to 35, handling projects having budgets > $500000.
• Excellent Leader and player having work in conjunction with analysts, developers and team members in validation and testing complex projects and in the maintenance of Quality Standards in Projects.
• Experience working with the on-shore/off-shore models.
• Successful management of multiple projects from defining requirements through implementation.
• Proven track record of delivering projects on time and within budget.
• Sound ability to conduct and interpret qualitative and quantitative analyses.
• Comprehensive understanding of RCA, statistics and quality improvement techniques.
• Successful management and motivation of cross functional teams ranging from 5 to 35, handling projects having budgets > $100000.
• A solid reputation as a hard working, innovative and results-driven professional.
• In addition to my project-management skills, take care of team members and motivate them, fine-tuning project plans, and organizing multiple activities.
• Scrutinize business needs, analyze requirements as well as conceptualize innovative solutions.

TECHNICAL SKILLS

Databases: PDW, Oracle, SQL Server, Seaquest

Project Mgmt: Project Management, Solutions Architect, Technical Documentation, Functional Specifications Documentation, Quality Assurance, Primavera P6

Languages: PL/SQL, SQL, Shell scripting, Perl Scripting C, XML, HTML, C#

Technologies: ASP.NET, C#.NET, VB.NET, ADO.NET, LINQ, Web Services, WCF, WWF, WPF, Silverlight, Oracle Forms, Webfocus, Data warehousing process, Data Mart

IDE Tools: MS Visual Studio Team System (2008/2005/2003 ), MS Expression Blend, MS-Project

BI & Reporting tools: Qlikview, Yotta, C#, Holos, Oracle Forms, Web Focus, Crystal Reports

Operating Systems: Windows server 2003, XP, Vista 2000, 98, 95, Unix, DOS, Linux

Modeling: Power Designer, Embarcadero ER Studio, CA ERWIN, MS Visio Enterprise Architects, Information Builders Developer Studio 76

Standards/Methodologies: CMMI, TDD, AGILE, SCRUM, Waterfall

Version Control: Clear Case, SCCS

Data: Solutions Architect, Data Architect, Analysis, Modeling, Mapping, Migration, Masking, Toad, SQL Navigator, Integration, Quality, Security, SQL-Loader, ETL Process, Informatica, SSIS

Testing tools: ALM, HP Quality Center, Remedy, MS Office Suite, MS Visio, Clear case

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Solutions Architect

Responsibilities:

• Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications.
• Understand the Model and the design of OMS and RMS, the relations being created for each entity.
• Provide expertise to translate the systems requirements into software design documentation.
• Plan, design and shape the new order management system in PDW using technologies (SSIS/SSAS/ SSRS/Performance Point/Power View/Power Designer/Oracle/Teradata/Apptalk/PDW) for RASC.
• Communicate with OMS to discuss the ETL process, the table definitions and the queries to be used for the extract process.
• Understand the Apptalk process and the design to load the data in NAS drive.
• Interact with Enterprise Architect to explain the data topics, high level design and the approach for the new warehouse.
• Govern the development of the formalized solution to integrate it with the new indigenous reporting and database tools.
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Design, develop and monitor the logical / physical data marts, data base objects (like fact tables, dimensions, packages, tables etc.), also guide then and help in developing the BI reports for business users.
• Understand the current process/system, identify the changes required to be done to integrate the new system with the current process/system in order to identify the artifacts, plan and design the changes of current system.
• Guide and perform data modeling (logical, physical), data analysis via SQLs, data cleansing and implement data quality procedures.
• Design and present various dashboards (BI reporting), ad-hoc reports, KPI Metrics, trending reports, historical reports with slice/dice across various categories, etc. in order to substantiate the idea of new generation reporting platform to the business users and key decision makers.

Environment: PDW, Tabular, MOLAP, Performance Point, SSIS/SSAS/SSRS, Power Designer, SQL Server 2012, SharePoint, NAS, Microsoft Office Suite.

Confidential, Houston, TX

Solutions Architect

Responsibilities:

• Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications.
• Understand the Model and the design for MDM, the relations being created for each entity.
• Provide expertise to translate the systems requirements into software design documentation.
• Plan, design and shape the new product master using technologies (SeaQuest/Erwin/Informatica/SQL Server/Oracle/QlikView/Informix) for the Enterprise Data Warehouse (EDW) and Business Data Repository (BDR).
• Communicate with MDM to discuss the ETL process, the table definitions and the queries to be used for the extract process.
• Understand the SAP NGOM process and the design for Product Master and Contract flow.
• Interact with SAP (NGOM) system to understand the Sales Order being created and how the data can be extracted from SAP through ETL process, tables impacted and the queries to be modified for the extract process.
• Govern the development of the formalized solution to integrate it with the existing indigenous reporting and database tools.
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Design, develop and monitor the logical / physical data marts, data base objects (like fact tables, dimensions, packages, tables etc.), also guide then and help in developing the BI reports for business users.
• Understand the current process/system, identify the changes required to be done to integrate the new system with the current process/system in order to identify the artifacts, plan and design the changes of current system.
• Guide and perform data modeling (logical, physical), data analysis via SQLs, data cleansing and implement data quality procedures.
• Design and present various dashboards (BI reporting), ad-hoc reports, KPI Metrics, trending reports, historical reports with slice/dice across various categories, etc. in order to substantiate the idea of new generation reporting platform to the business users and key decision makers.

Environment: NeoView, SeaQuest, Qlikview, Informatica, SQL Server 2008, SSIS/SSAS/SSRS, SharePoint, Dial, Tidal, Microsoft Office Suite, ERWIN.

Confidential, Scottsdale, AZ

Solutions Architect

Responsibilities:

• Interact with Business users and project stakeholders and translate the requirements into functional and technical specifications.
• Identify and segregate the entities as critical, medium and simple.
• Provide expertise to translate the systems requirements into software design documentation, provide strategy, best practice and process for establishment through HLD and DLD details.
• Solutions architecture to enable data error handling end to end. Enable data reconciliation for conversion of data from legacy to TMS.
• Design and guide the development team for the new system using technologies (Oracle/Erwin/Unix/Shell Scripting/C++(WPF)/Crystal Reports) for the Confidential (TMS).
• Govern the development of the formalized solution to integrate it with the existing indigenous reporting and database tools.
• Determined application inventory and priority of data to be profiled and loaded into the database.
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Understand the current process/system, identify the changes required to be done to integrate the new system with the current process/system in order to identify the artifacts, plan and design the changes of current system.
• Conduct meetings with the performance team explaining the new architecture and the benefits of the new process over the current system.
• Guide the team members for Data Analysis, Mapping, Migration, Masking to new from existing system.
• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Coordinate data cleansing and ETL activities and ensure that the spatial feature data subject data models correctly reflect the data migration and synchronization ETL mappings to legacy data sources and data quality and data governance requirements.
• Design, develop and monitor the logical / physical data marts data modeling, data base objects (like fact tables, dimensions, packages, tables etc.)
• Guide the team to develop the code (PL/SQL queries, ETL process, Data Modeling) based on the design.
• Define Tables, Views, Sequences, Create the PL/SQL Packages, Procedures, Functions, Triggers, Tables and views as well as the queries in developing the BI reports for business users.
• Guide and perform data analysis via SQLs, data cleansing and implement data quality procedures.
• Design and present various dashboards (BI reporting), ad-hoc reports, KPI Metrics, trending reports, historical reports with slice/dice across various categories.

Environment: PL/SQL-Packages, Procedures, Functions, Triggers, Views, Sequences (Oracle 8i/11g), Shell Script, Toad, SQL Navigator, Win NT workstation and Windows NT server, .Net Framework (C# 3.5), Scrum, Agile, Windows Presentation Foundation (WPF), Informatica, Microsoft Office Suite, ERWIN.

Confidential, Scottsdale, AZ

Solutions Architect

Responsibilities:

• Discuss with the business and the SME about the project requirements to identify the critical business rules, functionality requirements.
• Design and Develop the AIFF format for the processes to be developed (301, 310, 404, 315, 322) to be transmitted to EDI, capturing all data based on business rules, define their position for processing.
• Host requirement JAD sessions and on Product issues.
• Develop the logical database design through ER studio, discuss the design with the performance engineering team explaining the database structure
• Provided tool recommendations for ETL and AIFF process.
• Discussed the scalability of transactions with the DBA’s for the new process and integrate the new process with the current processes.
• Worked on tool recommendations for model, database, ETL process, logical and physical data model design.
• Define the workflow for the process.
• Develop, test and integrate the solution based on the workflow definition.
• Guide the team to develop the code based on the design and help them in performance tuning, process improvement.
• Define Tables, Views, Sequences, Create the PL/SQL Packages, Procedures, Functions, Triggers, Tables and views in stage environment.
• Perform Data Masking for critical modules, data cleansing from source and integrate it in accordance to data governance requirements..
• Performance verification of each stored database elements using EXPLAIN PLAN and running the trace for the scripts.
• Create the unix shell scripts and run script through cron process.
• Seamlessly merging application across UNIX and windows based systems.
• Prepared UAT documents, code review, integration testing.
• Create the script for the physical database (tables, procedures, views, packages), explained the details to oracle DBA team to be implemented in production.
• Implementation, post implementation support, transition to support team.

Environment: PL/SQL-Packages, Procedures, Functions, Triggers, Views, Sequences (Oracle 11g), Shell Script, Toad, SQL Navigator, Win NT workstation and Windows NT server, Agile, Microsoft Office Suite, ERWIN.

Confidential, San Pedro, CA

Solutions Architect

Responsibilities:

• Prepare Technical Solution document.
• Generate Business Process Model using MS Visio for the new system.
• Provide the oracle DBA the DDL’s from the physical data model and relational and materialized views.
• Conducted benchmarks on OLTP databases to verify design.
• Tuned SQL queries in application environments.
• Developed database table partitioning scheme using discrete statistical data mining and query analysis.
• Determined Platform, Modeling, ETL tools to be used.
• Performed scalability analysis for the new processes to be developed.
• Led the analysis of Current State Architect, ETL process.
• Worked on tool recommendations for data model, database, ETL process.
• Coordinate data cleansing and ETL activities and ensure that the spatial feature data subject data models correctly reflect the data migration and synchronization ETL mappings to legacy data sources and data quality requirements. Validate and verified (IV&V) legacy data sources.
• Create critical PL/SQL Procedures, Packages and functions, Analysis, Mapping, Migration, Masking for the new functionalities, and create new triggers on the tables call the procedures through this trigger. Design and develop new oracle database tables for the process, create UNIX shell scripts, test the forms, integrate after successful testing and send to QA for final testing and approval.
• Coordinate with team and guide them with their issues
• Plan and Inform business about the implementation, run scripts to move the files/programs to production.
• Understand the current process/system, modify the process to integrate the new system with the current process/system in order to identify the artifacts, plan and design the changes of current system.
• Avoid back-outs and seamlessly automate the process without hampering business.
• Transition to support team.

Environment: PL/SQL (Oracle 8i/11g), Shell Script, Win NT workstation and Windows NT server, Toad, SQL Navigator, .Net Framework (C# 3.5- Winform), Clearcase, Mainframe process, Agile,, Informatica, ERWIN.

Confidential, Scottsdale, AZ

Solutions Architect

Responsibilities:

• Analysis of Current State Architect
• Analysis of performance on ETL load process and work flow
• Prepare the Technical Approach Solution (TAS) for the new process.
• Review stored procedure process vs ETL capabilities for the new functionality.
• Design and develop the new process in oracle (create new Package) and do changes in C program and make the exe file to be run from the shell script, test the changes in a phased manner.
• Recommended changes to process flow and scheduling.
• Perform UAT with the business users and get their sign off.
• Seamlessly merge the new process into the existing process.

Environment: PL/SQL (Oracle 8i/11g), Toad, SQL Navigator, Shell Script, MQ process, Proc C.

Confidential, Scottsdale AZ/San Pedro, CA

Solutions Architect

Responsibilities:

• Analyze the business requirement based on Business Requirement Document (BRD) and then prepare the functional specification document (FSD) based on the BRD document.
• Understand the complete flow of project, applications involved, their roles and how the data will be transmitted through all applications.
• Design the layout as per the understanding and requirements, develop the code based on design specifications.
• Prepare UAT documents, create PL/SQL Procedures, Packages and functions for the new functionalities, and create new triggers on the tables call the procedures through this trigger. Design and develop new oracle database tables for the process, create UNIX shell scripts, test the forms.
• Coordinate with EDI team for the data flow to cyclone through Mercator.
• Prepare the workflow for the whole process and integrate the various activities for the solution.
• Integrate with other application and inform business for their testing (UAT) and approval.
• Implement the changes along with other applications so that all are in sync with each other and be ready for post production support for any issues. This helps in quick resolution, to resolve any unknown issues which might have been overlooked during UAT.
• Perform GAP analysis of business rules, business and system process flows, user administration, and requirements.
• Provided strategic support in development of detailed project plans, work assignments, target dates etc.
• Identified the business risks associated with the new system and formulated a Mitigation Plan to reduce the effect of critical risk factors.

Environment: PL/SQL (Oracle 8i), Toad, SQL Navigator, Win NT workstation and Windows NT server, EDI (Mercator),, Informatica, Test Director, ERWIN.

Confidential, Scottsdale, AZ

Solutions Architect

Responsibilities:

• Analyze the business requirement based on Business Requirement Document (BRD) and then prepare the functional specification document (FSD) based on the BRD document.
• Discuss the issues/modifications to be done, optimal solution with business. prepare UAT document and the roadplan for the project.
• Create PL/SQL Procedures, Packages and functions for the new requirement.
• Modify Proc C code to add new elements for the process compile the file.
• Test and Integrate the process, send to QA for final testing and approval.
• Inform business about the implementation, run scripts to move the files/programs to production.
• Post production support for any issues.

Environment: PL/SQL (Oracle 8i), Shell Script, Proc C, Agile, MS Visio, ERWIN.

Confidential, Scottsdale, AZ/San Pedro, CA

Solutions Architect/Data Architect

Responsibilities:

• Analyze the business requirements and prepare FSD document to identify the critical, medium and simple activities and entity relationship for each process.
• Prepare the project plan based on the approved solution from performance engineering team.
• Design the new system based on the FSD to minimize the maintenance cost and improve functionality.
• Help the business to articulate and prioritize their ideas, while using the Rational Unified Process (RUP) and coordinating in writing UML-based feasibility studies and Use Case Models to communicate those ideas to the developers.
• Perform testing, update test results.
• Plan and integrate after successful testing and send to QA for final testing.

Environment: PL/SQL (Oracle 8i), Toad, SQL Navigator, Shell Script, HTML, MS Office, RUP, UML, OOAD, MS Project, MS-Visio.

Confidential, Scottsdale AZ/Denver, CO

Data Architect

Responsibilities:

• Understand and analyze the business requirements and document the current flow.
• Design the scope of the project to integrate the requirements within current process based on the facts present and available, helps identify KPI and avoid redundant processes.
• Develop the new process by creating oracle PL/SQL procedures and Oracle UTIL process and test the new process based on the test cases.
• Implement in production and monitor the effectiveness, helped to improve the productivity/efficiency of the vessels by 140%.

Environment: PL/SQL (Oracle10g), Toad, SQL Navigator, Shell Script, Power Builder 8.0.

Confidential, Scottsdale, AZ

Data Architect

Responsibilities:

• Analyze the business requirements and prepare the functional specification document.
• Prepare detail design document and Technical approach document.
• Develop the new process as per the design document and prepare the test plan and update test results based on the test cases.
• Implement in production and post production support.
• Transition to maintenance and support team.

Environment: PL/SQL (Oracle 10g), Toad, SQL Navigator,, Informatica, Cyclone.

Confidential, Scottsdale, AZ

Data Architect

Responsibilities:

• Understand and analyze the business requirements and do a feasibility study.
• Understand the current process, design the new process based on the facts present and available, helps identify KPI and the loop holes in the system.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives.
• Develop the new process by creating PL/SQL Procedures, functions, Oracle UTIL process for the new functionality. Design and develop UNIX shell script to run the new process and test the new process based on the test cases.
• Implement in production and monitor the effectiveness to improve the productivity/efficiency of the vessels by 80%.

Environment: PL/SQL (Oracle 10g), Toad, SQL Navigator, Shell Script.

Confidential, Oakland CA

Project Manager

Responsibilities:

• Study, Analyze and document the existing forms/reports.
• This helps in understanding the current architecture, business of the form which in turn helps in designing the new process properly.
• Prepare Technical Solution Proposal (TSP) and Proposed Migration Approach for project, helps in designing the new architecture in an efficient way and understand the advantages/disadvantages of various approaches.
• Prepare of Project Approval Paper (PAP) for project and discussion with business, client managers about the dynamics of the project.
• Plan for resource management and work allocation across various modules for the resources, this helped in reducing the re-work cost. Help to reduce dependency on Holos tool as it is no longer supported.
• Design and develop the system using oracle PL/SQL Procedures, Packages and functions for the new process, create new global temporary tables, add triggers on the existing tables call the procedures through these triggers. Develop the forms using Web Focus reporting tool, perform unit test and then integration test in stage environment, the new tool/application reduced processing time by 100%.
• Implement and support post production.
• Improved the productivity of the process by 60%.

Environment: PL/SQL (Oracle 10g), Shell Script, Toad, SQL Navigator, Win NT workstation and Windows NT server, Web Focus Framework, UML, Agile, MS Excel,, Informatica, CA ERWIN.

Confidential

Project Lead

Responsibilities:

• Project lead and onsite contact point for all applications.
• Work onsite to understand the as-is processes, identify gaps & provide to-be process solutions.
• Handle multiple projects for Holos reports simultaneously.
• Communicate and liaise clearly with business partners located both locally and globally.
• Business Requirements gathering and documentation.
• Preparation of FSD/TSP documents for projects.
• Develop new forms using the data warehouse concepts(preparation of cube, hash structure, taking care of facts and deriavatives).
• Perform Data Mining for the issues raised by the business users,
• Preparing plan for allocation of work, assignments to resources as required.
• Preparing and reviewing estimates for the enhancements/mini projects.
• Preparing weekly status reports.
• Application support for all the OLAP/BI reporting and DW (Data Warehousing) applications.
• Milestone submissions and preparing weekly, monthly/quarterly status report.
• End user support and clarifications.

Environment: Oracle 8i/10g (Unix Server), Data warehousing tool Holos 7.0C BI Reporting tool, Toad, SQL Navigator, Data Mart, Win NT workstation and Windows NT server, CA ERWIN.

Confidential

Team Leader

Responsibilities:

• Team Lead and a key member in developing, launching and enhancing a customized ERP process for Confidential Private Limited.
• Developed the forms (GUI) for the exports module, PPC module and sales module.
• Successfully completed the coding, testing which helped in integrating with other modules (Manufacturing, Purchase) modules of IIS.
• Created important interfaces like quotation, pro forma invoice, goods receipt note (GRN), raising quotation, material issue note, preparing packing list, sales invoice for sales and exports.
• The whole system was developed using PL/SQL Procedures, functions, using UTIL files for the new functionalities. Design and develop new oracle database tables for the process, create UNIX shell scripts

Environment: PL/SQL (Oracle 8i), C, C ++, Toad, SQL Navigator, Shell Script, Oracle Forms 6i, Oracle Reports 6i.