We provide IT Staff Augmentation Services!

Manager, Database Management Resume

Stamford, CT

OBJECTIVE

  • I Aim to enhance my data management knowledge and skills to become an expert in the field and handle the enterprise data management system to improve the organizational efficiency and growth by seeking a rewarding and challenging opportunity in SQL Database Design, Architecture, governance, data quality, data integration, data analytics and Data Modeling.

SUMMARY

  • Responsible for architecture, design, development, and maintenance of data architecture including data management, governance, quality, and standards across all core business and reporting applications.
  • Also include standards, governance, quality, architecture and design for integrations. Responsible for all aspects of the enterprise information management function, from defining the strategy to execution and managing ongoing alignment across the entire organization.
  • Responsible to manage the team, project management and resources to meet the objectives and standards to meet company’s objectives and goals.

TECHNICAL SKILLS

  • SQL Server Versions from 6.0 to 2012 including Enterprise and Data Center editions.
  • Multidimensional star - schema data modeling, Hyper Roll, RDBMS, ER/Studio, ERWin, and SQL Programming.
  • Master Data Management.
  • Technologies - XML, OLE, Stored Procedures, Triggers, Views, Telerik Controls, Use Cases, UML, Active Directory
  • Business Data Analytics, Data Mining, Data warehousing, OLAP {SSAS}, 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.

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Manager, Database Management

Responsibilities:

  • 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:
  • Develops and executes data quality strategies in line with the organization’s strategic plan and goals. Worked with executive leadership and establish data quality rules and definitions consistent with department and organizations strategies.
  • 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

Confidential

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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.

Hire Now