SUMMARY

• Over 12 years of IT industry experience encompassing a wide range of skill sets, roles and industry verticals working primarily as a Senior Data Architect with strong technical project management skills.
• Driven technical profession with exceptional leadership and project management skills.Proven ability to effectively plan, coordinate and meet deadline of multiple projects. Goal orientated, customer focused, and tenacious; commited to executing first - class solutions on time and under budget. Demostrated success in stream lining existing operation and upgrading equipment. Team player with demonstrated ability to work well with others to achieve a common goal.
• Skilled in designing, planning and directing projects using current industry approaches, including concurrent engineering, Total Quality management and benchmarking.Organised and able to effectively reengineer policies and procedures following Project Management methodologies, advanced knowledge of program evaluation review techniques (PERT) and critical path method (CPM), grant charts, task development techniquesand project management techniques
• Mentored staff in methodology and consulting excellence and encouraged best practice in project management and project planning.
• Managed and perform the process of Statement of Work and contract creation to secure new and follow-on work.
• Proactively managed systems development, implementation and risk via the use of SDLC.
• 12 years of experience defining, developing, documenting and using enterprise data architecture best practices to standardize and optimize the use of data and data models.
• Pursuing PMP Certification for certified Project Manager.
• Worked with the Client Partners/ Directors for creating POC / Prototype and was extensively involved with SalesTeam for bringing business to company.
• Conducted WATSON SuperComputer event in 2011 at Wayne State University, Detroit.
• As an Confidential University member, visited many Colleges / University in India and United States for showcasing Confidential database products and creating business for Confidential .
• Participated in proposal development for databases for different bidding projects.
• Over five years of experience making strategy recommendations for data modeling that ensures data integrity and optimization.
• Extensive experience of on all Software Development Life Cycle (SDLC) with data and requirement analysis, design, development, testing and implementation of software applications including in-house enterprise resource planning applications.
• Expert in agile and waterfall project management methodologies. Able to manage large project teams and known for high-quality deliverables that meet or exceed timeline and budgetary targets
• Technical experience as a Data Architect, Build and Deployment Administrator, DB2 Database Administrator, Migration Team Lead cum Data Architect, Oracle Consultant, Oracle Form Developer and in-house ERP Systems Analyst.
• Experience of tuning Oracle Forms, Reports 6i, SQL Performance Tuning, preparation and execution of stored procedures, functions and triggers. Over eight years of experience on Oracle 8i / 9i /10g DB and Forms 6i /10 and Reports 6i /10g with hands on PL/SQL, stored procedures, triggers, 3NF etc.
• Experience as Data Quality Lead to actively drive and manage the data requirements for migration, coordinate with the Integrity project manager(s) and technical teams, create and review Requirements Documents.
• Proficient in analyzing and translating business requirements to technical requirements and database modeling by having a strong Architecture concepts, database skills, Object Oriented Programming and development knowledge
• Well versed in preparation and execution of test cases and good experience in different software testing like Sanity, Unit, Black-Box, White Box, Alpha, Beta, Comparison, Integration and Interface.
• Knowledge of data management tools i.e. Optim 6.5 which helps in data security, data anonymization, data masking, archival and test data management.
• Executed software projects for Telecommunication, Industrial (Manufacturing) and Distribution, Finance, Government and Energy and Utility industries.
• Excellent communicator; leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.

TECHNICAL SKILLS

Databases: Oracle, DB2, Sybase, SQL Server

Languages: PL-SQL, Developer 2000 (Forms 9i/6.0, Reports 9i/6.0), Transact-SQL, Java, C++, C, Visual Basic 4.0 - 6.0, PowerBuilder 3.0-6.0, HTML

Platforms: Windows NT, UNIX, LINUX

Project Domain: In-house ERP/Payroll Management System; Inventory/Sales Management System; Financial Accounting Management System; Procurement Management System

Operating Systems: Windows NT, UNIX, Windows 95, Linux, MS-DOS

Hardware: PCs, Confidential

RDBMS: SQL Server 2005, 2008 and 2012, Oracle 11g, Oracle 10g, Oracle 9i, DB2, Sybase

Applications Methodologies: Object Oriented Analysis and Design

Tools: TOAD 8.0, 7.5, 7.0; ODI; RDA 7.5; IDA 7.5; OPTIM 6.5, Erwin

Processes: Confidential ’s QMS (Quality Management System)

Repository Tools: Rational Clear-Case, Rational Clear-Quest, Visio, CVS Version Control

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Data Architect and Project Lead

Responsibilities:

• Working on internal Big Data Project that was a Proof of Concept for sales team. Responsible for the following as a part of the proposed solution.
• Gathering medical data i.e. Physician, Patient, Treatment, Diagnosis, and related data from Internet using Mozenda Tool.
• Retrieve back additional personal data, such as date of birth, location of birth, Weight and Height, any personal data that reflects the individual (race, ethnicity, sex, sexual orientation, etc.).
• Develop a Data Model to support the storage of content analytics, and to store the full extractions onto AWS EMR (Elastic Map Reduce) environment.
• Testing the Data in the Alchemy API tool to check for the Alchemy API standards and the keywords which can be used for Descriptive and Performance Analysis.
• Creating the data for Qlikview which is an exploration & discovery Analysis.
• Inserting the data into OPENEMR database.
• Mapping the data from both OPENEMR to Qlickview.
• Insure that data once extracted from the EMR is HIPAA compliant.
• Handle both on-shore and off-shore team of four.

Environment: SQL Server 2012, Hadoop, OPENEMR, Qlikview

Confidential, Orlando, FL

Senior Data Architect and Project Manager

Responsibilities:

• Worked on Wyndham’s Physical Inventory Application which enables a variety of opportunities to modify data in its Physical Inventory database. The users modify physical inventory information that resides in a SQL Server Database
• Led teams across broad technical and business disciplines. Focused teams on business objectives and tracked pro3gress to ensure project milestones were completed on time, on budget and with the desired results.
• Mitigated risk factors through careful analysis of financial and statistical data.
• Anticipated and managed change effectively in rapidly evolving global business environments.
• Managed client engagement services and solution implementations
• Provided business consulting, knowledge expertise in strategic performance management methodologies, process assessment work, and the application of technologies to business.
• Traced the impact of 35 different transactions across Property and Inventory Management system so that user can have clear visibility of the changes they made either in the Source System or any of the downstream system.
• The impact was being done by interviewing the Business Persons, Query the ETL repository, analyzing ETL mapping, understanding the documents and tracing down the impact. This was further summarized into Data Flow Diagrams.
• Provided a quick and effective means to refresh the Physical Inventory Views in the Voyager platform, without encountering any down time for the views.
• Led team of three Analysts and one Technical Writer.
• Analyzed and defined high-level key metrics to be captured for each business subject areas that can quickly determine whether the production data is within the valid range or not. Compare key metrics with source data.
• Based on the domain, metrics will be compared at different data processing layers including Stage, Central Repository, Hub, and Analytics.
• Handled the team and updating the management of the Progress.
• Developed the High Level Design, Low Level Design and develop SQL statements that will populate the to-be-distributed flat-file.
• Developed flat file report that will be provided to users.
• Led both on-shore and off-shore teams of 8 Technical Analysts.
• After migration of the data in each layer, performed testing to do data validation.
• Responsible for scope creation for multiple databases’ future phases. Analysis for work effort and hours required for the completion of these scope documents was completed.

Environment: SQL Server 2008, Oracle 10g, Informatica, ERWIN, SQL Developer

Confidential

Senior Data Architect and Project Manager

Responsibilities:

• Acted as Technical Lead and supported the Project Manager in achieving the project objectives.
• Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.
• Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
• Data Integration patterns for Batch and Real-time sources.
• Extracting Data from Master Data Management and Data Stewardship for providing business users with high-quality data that is easily accessible in a consistent manner.
• Implementing Data Quality practices for data management.
• Coach, mentor and lead personnel within a technical team environment.
• Interacted with customer for requirements, design and delivery.
• Developed data strategy and design specifications.
• Developed conceptual data models that demonstrate understanding of business rules, hierarchies and relationships between entities.
• Developed logical data models based on client approved conceptual data models.
• Responsible for the deployment of the physical database and the ongoing performance, stability and reliability of the database.
• Granted role permission to users, batch jobs and elements on admin, planning and report modules.
• Performed daily code and database migration on CompNAV and MyCompNav.
• Supported the daily tickets raised by client and assign them to team for the changes required and apprise them of status.
• Assisted with the transition of currently running applications to the new technologies.
• Reviewed, recommended and assisted with the implementation of systems monitoring and capacity planning.
• Implement methods and procedures for tracking data quality, completeness, and synchronization.
• Provided the means of system integration by understanding the source and target data and build the data mapping.
• Checked daily load of the data loaded on daily basis.
• Updated daily users of the progress and status of daily data load.
• Supported the daily tickets raised by client for the changes required and apprise them of status.
• Handled six member team.

Environment: SQL Server 2008, Oracle 11g and Oracle 10g

Confidential, Atlanta, GA

Senior Data Architect and Program Manager

Responsibilities:

• Directed a high performance team of 25 offshore consultants.
• Oversaw all aspects of cost and time estimation, statement of work, project planning and scheduling.
• Worked for statement of work, project planning and scheduling, status reporting resource allocation and issue, risk and client management
• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
• Selection of Physical Data Models including OLTP Relational, OLAP Dimensional, Hierarchical, Columnar, and unstructured data repositories.
• Demonstrated risk approach to technology implementation.
• Developed project plans and assumed responsible for timely delivery. Worked with clients to assist in moving their organization from SEI CMM level 2 or higher
• Monitored project activities and advised staff of issues due to resource availability.
• Worked on Confidential Mid-Tier Transformation Project as Information/Data Architect. This Mid-Tier Transformation/Modernization Project were undertaken to:
• Technical specifications from business and technical requirements including design specifications and implementation task planning.Improved and modernized the infrastructure and its support model.
• Conduct data capacity planning, life cycle, duration, usage requirements and feasibility studies.
• Updated and modernized Confidential mid-tier hosting technologies.
• Assisted with the transition of currently running applications to the new technologies.
• Reviewed, recommended and assisted with the implementation of systems monitoring and capacity planning.
• Use DB2 9.7 Enterprise Edition to do workload management system. Also using event monitor for the event types
• Improved system recovery with a 3-footprint server model and review and recommend virtualization strategies and opportunities and Improve new application support model.
• Implemented new Production Support Team model and implement new Application Delivery Team model.
• Provided new service level delivery capabilities.
• Understood the customer's business requirements, business processes and system functionality to develop the data design and maintain the source of data.
• Responsible for developing and maintaining a formal description of the data and data structures which includes data definitions, data models for Conceptual, Logical and Physical Data Model, data dictionaries, data flow diagrams, etc. in short metadata.
• Data architecture includes topics such as metadata management, business semantics, data modeling and metadata workflow management.
• The architecture covers databases, data integration and the means to get to the data resolve the end to end data issues, design issues and end to end test issues with the help of data dictionaries.
• Provided the means of system integration by understanding the source and target data and build the data mapping.
• Create strategies and plans for data security, backup, disaster recovery and archiving
• High-level data architecture documentation, which illustrated the source and destination of data to and/or from approved data sources.
• Developed a data strategy and design specifications.
• Designed strategy and design for managing history data.
• Selected capabilities and systems to meet business information needs and evaluating new techniques for enhanced functionality.
• Daily call and meeting with the customers to prepare document and review the migration strategy.
• Finalized the tool strategy to be implemented and the different ways to optimize the application performance improvement.
• Checked the consistency between sub-architectures and to identify the re-usable components with in the architecture.
• Enforced architecture compliance and improving the maturity level of architecture discipline within the Confidential organization.
• Provided the basis for all decision-making with regard to changes to the architectures.
• Ensured that infrastructure projects are aligned with agreed-to Confidential and Confidential standards and are scalable to meet both current Confidential requirements and future growth requirements.
• Ensured that the Confidential infrastructure considers the architecture of Confidential applications.
• As a result, I also needed to review the infrastructure requirements for all CSRs and application projects greater than 500 hours, or of any size if deemed by an appropriate manager which contain changes that are significant enough to warrant review.
• Provided input based on knowledge and experience with the steady-state support of the Confidential Infrastructure environment.
• Responsible to stay abreast of new technologies and practices that might be suitable for consideration within the Confidential environment and to raise those as topics for future IAB Monthly Review Meetings.
• Handled team of 26 members which include 20 off-shore team members.

Environment: SQL Server 2012 and DB2 9.7

Confidential, Detroit, MI

Senior Data Architect and Project Manager

Responsibilities:

• Structured a project team to execute senior management's vision for the implementation of advanced technologies to support real time data exchange on the trading floor and cutting-edge communications for the customer and state department.
• Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.
• Manage remediation of short-term tactical solutions to achieve long-term objectives and an overall data management roadmap
• Worked on data modeling and architecture with 3NF implementation.
• Installed Oracle 10g both on server and client and also installed Oracle Middleware like Oracle Application Server: Oracle Forms and Oracle Reports.
• Selectively purged records from the database in accordance with MDCR Records Retentions Schedules.
• Modified existing forms and reports to reflect changes in business processes and to enhance or restore functionality.
• Created new forms and reports to support current business processes.
• Corrected appearance issues in existing reports, including those resulting from the shift to the Oracle 10g database platform.
• Determined the source of and correct programming errors that delay or prevent the completion of data commits in specific modules.
• Corrected programming errors that prevent the proper functioning of specific aspects of the CMS application.
• Assessed the impact to CMS of a shift from Novell GroupWise to MS Outlook and make or plan for any modifications required to implement the transition.
• Modified database structure by adding columns and tables as needed to support new functionality.
• Created or modified forms and reports in accordance with written work orders provided by the MDCR Program Manager.
• Assisted and supported user acceptance testing.
• Deployed completed work upon authorization by the MDCR Project Manager.
• Documented the changes done for the existing reports and form and also if new forms and reports are created.
• Handled 15 team members (3 Confidential resources and 12 Client resources).

Environment: Oracle 10g

Confidential, Dallas, TX

Data Architect, Migration Lead

Responsibilities:

• Installed SQL Server 2008 R2 both on server and client.
• Gathered business requirements from database modeling perspective.
• Designed logical databases using IDA 7.5 Tool by referring use cases and business requirement using IDA 7.5 Tool.
• Converted the logical database to physical databases in Server SQL 2008 R2 database by implementing 3NF.
• Drove and managed the team for the quality of data required for migration from Legacy system to Target Systems.
• Wrote and executed table partitioning scripts
• Analyzed table compression and executing the scripts for the same
• Created and reviewed requirements documents and preparation.
• Create strategies and plans for data security, backup, disaster recovery and archiving
• Troubleshot the data flow between the database and interface.
• Planned the strategy for data migration from legacy to the new proposed database.

Environment: Oracle 11g and SQL Server 2008 R2

Confidential, St. Louis, MO

Data Architect and Data Lead

Responsibilities:

• Installed SQL Server 2008 R2 on both server and client.
• Gathered business requirements from database modeling perspective.
• Designed logical databases using RDA 7.5 Tool by referring use cases and business requirement using RDA 7.5 tool.
• Coordinate with established data governance processes
• Converted the logical database to physical databases in Database by implementing 3NF.
• Involved in database tuning by performing query optimization.
• Drove and managed the team for the quality of data required for migration from Legacy system to Target System.
• Created and reviewed requirements documents preparation.
• Troubleshot the data flow between the database and interface.
• Handled data migration team for data migration from legacy to the new database.

Environment: SQL Server 2008 R2

Confidential, Atlanta, GA

Build and Deployment Admin

Responsibilities:

• Lead the support team tasked with managing code repository and code deployment across multiple environments (development/testing/production).
• Responsible for managing database deployment across multiple environments (development/testing/production).
• Coordinated staging off the code to the client's environment for deployment to testing and production environment.
• Responsible for code and database quality assurance.
• Involved in application trouble shooting and defect management.
• As communication liaison between development/test/project management as relates to code and database management.
• Helped team in preparation and execution of Ant script for DB and code deployment.
• Prepared and executed test cases.

Environment: SQL Server 2005

Confidential, California

Oracle Consultant and Data Lead

Responsibilities:

• Developed and performed ETL processes for CPR using Oracle Data Integrator (ODI) tool.
• Prepared CODB (Central Offender Database) and DECS (Disability and Effective Communications Database) reference data/terminologies for Oracle consumption.
• Prepared CODB and DECS transaction data for Oracle and initiate consumption.
• Prepared location hierarchy tables for Oracle consumption.
• Developed error handling processes/procedures for CODB and DECS.
• Performed data cleansing and data remediation.
• Involved in query tuning process.
• Involved in duplicate record checking, analysis, survivorship and deletion.
• Performed remediation of variances from specified standard medical terms and codes or Confidential specified data formats.
• Accepted, resolved, investigated and escalated if necessary, ODI service incidents from the CPR Call Center.
• Monitored and repaired data feed issues from various vendors like Maxor, Quest and Foundation required for processing of data in ODI.
• Worked with CPR to define, prioritize and complete design phase required for minor enhancements.
• Provided Level 2 and Level 3 support for CPR.
• Involved in pharmacy profile review.

Environment: Oracle 9i

Confidential

Oracle Data Architect and Project Lead

Responsibilities:

• Installed and configured Oracle 10 g SOA fusion.
• Designed logical databases using RDA 7.5 Tool by referring use cases using RDA 7.5 Tool.
• Converted the logical database to physical databases in Oracle 10g database by implementing 3NF.
• Created and managed the database, database users, granting objects and system privileges, creating roles, tuning, backup and using tools for monitoring information about database health.
• Prepared integression test environment for the testers and developers as per requirement specifications.
• Involved with team for loading of correct data in databases.
• Involved in SQL performance tuning.

Environment: DB2 9.5

Confidential

Migration Team Lead

Responsibilities:

• Prepared SQL Server 2005 and UNIX scripts like stored procedures and functions used in extraction of the subscribers from source systems.
• Analyzed and prepared transformation rules to be applied in the migration process.
• Coding, reviewing, testing, verification and SQL query optimization of SQL Server 2005 and UNIX scripts used during subscriber's migration activity.
• Actively drove and managed the data requirements for migration, coordinated with the integrity project manager(s) and technical teams, create and review requirements documents.
• Prepared subscriber migration plan, schedule, strategy, pre-requirements, final process, testing and re-conciliation of final subscriber migration report.
• Received an appreciation mail from Project Deliverable Manager, Program Manager and also Project Manager after successful migration of 47 million subscribers with only 0.003% errors.

Environment: SQL Server 2005