We provide IT Staff Augmentation Services!

Module Leader Resume

CAREER SUMMARY:

  • Over 9 years of IT experience in Complete SDLC including Requirement Analysis, Design, Development, Testing and Implementation.
  • Strong Expertise in SQL Server 2005/2008 components such as SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).
  • Experience in creating databases, stored procedures, user defined functions, Cursors, views, triggers, derived tables, common table expressions (CTEs) and indexes to facilitate efficient data manipulation and data consistency.
  • Extensive experience in usingSQL ServerAgent for scheduling job to execute SSISpackage.
  • Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
  • Modified and redesigned existing database by adding tables and relationships to support online system in the development database.
  • Experience in extracting, transforming and loading (ETL) data from various sources using SSIS, SQL Server Import / Export wizard, Bulk Insert Task and Bulk Copy Program (BCP).
  • Experience in attaching Data files and Transaction log Files to the databases.
  • Experience in taking Backups and restoring Databases.
  • Strong Experience in creating Parameterized Reports using SSRS 2005/2008.
  • Experience in automating the system by creating Jobs and Maintenance plans.
  • Designed data model. Written mapping documents.
  • Optimizing SQL queries. Written technical/functional specifications.
  • Created checks and constraints to maintain data integrity.
  • Expertise in Oracle database, PL/SQL, SQL*plus, procedures.
  • Worked with one of the largest data warehousing projects in Europe.
  • Team player with excellent communication and problem solving skills.
  • Has good exposure to domains such as finance, health care and hospitality.
  • Effective interpersonal, conflict resolution skills. Team oriented, technically motivated and creative.
  • Worked closely in association with .NET application development team.

SKILL:

Databases: MS SQL Server 2005/2008, Oracle 8i/9i, MS Access, MySQL

Software/Tools: T-SQL, BCP, SQL Agent, SSIS, SSRS, SSAS, MS Visio 2003, SQL*plus, Oracle Forms, Oracle Reports, Business Objects, MS Office 2007, HP Quality Center 10.0

Operating Systems: Windows XP, Windows Server 2003, Windows NT, Windows 98

Web technologies: HTML, JavaScript, CSS, DHTML, IIS, PHP

Version Management Tools: Team Foundation Server, Visual Source Safe

Business Intelligence: Microsoft’s PerformancePoint Server 2007 (PPS)

PROFESSIONAL EXPERIENCE:

Module Leader

Confidential

Responsibilities:

  • User interactions, requirement gathering and analysis
  • Review of test specifications
  • Training and grooming of new resources
  • Designing data model

Team Member

Confidential

Responsibilities:

  • Wrote Oracle PL/SQL procedures and triggers
  • Production support in a live environment
  • Analyzed & classified defects
  • Interacted with various team members to ensure requirement clarifications and issue resolution
  • Data analysis

Hire Now