Project Sql Server

Padmanabha V Joshi (PV)

Summary:

• Overall ** years of consolidated IT industry in development as a Systems Analyst, Developer with a strong data testing/SQL background.

• Ability to work with business owners, system developers and various levels of management. Expertise in gathering systems requirements, creating and performing test scenarios/test cases supporting new business requirements and planning to test runs providing executable status.

• 2+ years in the system development, test support and maintenance of Financial and Health Insurance computer applications.

• 4+ years in Data Warehousing and Business Intelligence Solutions; can use various software programs such as Oracle, DB2, MicroStrategy, Informatica, SQL Server Integration Services (SSIS) to process data, access different system resources, and incorporate T-SQL statements

• Good at data and metadata analysis and also in management, understanding complex user requirements and resolving technical and functional issues

• 3+ years experience with project management principles and methodology; experience in leading discussions and meetings, interface with various levels of the organization

• Dedicated learner, resourceful and innovative instructor who formulates business process methodologies. Strives to help others learn and grow; exceptional communicator who is well organized, creative and persuasive

• Ability to provide technical support and trouble shoot computer problems; regarded as a key resource and problem solver by colleagues and administrators in the area of systems analysis and integration

• Communication skills with strong interpersonal, written and verbal skills

• Considerable knowledge of the principles and techniques of computer systems including systems analysis, design, long term planning, programming, and computer equipment characteristics.

• Professional, enthusiastic, customer-focused individual who is passionate about assisting with organization’s vision.

Skills Summary

Special Skills: Client interaction, Proposals, Architect and Design, Data warehousing Modeling and Design

Programming Languages: C, PHP and JAVA, SQL, VB/ASP.NET and Unix Shell scripts

Databases: DB2, Oracle 10g, SQL Server 2005/2008 R2, MS Access

Operating Systems: OS/390, UNIX, Windows NT/2000/XP/Windows 7

BI Tools: Microsoft SSIS, MicroStrategy, Informatica, Oracle BI

Industry Focus: Telco, Finance, Insurance and Health Care, Distribution and Retail

Testing Tools: QTP, WinRunner, Quality Center

Professional Experience:

Universal Health Care Inc: Oct ’11 – Feb ‘12

Database Architect

Project is about migrating all the from its old legacy health care system to new system (QNXT/MedHok). This would include migrating the Medicare and Medicaid Members, Enrollments, Providers, Contracts, Claims/Encounters, Service History and Authorizations and Utilizations to QNXT/MedHok from the Legacy Systems.

As a database architect, I was involved in the end to end system planning, design, mapping and data delivery for the Core and Care Applications from Business as well as IT perspective. Initiated and coordinated the analysis and design requirements for ODS (operational Data Source) including schema and ETL scripts.

Worked closely with Trizetto on the system configuration and reporting compliance requirements to be implemented as part of the Business Intelligence reporting application.

Worked with different Business Units (viz. Provider Management, Claims Processing, Payment Processing, Services and Membership etc.) to capture gaps and functional requirements.

Worked with Vendors to setup various Environments for project implementation.

Coordinated with various Vendors and the EDI teams to Load data to applicable EDI interfaces.

Single handedly managed and negotiated purchase of varieties of HIPAA Code sets at an extremely affordable term thus saving the company more than 50% of the cost.

Environment: Windows XP/7. Microsoft SQL Server 9.0 Tools, Business Intelligence Suite, QNXT 5.7, EDI/X2, Agile Scrum methodology

Consulting with various clients: Jan ’11 – Sep ‘11

Providing management consultation in the areas of business intelligence, Data warehousing, architecture, SQL Scripting, data mapping and metadata analysis and management. Troubleshooting computer network connectivity issues, Automating medical provider and clinical applications, setting up FTP processes to interface various functionalities in health care industry. Environment: MicroStrategy, Informatica, Microsoft Windows, SQL-Server, Oracle, MS Project, Visio, ERWin, Excel, TOAD, SSIS ETL.

Verizon Inc. Dec2006 –Dec2010

Role: Lead Analyst

Responsibilities included providing, production and user support, designing and maintenance and coordinating with business users for issue resolution. Supported Data mapping, SQL Scripting, recommended Information Strategy and Business Area Analysis plans. Designed and architected Data Warehouse for FIOS to merge legacy databases. Coordinated with stake holders, SMEs, Application owners, system/database administrators, data warehouse team members and testers to maintain and enhance the business intelligence/data warehouse environment to support ongoing production and future development needs.

Environment: MicroStrategy, Informatica, IBM and Microsoft, Sun platforms. SQL Server, Oracle, MS Project, Visio, ER/Win, Excel, Verizon enterprise applications.

A2Z/Global Consulting Inc. Aug2004 -Nov2006

Client: Verizon

Role: Lead Analyst

Lead Command Center facilitating all end-to-end provisioning and billing systems for the implementation of the project FIOS for Verizon. Architected and designed a Data Warehouse to merge legacy databases. Designed and developed staging and warehouse data models in ER/Win tool. Created dimensional entities utilizing surrogate key construction to facilitate slowly changing data approach. Data driven approach building out 50 plus table structures containing over 1200 attributes representing Managed various BI reports and ETL objects, configuration changes made across various systems and environments. Supported data mapping, SQL Scripting. Trained, Mentored, and supported professional development of Technical services team.

Environment: Multiplatform, IBM, Oracle, Microsoft, MicroStrategy, Informatica, Visio, ERWin, SQL Server, Verizon Enterprise Applications.

Keane Information Technology Nov2002 -Feb2004

Client: Goldman Sachs Inc.

Role: Project Lead

Installed MicroStrategy (8.x) and Informatica (6.x). Installed, configured, and administer MicroStategy reporting applications on two separate Windows 2008 servers maintaining both a Development and Production instance. Performed Migrate, create, and modify Extract, Transformation and load (ETL) processes.

Provided extensive onsite interaction to understand and formulate key user requirements. Estimated resource and cost estimations and formulated design solutions. Lead a team of 3 offshore resources.

Environment: IBM, UNIX, DB2, Oracle, MicroStrategy, Informatica, MicroSoft SQL Server, Sun platforms.

American Express India Pvt. Ltd. Nov2001 -Nov2002

Role: Project Lead

Project Description: This Application consolidates Transactional Financial data at various market levels before feeding into Global Reporting Data Warehouse maintained at TRS level.

Managed cost, scope and schedule of the project for a team of 5 providing global technical support for a highly critical central financial database in AMEX that improved the overall efficiency by 75% while keeping the overall budget by 10% lower year-on-year. Participated in system-integration, component architecture, software quality processes and software standards. Created business-friendly data mappings and extracts for the re-engineering project. Provided consultancy for a new initiative in DW/BI SIG.

Environment: IBM DB2, UNIX, Microsoft SQL-Server, Oracle, Sun Platforms, Informatica PowerCenter 4.5.

Rao Consulting Inc/SBC Inc. Sep1999-Sep2000

Client: Thomson Inc.

Role: Project Lead

Project Description: This application was a new development effort to extract transform and Load all enterprise-wide Customer Data into the consolidated CRM database for Decision Support System.

Oracle/UNIX Lead developer for a large data warehouse architected around I2’s Supply Chain Planner to support Customer relations, Demand Planning and Demand Forecast Analysis. Developed and debugged Informatica mappings on PowerCenter 6.x. Implemented cost and time saving customized data mappings to rewrite legacy loading processes into Informatica Mappings. Coordinated the migration of Database objects into Oracle production Database using PL/SQL.

Environment: Multi-platform, UNIX V, Oracle 8.0, Microsoft SQL-Server, Visual Studio, DB2, Toad and Utilities.

Innovative Systems Group Inc. Nov1995 -Jul 1999

Client: HSA(Health System Architects)

Project Description: Initiative to build a large Data Warehouse for Great West Life.

Designed and developed a customized data scrubber product, ProClean/PIMS. The product enabled the user to perform the data mapping, extraction, conversion and data cleansing on GWL’s provider data before being placed into PIMS database. Lead consultant position.

Environment: UNIX V, Oracle 8.0, Microsoft SQL-Server, Visual Studio, DB2, Toad and Utilities.

Client - Tru*Serv Inc.

Project: Marketing and Member Systems(Duration: 15 months)

Project Description: A new development initiative to establish a small scale DW/DSS system for TruServ Corp.

Responsibilities: Played a key role in defining standards and methodology to be followed. Performed Extract Transformation and Loading of data from Legacy system into Oracle database. Used PL/SQL and system scripts to perform the ETL process. Identified the types of queries end users wish to execute. Identified the type of analysis that end users would like to conduct. Involved in improving Database performance Implemented on AIX with Oracle 8.0 as the DW backend, and configured MicroStrategy’s DSS Agent and Architect for metadata definition and Member Order Fill rate Analysis respectively.

Environment: Microsoft, UNIX V, SQL Server, Oracle 8.0, DB2, Toad and Utilities.

Client - Blue Cross Blue Shield IL, CNA, Chicago

Project: Marketing and Member Systems (Duration: 17 months)

Involved in design and development of a CSR application, a brand new system for BlueCross. Performed Logical and physical design of Database objects for a medium size database with high level of complexity. Performed functions like Data Placement, Enhancement and tuning, Improving Query performance (SQL) etc. Create E-R models and design and develop conversion programs to merge the DB2 tables into BCBSs SQL DB. Involved in a group effort to enhance the core claim system and related subsystems to accommodate new product offerings.

Environment: Microsoft, UNIX V, SQL Server, Oracle 8.0, DB2, Toad and Utilities.

Kanbay Systems Inc. May 1995-Oct 1995

Client - Household Credit Services Inc.

Project: Access and Memo System (Duration: 5 months)

Project Description: New development initiative to establish a Access Memo System for processing access checks

Responsibilities: Performed system study, design, analysis, coding, unit and system testing for an Access Checks module, a part of the Credit card business. Wrote COBOL II , CICS, DB2 applications to support on-line client-server transactions communicating to VB through LU6.2 protocol. Modeled, designed and created DB2 database objects. Created JCL and Procedures.

Environment: Multi-Platforms. Microsoft, UNIX V, SQL Server, Oracle 8.0, DB2, Toad and Utilities

SYNTEL INC. May 1993 - May 1995

Client - Safeway Stores Inc., State of New Mexico

Project: Project IRIS

Project Description: New development initiative to create an Integrated Retail and Item System for Safeway Inc.

Responsibilities: Designed, coded, tested, and installed DB2 batch and on-line programs that interfaced to Safeway’s Buying System. Created and modified test and production JCL in an MVS/ESA environment. Used SPUFI, ProEdit and QMF as testing tools and for data manipulation.

Environment: IBM MVS, TSO/ISPF, CICS, DB2, COBOL, Xpediter, SPUFI, PLATINUM Utilities, File-AID for DB2, File-AID, Changeman, Intertest, INSTALL-1

SYNERGIC SYSTEMS, Dec 1991 - Feb 1993

Client - Hindustan Aeronautics Ltd. And Aeronautics Development Agency

Project: Project LCA

Project Description: Initiative to design and computerize LCA parts and its materials.

Responsibilities: Modeled, designed and developed the parts for Fuselage for LCA (Light Combat Aircraft). Performed systems analysis, Design, specifications, coding, and testing. Transported existing PL/I and FORTRAN modules into COBOL, CICS/DB2 applications on IBM-3090 under TSO/ISPF environment.

Environment: Multi-Platforms.

Education: BS Engineering, Karnataka University, Dharwad, 1988

Contact this candidate