Summary:

• Having 13 years of experience in Information Technology and over 8 Yrs in Data Analysis and Data migration/Administrator.
• Involved in Application and Data Migrations, Legacy Application migrations, Desktop Packaging solutions for financial business, Developing Internet/Intranet solutions.
• Hands on experience in developing Web Applications using ASP.Net, Xml, C .Net, VB.Net, Active Server Pages, ADO.Net, HTML, DHTML, CSS, JAVA SCRIPT.
• Extensively worked on Migration projects, Microsoft tools, ETL tools like SSIS, SSRS, Crystal reports and utilizing these tools for data feed.
• Experience in handling complex statement for Pharmacy, Utilities, Financial and service domains.
• A strong zeal in handling projects for GDM and interacting with various culture across the globe.
• Good communication and inter personnel skills, exceptional ability to forecast and analyze the business.
• Comprehensive experience in Web technologies and Microsoft technologies.
• Self-motivated, ambitious, and zeal to face and motivate and get the work done with the project budget and timelines.
• Hands on in handling Japanese projects/clients and meeting their requirements.
• Good problem-solving skills and initiative.
• Excellent oral and written communication skills and along with a zeal to handle larger clients.
• Certified in MCSD, MCSD.NET, OCP, MCDBA, Brain bench certified in ASP, VB, JavaScript

Technical Skills:

• Microsoft Technologies: ASP.NET, .NET Framework 1.0.2.0 3.0, ADO.NET, VB, MS-OFFICE.
• Operating Systems: Windows NT/2000/CE/ME and XP, DOS, Unix and Linux.
• Languages: C .NET, VB.NET, ASP, HTML, DHTML, JAVA SCRIPT.
• Databases: TSQL, PLS/SQL, MS SQL Server 7.0/2000/2005, Oracle. Performance Tuning, Capacity Planning, Installation, Upgrade, Migration, Data Staging
• Development tools: Visual studio 2003/2005/2008, Rational Rose, UML, Visual Basic 5.0/6.0, Active X, C , VB.NET, ADO.NET
• XML Technologies: XML, SOAP, Web services.
• Project mgmt tools: MPP, Estimation, Migration Assessment.
• Tools: Erwin 3.5/4.1/7.0, LiteSpeed 3.1/2005
• Certification: MCSD, MCAD, OCP, MCDBA, Brain bench

Work Experience

Confidential

Role: Database/Business Objects Administrator

Description:

The project involves addressing customer needs across multiple Business Units like Corn Milling, Confidential milling and Dressing sauces and oil. Was responsible to make sure the applications and databases run smoothly and be a go to person for any the database for the application like Checks writing application Secure 32 , Apollo reality charting, Business objects, PQDB ,PQ Terminal, Cornucopia, CMMP, NAFO, ASAP, Rincon, Unilab, Interspec

Responsibilities:

• Work and Co-ordinate with multiple teams to make sure business has their applications up and running.
• Coordinating with IT Admins, Shift Leader at the plant and setup the plant Desktops and install Configure applications Database.
• Involve with development and Testing team and working as a team to identify performance issues in the application and in reports.
• Creating and setting up users and user groups in Business Objects
• Created SSIS packages with which data resources such as Excel, Access, and XML were loaded daily in order to create and maintain a centralized data warehouse. Made the package dynamic so it fit the environment.
• Created scheduled jobs to execute SSIS packages.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Provided support to business operational models, including off-hour support on regular basis.
• Preparing and Helping users to migrate from Windows XP to windows 7 migration.
• Providing high level analysis to application owners so that helps to make the decision.
• Pro-actively monitor database servers and provide status reports on any discovered problems

Environment: SQL Server 2008, SQL Server 2005, Windows Enterprise Server 2003, Windows 7, Access, Business Objects, Informatica, Oracle 10g/11g, Oracle express, Active directory, Mobile devices, AS/400, Windows server 2008, Oracle, Sql Server, ITIL framework, VPN, Remedy, Windows XP Professional, IIS 7.0, Visual Studio .NET 2005/2003, Microsoft Visio 2003, Microsoft BIDS

Confidential

Role: Data Architect

Description:

The project involves in providing a digital signage to Wireless Ronin clients by providing innovative and interactive digital signage application which has content redundancy implemented for all the applications across various clients. The digital signage applications can be configurable for the clients with their respective local information displayable on sign boards.

• Analyzing the application to represent the various presentations.
• Defining and scheduling the presentations across menu boards
• Schedule merge in case of Content Redundancy
• Content Redundancy implementation

Responsibilities:

• Analyze the application and defining the following data entities
• Content Presentation
• Schedules
• Presentation
• Templates
• Layouts
• Assets
• Site Scheduler
• User Management
• Contacts
• User
• Roles
• Objects
• Monitor
• Players
• Display
• RoninCast Product is platform for building and hosting digital signage applications that provide a various interactive and configurable application and helping the business in advertising their respective products.
• All the digital signage applications developed on RoninCast platform are configurable for content redundancy and scheduling.
• In case of Content redundancy the schedule merge are handled seamlessly without manual interruption.
• Creating Logical Data model and physical data model after brainstorm sessions with respective business experts
• Representing the data flow from the digital signage to Data entities
• Involved in retaining the existing Data for applications and fine tuning the data so that data is validated as per the new digital signage application.

Environment: .NET 3.5, jquery, Sql Server 2008, SSIS, NEC Displays, ER Visual Studio

Confidential

Role: Data Analyst

Description:

The project involves migration of Datacom sites to SPSS and the data was extracted from into flat files from Regional hubs, validating the data with the new portal requirement and validating the data and cleaning up the regional hubs with all their individual data and making it into central repository from similar migrated sites.

• Analyzing the existing data for each site
• Defining the extraction criteria for the repository
• Implementing business and PII on the existing data
• Review and test the scripts used for migrating and mapping the fields from site Database to common repository

Responsibilities:

• Analyze the data from the following streams and created Common Interactive Database CIDB
• Digital Channel Consumer Data
• Contacts Points
• Preferences
• History
• Master Data
• Standardized Questions and Options
• Market, Brand and Products
• Localization Codes
• Digital Channel Metadata
• Agencies and Channel
• Channel Configuration
• The NEO is platform for building and hosting digital applications that provide a robust digital channel for acquiring and interacting with customers.
• Beyond providing a rich and engaging consumer experience that enhance loyalty to the Diageo brands the NEO digital applications collect data about consumer that Diageo will use in support of its relationship marketing activities. This consumer data represents a significant asset to Diageo and must be properly protected from corruption, lost and theft.
• Because this data includes PII Personally Identifiable Information is also represents a significant responsibility on Diageo's part to safeguard the privacy of its customers.
• CIDB schema generation by using Erwin and using SSIS Packages for migrating the text files to CIDB, with error logging.
• Master data from all the Digital applications for last 3 to 5 Years are being maintained in hubs, the CIDB was replicated keeping the Hub data and CIDB could hold only the transactional data.
• Involved in supporting Data De-Identification of application specific activities

Environment: Sql Server 2005, SSIS, Windows XP, ER Visual Studio, Pentaho open source BI, PGP

Confidential

Role: Data Architect

Description:

The project involves migration of data from various sources which includes Access, Text files to Access and Sql Server 200/2005, It involves the analysis of the existing system of Trueblue Inc's data structure in LABPRO and understanding the various inputs through which the data is updated and synching the existing table structure to new Application and database which is ELLIS and SQL server 2005. ELLIS also takes care of the contacting the vendors for real synch through WEB SERVICES WS . The whole application is built in .NET 3.5

• Compatibility of easing application with the new designed apps
• Analysis of data
• Analysis the business rules for the windows environments
• Usage of Change man and the tracker for checking in/out the files

Responsibilities:

• Designing of data flow for Customer Processing System CPS , a subsystem of the Verification Information System VIS
• A Data flow was authorized across Web Service executables executed on a Web server with a special interface that makes it available for access by other programs through the Hypertext Transport Protocol HTTP and the Simple Object Access Protocol SOAP . The CPS Employer Web Service may be used by an employer application from across the Internet.
• CPS is a data stored for processing the processes employment verification queries for private employers and designated agents. Private employers and designated agents use VIS to conduct verification queries to ensure that U.S. citizens or non-citizens are eligible for employment.
• Front end module contains Queries, Forms, Reports, Macros and Modules.
• Backend module contains Database tables
• Logical flow of Front end and back end modularization to handle more requests
• Splitting Access Database for multiple users to access the application
• MDB to ACCDB Upgrade.
• Access Data Upgrade and normalizing the data
• Designing scripts in sql server for migrating each branch over weekend and the dependency of each entity.
• CPS is to provide a set of services that may be called by employer applications to perform alien status verification. The services provided are modeled after a subset of transactions that are available in the HTML Web employer access methods. The Web Service methods included in this ICD allow an employer to perform the entire DHS employment verification process. This document assumes that the reader is already familiar with the DHS E-Verify Employment Verification business process. If this is not true, it is highly recommended that the reader contact the DHS Verifications office and request a test account for the DHS E-Verify or WEB-DABP HTML graphical user interface GUI application in order to gain familiarity with the Employment Verification business process.
• Validating the data Pre and POST migration with accordance to Branches
• Atomizing the script for master data creation and handling Sev 1 and Sev 2 data issues

Environment: Windows XP, SQL SERVER 2000/2005, Microsoft Access 2003/20007, Sql, .NET 3.5, ER Visual Studio, Change man, TSQL

Confidential

Role: DW Migration specialist

Description:

The project involves migration of Solaris, HPUX application to AIX 5.3 and migrating the data from Oracle 8i/9i to oracle 11g. The client has the around 9 TB of data to be migrated. The client is running his Pharmacy business in the Solaris and HPUX environment and we are involved in understanding the existing scenario and migration it to AIX 5.3 Environment, and moving around 2800 tables across the platform which accounts to 14 TB.

Responsibilities:

• Compatibility of C header files, KSH, C, Pro C and make files in Solaris and AIX
• Using CTAS / Insert / APPEND approach to load data from source database to target database.
• Migrating the 67.5 GB of table data data pertaining to COMPLIANCE application from Oracle 8i to Oracle 11g.
• Migrating 9.38 TB of table data data pertaining to RxDW from Oracle 9i to Oracle 11g.
• Moving History data 4.11 TB of table data and index data ahead of production cutover.
• Analyzing and addressing performance related issues, if found due to migrated modified portion of code.
• Configuring, Scheduling, Data migration process and RxxD090 jobs in control M.
• Understanding of Current View Architecture
• This view has data up to 24 fiscal months.
• Current view has nightly updates. The updates which are done intra-day are not tracked.
• The Tlogs transaction logs are loaded to Script V.
• The log tables are fed to summary tables. Log tables are cleared by a purge job.
• The major tables are Script V, Date Resolution, Patient, Prescriber, Drug, Patient Member, Patient Residence, Patient Coverage.
• RXXD900D has C programs which load the above tables.
• Historic View Architecture
• PAS Pharmacy Archival system has data up to 7 years.
• Every change to the current view is stored as a new record in the historic view tables. These changes are pulled from the log tables.
• There are jobs which delete old partition and add a new partition once in a month.
• Designing and implementing Data De-identification for various programs
• Under HIPAA regulations certain dates and details such as age and birth date are under regulation if in combination with other information that would help identify the patient.

Environment: HP-UX, Unix, Solaris, AIX 5.3, Oracle 8i, Oracle 9i, Oracle 10 g, Pl/sql. HIPPA Sox, PVCS tracker, Quick build, Control M scheduler

Confidential

Role: Legacy Migration specialist

Description:

The project involves migration of Mainframe application to .NET environment. The client is running his business in the mainframe environment and we are involved in understanding the existing scenario and migration it to .NET Environment, which is multi layered architecture composing of UI, WCF, SSIS and SSRS. I was involved in object framework, which was reusable in all the layers of the application and utilizing the framework to its extent. Involved in designing of the objects. Implementing the business logic and was handling the SSIS part of migration, where in a mainframe resource will understand the current programs from COBOL and will create Business process BPS and Business Rule Extraction BRE documents, which will be the guidelines for Sql Server integration services SSIS . After creating the equivalent packages, we have to look out for options to combine various programs for better performance. The SSIS involved the below challenges in the process of migratio

• Data which is obtained from application where in the data was still residing in DB2
• Current Performances of the existing programs were in seconds, this was difficult task to achieve in the TOBE system. We had to get the buying from the client in this case as this was not achievable in few scenarios.

Responsibilities:

• Compatibility of Existing DB2 with Sql Server 2005
• For all the jobs in mainframe were handled sequentially, which in the jobs in Sql server were not the same and we had to re-code in sql broker to achieve the same.
• Installing and Configuring the SSRS Report and generating the reports in SSRS.
• Mainframe Program and SSIS package level mapping.
• Cross verifying the mainframe functionality with SSIS Package output and validating the output with the legacy application.
• Implemented SQL LiteSpeed backup and restore in addition to Microsoft native backup and restore for large databases.
• Handling Design concurrency for SSIS packages using Sql Broker object.

Environment : Sql Server 2005, .NET Compact Framework 3.5, SSRS, SSIS, TSQL, SOX Compliant, Sql Lite

Confidential

Role: Tech Lead

Description:

• This project is a Route Accounting System developed to automate a range of sales and delivery operations for a work force, including presales, sales and delivery, management, inventory and field service activities.
• The system manages every step of the order-to-cash cycle on a day-to-day basis, from entering orders, fulfilling orders, delivering products, creating invoices and settling routes to reconciling financials. The system also provides interfacing to third party financial systems e.g., SAP, Oracle through data integration. Also automate the process of taking and reconciling physical product inventories.
• System provides provision to Track the installation, repair and management of different types of field-based assets throughout its lifecycle e.g., vending machines, coolers, fountains, tanks, trays , as well as manage the fleet used in the field.
• The back-office supporting application acts as a hub for data synchronization. The data synchronization is done in different modes and is picked based on the supporting systems running in the back-office. The system captures the comprehensive operational data on marketing, sales, full service and delivery activities. The back-office component has provisions for analyzing the data on a daily, weekly or monthly basis, and enable better selling decisions and higher margins

Responsibilities:

• Created logical and physical database design, data structures, and implemented large databases using Erwin 3.5.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database Oracle and Text format data to SQL Server 2000.
• Syncing the Sql CE Database and Sql Server.
• Sql Server
• Text files
• XML files
• Constant revival of the Database and Educating about the Database.

Environment : Windows CE, SQL-Server CE, Sql Server 2000, Oracle, TSQL, .NET Compact Framework, Erwin.

Confidential

Role: Data Analyst

Description:

Confidential is a single platform ePayments solution that addresses your payables needs in making payments of any type and currency, both domestic and cross-border. The Straight Through Services solution improves efficiency in your account payables process by consolidating multiple transaction types destined for multiple clearing zones and countries. It also reduces paperwork, streamlines approval, improves reconciliation and enhances security and control. The Straight Through Services ePayments solution is designed to fit within your existing accounts payable process with minimum disruption in the implementation process. Our solution eliminates manual tasks involved in making payments, freeing up management and staff time for more productive activity. In short, Straight Through Services enables you to focus on your business rather than on executing payments.

Responsibilities:

• Created a reusable, parameterized batch date control system to track intra-period extraction of source system transactions so that monthly, quarterly and annual workloads and runtimes could be minimized.
• Tier III Database support for the failed payments
• Designed, modeled, implemented and tuned all database objects and ETL to support the recruiting initiative using CA Erwin, SQL Server.
• Developed and documented all Unix jobs to automate periodic builds based on Code fixes. Added simplified restart and rerun procedures after reviewing code.

Environment : Windows NT 4.0, SQL-Server 2000,DTS, Sybase, MSDE, VB, COM, Dcom, TSQL, PL/SQL, ASP.NET, VB.NET, .NET Security, Data Staging , Unix, Mainframe

Confidential

Role: Programmer

Description:

This is a client/server project of a firm, which deals in transferring of Comma separated file to the database. This software was designed in order convert data stored in .CSV files into Sql Server database. This software would also create tables dynamically reading from the structure defined in the .def file. The concept is to update all the files in the database and the system also gives the alarm whenever the exe or dll files are copied/deleted unless mentioned in the DEF File.

Responsibilities:

• Generating the file structure in Database and streaming the CSV file data.
• Converted the comma separated values as data to the database.
• Involved in creating the tables from a CSV File and mapping the data from external source.
• Using/generating Visual Interdev Business Intelligence Report, SQL Server, ad-hoc reports and Crystal Reports, Crystal Analysis and development and deployment of Publishing Reports on the Intranet as well