Summary:

• OLTP, Operational Data Stores, and Data Marts.
• Reporting Models, Business objects XI R3 and SSRS.
• Data Integration, DTS, SSIS, Data Mirror, Web Services.
• Building Adapting collaboration environments.
• Microsoft Biztalk Server, Cold Fusion, Visual Basic, ASP.NET, VB.NET, VBA, HTML, JavaScript.
• Team Foundation Server, Project management, ALM in Agile Methodology.
• DB/2, Oracle 7,8
• Electronic Transactions EDI/Flat File Formats
• Data Comparison Tools - RED Gate
• Version Control: MS SourceSafe
• Operating Systems: Windows.
• VM Ware.
• TCP/IP, DNS, FTP.

Employment History

Confidential

• Primarily responsible for design, develop, and modify data management infrastructure to expedite data analysis and reporting.
• Develop standard operating procedures for data handling and archiving.
• Design Logical Modeling and develop Physical database design using ER/Studio that is compatible with company needs.
• Implement policies and guidelines for data management.
• Involved in a database team consisting of an architect/developer, developer/DBA and various consultants and offshore developers.
• Set strategic direction and organic growth for database systems. Integrate with other IS teams NetOps, Enterprise Architecture, Enterprise Data warehouse, Business Intelligence, ERP, EDI, Application Development and Project Management.
• Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression.
• Responsible for envisioning and implementing data governance policy:
• Developed database design and ETL process for Point of Sales POS Data for various customers.
• Developed OLAP Cubes SSAS for Point of Sales Data.
• Provide technical oversight for integrating new technology or new initiatives into data standards and structures
• Maintain data management plans and operating instructions for complex business systems and architectures.
• Reorganized ETL jobs SSIS , Windows Scheduler Tasks and backups schedule to optimize utilization of maintenance window at best.
• Analysis of execution plans, Database tuning, Indexes redesign and performance improvement.
• Developed an ETL process using SSIS and DTS Packages for Data Migration from various sources like flat file, DB/2, Excel, etc., using various drivers.
• Design and developed database for Supply Chain and Brokerage Management System.
• Implementation of ALM in Agile Methodology using TFS Team Foundation Server .
• Played a Project Manager Role to manage TFS Process workflow with Team members.
• Managed offsite team members for Scrum development.
• Consolidated the diverse tooling used in SDLC from traditional MS Office based to Team Foundation Server TFS across Project Management, Development and Production Support disciplines to improvise the process management. Strong Project Management skill is accrued with TFS process Workflow.
• Used Visual Studio to write applications, ASP.NET applications, and Database Project and web services.
• Responsible for multi domain Master Data Management implementation using 3rd party software 'Kalido' MDM software business modeling suite.
• Played a Vital role with offsite and onsite members for Global IS Transformation initiative.
• Involved with HR for Workday Implementation.
• Work with business managers in corporate and field offices in redesigning line-of-business information systems and development of new systems.
• Steer corporate best-practices for DB design and administration.
• Keep track of data volume increase trends and amount of space available in order to forecast SAN space requirements. Assisting Application developers with all database related tasks.
• Involved in successful upgrade from SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2012.
• Involved in DR process and implemented a methodology for critical production servers.
• Created a Web Service to transform the data over the internet to a different vendor which uses a standardized XML messaging system.
• Involved in design, development and maintenance of IBM Info sphere CDC Software, formerly known as Data mirror for data mirroring between I-Series platform DB/2 and SQL Server.
• Involved in Hyper Roll design and development that enables business intelligence solution for delivering massive amount of data with unattainable levels of speed and business dimensions.
• Involved in syndicated data resources such as IRI, A.C. Nielsen, to create various data marts for analytical purpose by Business Development Team.
• Worked with SalesForce.com application for Supplier data.

Sr. Application Developer, App. Development

• Designed and implemented dynamic Web content and Web-server applications using HTML, XML, Web services.
• Designed and Developed Content Management System using Allaire spectra.
• Used JavaScript and Cascading Style Sheets CSS to customize graphical user interface GUI .
• Spearheaded project planning sessions with managers, business analysts and team members to analyze business requirements and outline proposed IT solutions.
• Led design reviews and provided recommendations. Incorporated security requirements into design and ensured effective workflow.
• Designed and developed various applications using ColdFusion.
• Involved in design, development of various applications like Strategic planning, Workgroups, Time Tracker, iMAPP, Online Training Registration System, Network Assistant and File Transfer System in ASP.NET and VB.NET/C .
• Involved in Database Design and Application Development for Migration of Content Management System from Allaire Spectra to ColdFusion.
• Built an Associate Search Directory for tracking personal details of an associate.
• Involved in Design, Development and Implementation of Retail Reach Online/Offline application.
• Design, development and implementation of Day news Application in English/Japanese language, which is used to share the company news daily across all associates.
• Worked with consultants for implementation of HRIS JDE Self Service.
• Involved in Design and development of public website using Dot Net Nuke.
• Designed and developed an access database for customers to upload orders to the system.
• Involved in Implementation of Share Point earlier release, Coding, Database Maintenance and Migration to 2010.
• Set up Live Link ECM System, the web based collaboration and document management system.
• Involved in Successful migration of Business Objects XIR2.
• Created SQL scripts to query SQL database and Collaborated with database administrators to design appropriate data structure.
• Interface with infrastructure group to supply application support requirements and issue resolution.
• Work with systems users to identify problems with focus on performance tuning and patches.

Confidential

Sr. Software Engineer

• Designed and implemented an E-commerce based Online Store System using COLD FUSIOM Web application Server with SQL Server 7.0. Online Store system provides user friendly store creation for merchants and flexible shopping for shoppers.
• Involved in Database Design using ERWIN 3.1 and stored procedures are developed for database transactions with good validation and error handling for various modules that is consumed by the application.
• Streamlined labor-intensive business processes by developing computer automation in SQL Server 7.0
• Worked with Visual Store Editor to Edit the Store, while the end user is in Browser mode.
• Involved in HTML page design and the Java script objects, Event Handlers were extensively used to validate user entry and keep the appropriate frames in focus as required.
• Dynamic HTML Pages is generated for Robust search technique by the Cold Fusion Tags are more efficient than the traditional CGI-BIN programs

Confidential

Programmer Analyst

• Designed and developed Market Master Game Tool for the Client American Skandia that is involved the skills of Netscape Server, NSAPI, Oracle 7.3 and Server side Java Script. Created PERL script for certain back end process that runs as part of nightly process.
• Involved in a team of five for implementation of the database in SQL Server 7.0 which involves the development of WEB Based Job match system ConsultantTV.com . The Web logic Tengah application server processes the application which is being developed in JDBC with JDBC thin connectivity to SQL Server 7.0
• Involved in Data Modeling using ER/Studio 3.0.1 for WEB Based Job match system
• Design and implementation of the database in ORACLE 8.04 for successful development of WEB Based Billing system. The Oracle Web Server was used to publish the alert, billing status summary and the subscribed product status summary information, so that these can be browsed on intranet and internet.
• Designed and developed a VB GUI for a Customer information and Client Repair history application. This application connects Oracle 8.04 using DAO Data Access Objects/ODBC Direct . Reports were generated using Crystal Reports. Modular Visual Basic functions were developed using DAO methods and MDI forms with menu controls and navigational controls were implemented for ease of use and flexibility between various functions of this application.

Confidential

Programmer Analyst

• Design and development of Customer Maintenance application for the client Royal Link Travels . A processing program is developed in PL/SQL finds out the total payable amount for the booked customer.
• Developed software for Financial Management using ORACLE and DEVELOPER 2000 for a textile group company. Various MIS Reports like Voucher Generation, ledger maintenance, and others were generated using DEVELOPER 2000.
• Designed and implemented a material resource planning system for a client and the application has various modules like Operation planning control system, which automated the work order scheduling and material procurement planning.