SUMMARY

• Over 13 years of experience in teh field of Information Technology with emphasis on Project Development, Business Requirements and System Analysis, Architecture and Operations Support projects of enterprise N - tier web and windows applications.
• Involve in teh 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/Database Architect as well as Project Manager in diverse domains such as Service Sector (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, 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.
• Detail-oriented Solution Architect, Data Architect, Project Manager/Planner and Analyst devising innovative and tailored solutions to meet ever changing business requirements.
• 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 25, handling projects having budgets > $100000.
• Excellent Leader and player having work in conjunction with analysts, developers and team members in validation and testing complex projects and in teh maintenance of Quality Standards in Projects.
• Experience working with teh on-shore/off-shore models.

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, MN

Solutions Architect

Responsibilities:

• Interact with Business users and project stakeholders and translate teh requirements into functional and tan technical specifications.
• Understand teh Model and teh design of OMS and RMS, teh relations being created for each entity.
• Provide expertise to translate teh systems requirements into software design documentation.
• Plan, design and shape teh 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 teh ETL process, teh table definitions and teh queries to be used for teh extract process.
• Understand teh Apptalk process and teh design to load teh data in NAS drive.
• Interact with Enterprise Architect to explain teh data topics, high level design and teh approach for teh new warehouse.
• Govern teh development of teh formalized solution to integrate it with teh 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 teh team members. Train new resources on business as well as tools and technologies.
• Design, develop and monitor teh logical / physical data marts, data base objects (like fact tables, dimensions, packages, tables etc.), also guide tan and help in developing teh BI reports for business users.
• Understand teh current process/system, identify teh changes required to be done to integrate teh new system with teh current process/system in order to identify teh artifacts, plan and design teh 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 teh idea of new generation reporting platform to teh 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 teh requirements into functional and tan technical specifications.
• Understand teh Model and teh design for MDM, teh relations being created for each entity.
• Provide expertise to translate teh systems requirements into software design documentation.
• Plan, design and shape teh new product master using technologies (SeaQuest/Erwin/Informatica/SQL Server/Oracle/QlikView/Informix) for teh Enterprise Data Warehouse (EDW) and Business Data Repository (BDR).
• Communicate with MDM to discuss teh ETL process, teh table definitions and teh queries to be used for teh extract process.
• Understand teh SAP NGOM process and teh design for Product Master and Contract flow.
• Interact with SAP (NGOM) system to understand teh Sales Order being created and how teh data can be extracted from SAP through ETL process, tables impacted and teh queries to be modified for teh extract process.
• Govern teh development of teh formalized solution to integrate it with teh 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 teh team members. Train new resources on business as well as tools and technologies.
• Design, develop and monitor teh logical / physical data marts, data base objects (like fact tables, dimensions, packages, tables etc.), also guide tan and help in developing teh BI reports for business users.
• Understand teh current process/system, identify teh changes required to be done to integrate teh new system with teh current process/system in order to identify teh artifacts, plan and design teh 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 teh idea of new generation reporting platform to teh 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 teh requirements into functional and technical specifications.
• Identify and segregate teh entities as critical, medium and simple.
• Provide expertise to translate teh 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 teh development team for teh new system using technologies (Oracle/Erwin/Unix/Shell Scripting/C++(WPF)/Crystal Reports) for teh Confidential (TMS).
• Govern teh development of teh formalized solution to integrate it with teh existing indigenous reporting and database tools.
• Determined application inventory and priority of data to be profiled and loaded into teh database.
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Understand teh current process/system, identify teh changes required to be done to integrate teh new system with teh current process/system in order to identify teh artifacts, plan and design teh changes of current system.
• Conduct meetings with teh performance team explaining teh new architecture and teh benefits of teh new process over teh current system.
• Guide teh team members for Data Analysis, Mapping, Migration, Masking to new from existing system.
• Help out on functional and technical issues to teh team members. Train new resources on business as well as tools and technologies.
• Coordinate data cleansing and ETL activities and ensure dat teh spatial feature data subject data models correctly reflect teh data migration and synchronization ETL mappings to legacy data sources and data quality and data governance requirements.
• Design, develop and monitor teh logical / physical data marts data modeling, data base objects (like fact tables, dimensions, packages, tables etc.)
• Guide teh team to develop teh code (PL/SQL queries, ETL process, Data Modeling) based on teh design.
• Define Tables, Views, Sequences, Create teh PL/SQL Packages, Procedures, Functions, Triggers, Tables and views as well as teh queries in developing teh 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 teh business and teh SME about teh project requirements to identify teh critical business rules, functionality requirements.
• Design and Develop teh AIFF format for teh 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 teh logical database design through ER studio, discuss teh design with teh performance engineering team explaining teh database structure
• Provided tool recommendations for ETL and AIFF process.
• Discussed teh scalability of transactions with teh DBA’s for teh new process and integrate teh new process with teh current processes.
• Worked on tool recommendations for model, database, ETL process, logical and physical data model design.
• Define teh workflow for teh process.
• Develop, test and integrate teh solution based on teh workflow definition.
• Guide teh team to develop teh code based on teh design and help them in performance tuning, process improvement.
• Define Tables, Views, Sequences, Create teh 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 teh trace for teh scripts.
• Create teh 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 teh script for teh physical database (tables, procedures, views, packages), explained teh 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 teh new system.
• Provide teh oracle DBA teh DDL’s from teh 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 teh new processes to be developed.
• Led teh 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 dat teh spatial feature data subject data models correctly reflect teh 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 teh new functionalities, and create new triggers on teh tables call teh procedures through dis trigger. Design and develop new oracle database tables for teh process, create UNIX shell scripts, test teh 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 teh implementation, run scripts to move teh files/programs to production.
• Understand teh current process/system, modify teh process to integrate teh new system with teh current process/system in order to identify teh artifacts, plan and design teh changes of current system.
• Avoid back-outs and seamlessly automate teh 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 teh Technical Approach Solution (TAS) for teh new process.
• Review stored procedure process vs ETL capabilities for teh new functionality.
• Design and develop teh new process in oracle (create new Package) and do changes in C program and make teh exe file to be run from teh shell script, test teh changes in a phased manner.
• Recommended changes to process flow and scheduling.
• Perform UAT with teh business users and get their sign off.
• Seamlessly merge teh new process into teh 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 teh business requirement based on Business Requirement Document (BRD) and tan prepare teh functional specification document (FSD) based on teh BRD document.
• Understand teh complete flow of project, applications involved, their roles and how teh data will be transmitted through all applications.
• Design teh layout as per teh understanding and requirements, develop teh code based on design specifications.
• Prepare UAT documents, create PL/SQL Procedures, Packages and functions for teh new functionalities, and create new triggers on teh tables call teh procedures through dis trigger. Design and develop new oracle database tables for teh process, create UNIX shell scripts, test teh forms.
• Coordinate with EDI team for teh data flow to cyclone through Mercator.
• Prepare teh workflow for teh whole process and integrate teh various activities for teh solution.
• Integrate with other application and inform business for their testing (UAT) and approval.
• Implement teh changes along with other applications so dat all are in sync with each other and be ready for post production support for any issues. dis 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 teh business risks associated with teh new system and formulated a Mitigation Plan to reduce teh TEMPeffect 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 teh business requirement based on Business Requirement Document (BRD) and tan prepare teh functional specification document (FSD) based on teh BRD document.
• Discuss teh issues/modifications to be done, optimal solution with business. prepare UAT document and teh roadplan for teh project.
• Create PL/SQL Procedures, Packages and functions for teh new requirement.
• Modify Proc C code to add new elements for teh process compile teh file.
• Test and Integrate teh process, send to QA for final testing and approval.
• Inform business about teh implementation, run scripts to move teh 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 teh business requirements and prepare FSD document to identify teh critical, medium and simple activities and entity relationship for each process.
• Prepare teh project plan based on teh approved solution from performance engineering team.
• Design teh new system based on teh FSD to minimize teh maintenance cost and improve functionality.
• Help teh business to articulate and prioritize their ideas, while using teh Rational Unified Process (RUP) and coordinating in writing UML-based feasibility studies and Use Case Models to communicate those ideas to teh 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 teh business requirements and document teh current flow.
• Design teh scope of teh project to integrate teh requirements within current process based on teh facts present and available, helps identify KPI and avoid redundant processes.
• Develop teh new process by creating oracle PL/SQL procedures and Oracle UTIL process and test teh new process based on teh test cases.
• Implement in production and monitor teh TEMPeffectiveness, helped to improve teh productivity/efficiency of teh vessels by 140%.

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

Confidential, Scottsdale, AZ

Data Architect

Responsibilities:

• Analyze teh business requirements and prepare teh functional specification document.
• Prepare detail design document and Technical approach document.
• Develop teh new process as per teh design document and prepare teh test plan and update test results based on teh 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 teh business requirements and do a feasibility study.
• Understand teh current process, design teh new process based on teh facts present and available, helps identify KPI and teh loop holes in teh system.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives.
• Develop teh new process by creating PL/SQL Procedures, functions, Oracle UTIL process for teh new functionality. Design and develop UNIX shell script to run teh new process and test teh new process based on teh test cases.
• Implement in production and monitor teh TEMPeffectiveness to improve teh productivity/efficiency of teh vessels by 80%.

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

Confidential, Oakland CA

Project Manager

Responsibilities:

• Study, Analyze and document teh existing forms/reports.
• dis helps in understanding teh current architecture, business of teh form which in turn helps in designing teh new process properly.
• Prepare Technical Solution Proposal (TSP) and Proposed Migration Approach for project, helps in designing teh new architecture in an efficient way and understand teh advantages/disadvantages of various approaches.
• Prepare of Project Approval Paper (PAP) for project and discussion with business, client managers about teh dynamics of teh project.
• Plan for resource management and work allocation across various modules for teh resources, dis helped in reducing teh re-work cost. Help to reduce dependency on Holos tool as it is no longer supported.
• Design and develop teh system using oracle PL/SQL Procedures, Packages and functions for teh new process, create new global temporary tables, add triggers on teh existing tables call teh procedures through these triggers. Develop teh forms using Web Focus reporting tool, perform unit test and tan integration test in stage environment, teh new tool/application reduced processing time by 100%.
• Implement and support post production.
• Improved teh productivity of teh 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 teh 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 teh data warehouse concepts(preparation of cube, hash structure, taking care of facts and deriavatives).
• Perform Data Mining for teh issues raised by teh business users,
• Preparing plan for allocation of work, assignments to resources as required.
• Preparing and reviewing estimates for teh enhancements/mini projects.
• Preparing weekly status reports.
• Application support for all teh 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 teh forms (GUI) for teh exports module, PPC module and sales module.
• Successfully completed teh 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.
• Teh whole system was developed using PL/SQL Procedures, functions, using UTIL files for teh new functionalities. Design and develop new oracle database tables for teh process, create UNIX shell scripts

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