Database Administrator
Resume:
Shilpi Goel Phone: 571-***-****
Email: ********@*****.***
Visa Status: EAD
EXPERIENCE SUMMARY
· 7+ years of Professional IT Experience in analysis, architecture, design, development, testing and implementation of Client/Server, n-tier architecture software, web applications, and Data Warehousing Solutions using ORACLE, MS SQL Server, Business Objects and Microsoft Technologies.
· Engaged in Requirement Gathering, Analysis, Designing/Modeling, Development, Unit testing, Data Profiling/Analysis, and Source to Target mapping Document (S2T), UAT, and specification documentation.
· Extensively used SQL Server DTS & Integration Services (SSIS) Packages and Informatica for Extract, Transform, and Load (ETL) Data Warehouse technique.
· Worked extensively with Database objects like Tables, Stored-Procedures, Functions, Packages, Triggers, Indexes, and Views with Oracle, SQL Server, and DB2 databases.
· Extensive implementation of Data Modeling techniques like Super-Type/Sub-Type, Normalization and De-Normalization, Facts & Dimensions, Slowly Changing, Dimensions (SCD), Data Warehouse, and Operation Data Source (ODS).
· Experienced in Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence (BI), Reporting System.
· Created Metadata definitions from Business Rules.
· Proficient and prompt in learning and adapting to new technologies.
EDUCATION
Microsoft Certification in Database Administrator 2008
Bachelors in COMPUTER SCIENCE, SSGMCE, INDIA
Certification in ASP.NET, VB.NET from Adult and Community Education
TECHNICAL SKILLS
Business Modeling Tools: MS Visio
Data Warehouse Techniques: Dimension & Fact tables, Slowly Changing Dimensions, Normalization RDBMS: DB2, Oracle7.x/8.x/9i/10g, MS SQL SERVER 2008/2005/2000/7.0
Operating Systems: Windows 9x/NT/2k, HP UNIX.
Languages & Technologies C, PL/SQL, ASP, JavaScript, XML
Other Tools: Rational Rose, MS Office, MS Project, Clear Quest, Clear Case, SSIS, SSRS
WORK EXPERIENCE
Database Administrator/Developer: AAIAG Feb’ 09 – Jun’ 09
Responsibilities:
· Created Data workflows diagram based on requirements to analyze and conducted verification for data standardization.
· Created Physical database objects like Databases, Tables, Stored Procedure, View, Trigger, Query and, Users/Login.
· Created SSIS packages to perform ETL for data cleansing, standardizing, sourcing from Flat File and loading to target for initial load and for CDC data load.
· Create Database Dictionary with Meta Data Information.
· Did Performance analysis for Stored Procedure and Reporting queries.
· Backup & Restore databases. Created staging server and migrated databases to it, supported SSIS jobs and routine check of server logs.
· Developed reports using SSRS and also create Data Model for users to generate ad-hoc reports.
· Conducted Requirement Gathering and Analysis of the requirements for Invoicing and Time Keeping System.
Environment: MS Office 2007, SQL SERVER 2005, SSIS, SSRS
Data Modeler: Freddie Mac Feb’ 08 – Dec’ 08
Responsibilities:
· Conducted JAD sessions for Requirements gathering and analysis for data intensive projects.
· Presented and participated in Data Model reviews with other Data Architects, Data Management group and with customers (business area).
· Work in the Corporate Data Warehouse (CDW) Team.
· Design and create Logical and Physical data Models using ER/Studio and Erwin.
· Lead the efforts for Standardization of Data and Naming standards for Data Elements.
· Extract the data from different sources i.e Oracle, SQL Server, Flat file and, External website through manually and using ETL process.
· Create Data Definitions, Source to target mapping spreadsheet, Meta Data repository.
· Analyzed data for Data cleansing, standardizing, sourcing from Oracle database and loading to target for initial load and for CDC data load.
· Analyzed existing Databases made suggestions for better Standards and Performance tuning/query performance.
· Data analysis and reporting using SQL, wrote Procedures/Packages and ad-hoc queries with SQL.
· Designed, developed and executed Test Cases / Plan for various portfolio accounting & infrastructure upgrade projects.
· Presented and participated in Data Model reviews with other Data Analysts, Data Management group and with customers (business area).
· Creates physical database objects from Model to physical database like Tables, indexes, views, and triggers to DB2.
· Worked with Upstream and Downstream users.
· Resolved the Production issue.
· Also created DDL files to be deployed in production.
Environment: ER/Studio 7.6, ERWIN 4.1.4, DB2 8, ORACLE 10G, PL/SQL, Data Stage, TOAD, Rapid SQL, Clear Case, Clear Quest, SQL Server 2005.
Data Analyst: Fannie Mae Sep’ 07 – Dec’ 07
Responsibilities:
· Conducted Requirement Gathering and Analysis of the requirements to check
feasibility of the data and created Physical and Logical Data models for walkthroughs.
· Created data workflows based on requirements to aid development team analyze
and conducted verification for data standardization.
· Gathered base load rules for existing tables and created Technical mapping documents for the Mart.
· Created Requirement Traceability Matrix for requirement and testing coverage
· Monitoring and implementing New Reference Data (Product Types, Transaction Types etc) that needs to be loaded into the Data mart.
· Worked on creating base Meta data definitions for common sourcing and location.
· Translated the conceptual data models to database objects in Oracle.
· Interacted with business units to identify updated/new-mapping requirements for data profiles as the business requirements documents are updated.
Environment: MS- Visio, MS- Office Suite, SQL Server, Windows 2003 Server
WIPRO LTD Jun’ 07 – Sep’ 07
Data Analyst: Dun & Brad Street (DNB)
Responsibilities:
· Mentor Team members by helping to resolve issues or conflicts on projects prepare weekly status team meetings; evaluate team member performance including setting expectations and providing feedback, and conducting team building strategies. Ensure testing is completed within budget and time constraints.
· Interpret the Functional requirements and Design documents and develop and execute the appropriate test plans, test scripts and test cases against the software product suite.
· Attend requirements and Design meetings with the end user, Business analysts and developers.
· Report all bugs to the development team and seek resolution to the problems before signing off on the release.
· Write SQL queries for backend data validation.
· Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
· Designed, developed and executed Test Cases / Plan for various portfolio accounting & infrastructure upgrade projects.
· Helped the testing team document the system requirements and tested the system developed.
· Designed and executed SQL queries for QA testing and report / data validation.
· Set up definitions and process for test phases including Product test, integration test, system test and user acceptance test (UAT).
· Trained various users, which enabled them to submit, review and approve changes within the document.
· Functioned as the primary liaison between the business line, operations, and technical areas throughout the project cycle.
Environment: MS- Visio, MS- Office Suite, ORACLE 10G, PL/SQL, XML, SQL Server 2000, T-SQL, Stored Procedures, TOAD, ERWIN 4.1.4, Business Objects 6.5, Visual Source Safe, and Windows 2003 Server, UNIX, VS 6.0.
Lancesoft Inc, Software Engineer Oct’ 05 – Jun’ 07
Database Developer: Sprint-Nextel Corp, Reston
Responsibilities:
· Requirements management and Analysis through regular meeting and sessions with business/stakeholders.
· Documented requirements and processes, and came up with Process designs.
· Acquired user requirements and develop processes, standards, and procedures for data gathering from Ensemble system.
· Conducted JAD sessions with stakeholders in coming up with user requirements.
· Created Processes and work flow diagrams as part of architecture design.
· Performed Gap Analysis to check the compatibility of the existing Rebate system infrastructure with the new business requirements.
· Conducted Functional Requirement Specification and User Requirement Specification Analysis/reviews and walkthroughs with stakeholders.
· Get the Rebate Data weekly through FTP (file transfer protocol).
· Induced trace ability views to maintain the trace ability of the requirements. Create and update defect-tracking logs and work with developers and business users to ensure that all defects are resolved.
· Conducted Requirement gathering sessions, analysis, designing, development, unit testing, Data Profiling/Analysis, Source to Target mapping Document (S2T), UAT, and Spec documentation.
· Data analysis and reporting using SQL, wrote Procedures/Packages and ad-hoc queries with SQL.
· Designed rebate processing system to process customer rebates using shell scripts and oracle packages.
Environment:
ORACLE 10g, PL/SQL, SQL Plus 9.2, SQL Server 2000, ERWIN 4.1, TOAD, XML, Windows 2003 Server, HP UNIX, MS Excel, MS Word, MS Access.
Alex Computer Systems, Lucknow, India July’ 99 - Jan 03
Web Programmer
DEVELOPMENT OF JOB SEARCH WEBSITE - INDIA
Working as a Business Analyst the system, conducted extensive user interaction, study and development of various codes; generating algorithms and their comparisons for both user interface modules and admin modules
Responsibilities:
· Development of various modules for Job Seeker password authentication, Job seeker's search agent, Result pages of Job Search, Subscription for Monthly News Letter, Manage Resume section.
· For Employer, Registration and login, add, edit vacancies, candidate search, Result pages of Candidates, Admin.
· Admin Section for banner ads, messages, content management, manage Job seeker and employers account, and Monthly News Letter.
· Developed ASP pages for user interfaces.
· Used JavaScript coding for client side validation.
· Done Server Side scripting using VB-Script.
· Database connectivity using ADO for Insert, update and delete.
· Visual Interdev is used for creating Active Server Pages with FrontPage 2000 to create layout and HTML code.
Environment:
Windows NT, IIS4, ASP, VB Script, Java-Script, MS-SQL Server 2000
SCOOTER PARTS MANAGEMENT
Software Developer
Designed and developed parts management software that includes various user interfaces for Inventory, Order Entry, Purchasing and Accounting.
Responsibilities:
· Developed Client/server applications for Sales, Inventory Monitoring System components, sales projection, and order management, purchasing/receiving.
· Responsible for Analysis, Design, Documentation, Coding, Testing and Implementation of different modules.
· Developed various back office Application to track/maintain Orders, Shipping, Billing, and reporting.
· Responsible for the design, layout, editing, and publishing of Intranet Web Pages for documentation and support of the reports conversion project.
Environment:
ActiveServerPages3.0, VBScript, HTML, DHTML, SQL Server 2000
NEWS WEBSITE
Software Developer
News website with daily news, content update, content archive, banner ads, classified, admin section
Responsibilities:
· Analysis, Design, Development, Testing, and Implementation of various sections of the website including home page, daily news, classifieds, news flash, news archive, and opinion polls.
· Developed ASP pages for user interfaces.
· Used JavaScript coding for client side validation.
· Done Server Side scripting using VB-Script.
· Database connectivity using ADO for Insert, update and delete.
· Visual Interdev is used for creating Active Server Pages with FrontPage 2000 to create layout and HTML code.
Environment:
Windows NT, IIS4, ASP, VB Script, Java-Script MS-SQL Server 7
BOOK WAREHOUSE AUTOMATION
Computer Programmer
This package developed to automate a book warehouse. The warehouse dealt with books and stationary items, with frequent book price changes based on the fluctuations in foreign currency. This package performs daily sales, Banking Reconciliation, items in-stock/Out of stock, generation of reports for ad-hoc inventory, suggested order, end of the day sales and inventory report.
Responsibilities:
· Used Visual Basic 6.0 for application front-end development.
· Implemented the business logic using T-SQL stored procedures.
· Actively involved in database design, front-end screen design and implementation and test plans generation.
Environment:
Visual Basic 6.0, Visual Studio, Crystal Reports 6.5 and MS SQL Server 7
Contact this candidate