Sql Server Data

VENKATA ANAND

HYPERLINK "mailto:*********@*****.***" **********@*****.***

Ph 978-***-****(M), 978-***-****(H)

San Ramon, CA.

PROFESSIONAL SUMMARY

22+ years of experience in IT and with experience as a Team Lead, Principal Database Architect and Principal Database Developer .

Experience in Financial, Telecommunication, Manufacturing, Health Systems, with consistently increasing responsibilities in Project Management, Product Development, Product Design, Implementation, Statistical Data Analysis and Validation.

Hands-on experience leading all stages of system development efforts including requirements definition, design, development, testing, implementation and support.

Expertise in Oracle, PL/SQL, SQL Server, T-SQL, Data modeling, Performance Tuning, extensive design and development experience

Strong Experience in Informatica, Informatica Data Quality, SSIS, SSAS.

Experience in Business Objects for Querying and for Crystal Reports.

Experience in Hyperion, HTML, XML, Web development.

Strong Experience in Unix, Perl, CGI Perl and C Language.

Strong Experience in Reports – Crystal Reports, Oracle Reports, Hyperion and OBIEE.

Strong analytical, interpersonal, communication and problem solving skills.

Experience in Sql Server Cloud environment.

SKILLS

Databases : Oracle 11G, SQL Server, DB2, MS Access, Informix, Sybase 11.0,

ETL : Informatica, OWB, SSIS, SSAS

Reports : OBIEE, Hyperion, Oracle Reports, Crystal Reports.

Languages : PL/SQL,SQL, TSQL, HTML, Javascripting, C, C++, Perl, CGI Perl,Unix scripting.

GUI/Tools : BUSINESS OBJECT 3.1, APEX, SQL*Plus, Pro*C,SQL*Loader, Reports6i,

Visio5.0, ERWIN, PowerDesigner, TOAD,SQLNavigator,PVCS,ClearCase,

SQL Programmer, VB 5.0, MS Access

OS : Windows XP, Sun Solaris 7.0, Linux, HP-Unix 11.0/9.0,3000, SCO Unix,

Windows NT, Windows 2000.

MPP DB : Netezza

Knowledge : Oracle 11i application server.

EXPERIENCE

Kronos Chelmsford MA Mar 2014 – Till Date

Technical Database Architect /Analyst/Support

Worked on the Work Force Central(WFC) product. Work Force Central Product suite provides

labor management solutions in four key areas Time and attendance, Scheduling, Human

Resource management and Payroll.

Advised software development teams on architecting and designing Sql Server databases and infrastructures that safely and efficiently power the cloud environment.

Interact with the customers, second level support team to provide solutions to customer issues. Also intereact with Engineering team and provide Database Architecture Solutions.

Worked on Oracle and Sql Server Database Design and in Jboss middle tier Services.

Educate and work closely with the customers, 1st and 2nd level support team . identify problems and provide solutions.

Provide on-call duty to resolve customer issues and available on weekends.

Worked on Power Point presentation for the clients and Functional specification for the Engineering Team.

Designed and developed prototype code in PL/SQL and in T-SQL which was provided as sample to Engineering Team.

Strong in visio,excel, word, powerpoint and outlook applications

Worked on various Kronos products like Process Manager, BGP (BackGround Processor), WDM and so on.

Fidelity Investments Merrimack, NH Sep 08 – Feb 14

Principal Database Architect/Developer

Worked on the Corporate Compensation Data Warehouse (CCDW) System for the

CTG Group. The CCDW is an internal Payroll system for the HR Department which

maintains the employees compensation and bonus.The systems contains a E-workplace

intranet web page on java and a Oracle Database for real time transactions and

DataWarehouse system for Reporting.

Lead a team of 1 developers onsite and 2 developers offshore.

Was an Architect Lead and interacted with Offshore team in India and China, Business Team, QA Team in an Agile environment

Worked on Informatica WorkFlow Design and development of Data transfer between an OLTP Database, DataWarehouse system and MPP Database Netezza.

Worked on SSIS and Informatica for Data transfer between databases and file sources.

Worked on Power Designer for Data Modeling, SSAS for SQl Server OLAP model and used Visio for Functional specification and Data Flow Diagrams.

Converted Hyperion Reports to OBIEE and legacy crystal reports, Oracle reports to OBIEE.

Designed and developed Screens in APEX.

Worked in the Equity and High Income Group. Worked in the Best of Breed Project which

handles the holdings and assets of mutual funds and compares the prices between JP Morgan,

Navgen and Bloomberg Prices.Worked on the Barra one Project which brings in risk

analysis for the fidelity holdings.

Lead the Infosys Team and the offshore team in the Best of Breed Project.

Lead the Migration of the Project from SQl Server Database to Oracle Database.

Converted SSIS SQL Server ETL to Informatica Workflows.

Worked on an agile environment and interacted with the business team to convert the business requirement to a Technical Design document.

Designed PL/SQL Packages, Informatica Workflows, screens and reports.

Developed Triggers, Advance queue, Replication, dblinks.

Computrition Bedford, MA. Aug 07 – Sep 08

Principal Software Engineer/Data Architect

Involved in the Analysis, Design, Development,Testing, Implementation of the Hospitality Suite

product in various Hospitals. It provides the software that a patient or Doctor can order food menus that can be delivered at the room service or at the catering.

Designed and developed User Interface screens in Visual c++ and Packages in Oracle required for the customers in Hospitality Suite application. Designed and Developed Food Menus, Patient Menus, Inventory, Food Stocks and Returns.

Designed and Developed screens in Visual c++ and Visual Studio and interacted with Oracle Database using Perl scripts.

Performed a Data Architect role by analyzing and building the Data Model for the Oracle Database using ERWIN.

Designed and Developed Database Packages in PL/SQL with very complex sql statements.

Performed Unit Testing, Integration Testing, Performance Testing.

Investor Bank and Trust, Boston – MA Jun 05 – Aug 07

Team Lead

Worked on the backend technical architect, design, development, implementation and Production

Support co-ordination on various applications. The applications were InvestSweep for

Client BGI, CASH Application for BGI and Norges, ETF for client Goldman Sachs and

General Ledger Automation for Bank Wide.

Created and modified data model Using Erwin for reference, exception and performance with peer Architects and business analyst to meet business requirements.

Converted Business requirements into Technical Design.

LYRIX Inc, Tewksbury, MA Jan 04 - Jun 05 Sr Database Analyst

Worked on the analysis, design, development, maintenance and support of day to day activities on the Database for the Voicemail and PeopleFind System for the customers of Lyrix. In Peoplefind system, a person can be called by his name and all the relevant information required to perform this operation is stored in the database.

Ace Technologies Boston, MA Jan 00 - Dec 03 Sr Systems Analyst Worked on various projects for the clients of Ace Technologies.

Clients were CVS - Providence RI, Wellington Management Boston MA Philadelphia Stock Exchange, Philadelphia, Sun Microsystems, CA.

Savant Consulting Group, Edison NJ Mar 96 - Dec 99 Sr Programmer Analyst Completed the Magellan to Eiffel Interface system for Hewlett Packard.Completed the Analysis, Design and development of the Inventory Management system for Clinical systems.Coordinated the setup of Decision support system for IBM.

Amco Batteries Ltd, Bangalore, India Dec 89 - Feb 96 Programmer Analyst

Analysed,developed and implemented the Payroll system ERP application in Foxpro and Cobol.

EDUCATION

BS in Engineering, Marathwada University, Aurangabad, India.

WORK AUTHORIZATION

US CITIZEN

Contact this candidate