TECHNICAL SKILLS:

RDBMS: SQL Server 2000, 2005, 2008, R2 Oracle 8i/9i, MS Access 2005/2007, Eagle Pace

Reporting Tools: SQL Reporting services 2000/2005/2008/ R2, Active Reports, Crystal Reports 8.5/9.0, Business Objects

Schedulers: SQL Server Agent, TIDAL, AutoSys and JAMS

Version Control: Team Foundation Sever (TFS) Visual Source Safe(VSS), Harvest, Documentum

Languages: VB, VB.NET, VB Script, VBA, C, C#, Java, JavaScript, UML, XSL, SQL, FoxPro

Web Technology: ASP, ASP.NET, XML, XSLT, IIS 5.0/4.0, CSS, JRun, HTML, DHTML, Web Services

GUI Tools / IDE: Visual Studio 2005/2008/2010, Visual Studio 5.0/6.0, Visual Interdev 6.0, Data Junction 7.5/ 8.0

Project Mgt. Tools: SharePoint 2007, Rational Suite Products, Visio, Microsoft Project Manager, Visual Paradigm

Operating System: Window XP, Windows 2000 Server, Windows NT/95, Unix, DOS

Middleware: COM/DCOM/COM+, ADO.NET, ADO.NET, ODBC, Win32 API, JDBC, Active - X Controls

UML Diagrams: Use Cases, System, Sequence, Class, Collaboration and Activity Diagrams

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL Developer

• Designed, created and managed complex database models/architectures
• Created stored procedures, view, triggers, cursors, Pivot, Unpivot functions, CTE’s
• Highly qualified in SQL Server 2000/2005/2008/ R2

Confidential

Sr. Business Intelligence Developer

• Developed SSIS packages to Extract, Transform and Load data from various sources
• Integrated sources like XML, flat files, Oracle, IBM DB2, SQL Server, SharePoint
• Converted legacy DTS and SSIS packages to current SQL Server environment
• Created SSRS reports for management to make appropriate decisions

Data Modeler

• Created Conceptual/Logical/Physical data models
• Perform source data quality assessments
• Implemented various database architectures and modules
• Coordinated maintenance of development, testing, QA and production environments.

Database Administrator (DBA)

• Created database maintenance plans.
• Performance tuning, monitoring, query optimization, indexing, backup and recovery.
• Implemented process flow with ERD diagrams.
• Supported various existing applications and large databases.

Business Analyst

• Excellent analytical, interpersonal, and communication skills
• Worked with onshore and offshore teams
• Created functional and technical documents and refined them
• Created project plans and process flow diagrams.

Confidential, Atlanta, GA

Sr. Database Consultant

Responsibilities:

• Requirements: Authored and Reviewed with Stake Holders
• Upgraded applications to use 2005/2008 SQL Server
• Created and Implemented data models/architecture in SQL Server
• Created SSIS packages to Extract, Transform and Load data
• Designed ETL interfaces: Various internal/external sources
• Reports: SSRS, Business Objects
• SQL Development: stored procedures, views, tables, triggers, functions
• Used Agile methodologies
• Administrative functions: Indexing, Backup Restore, Query tuning, monitoring, optimization

Confidential, Atlanta, GA

Sr. Consultant

Responsibilities:

• Requirements: Authored and Reviewed with Stake Holders
• Created and Implemented data model/architecture in SQL Server
• Created SSIS packages to Extract, Transform and Load data
• Designed ETL interfaces: Various internal/external sources
• Reports: SSRS
• Eagle Pace: Uploaders, Exporters, Data Steward, Unique Identifiers
• SQL Development: procedures, views, tables, triggers, functions
• Used Agile methodologies
• Administrative functions: Indexing, Backup Restore, Query tuning, monitoring, optimization
• Eagle Pace: Uploaders, Exporters, Data Steward, Unique Identifiers
• SOX (Sarbanes - Oxley) compliant business logic for Audit in SSIS

Confidential, Atlanta, GA

Sr. Consultant

Responsibilities:

• Requirements: Authored and Reviewed with Stake Holders
• Created data model (logical)
• Implemented data models/architecture in SQL Server (physical data model)
• Created SSIS packages to Extract, Transform and Load data
• Designed ETL interfaces: Various internal/external sources
• Reports: SSRS
• SQL Development: procedures, views, tables, triggers, functions
• Used Agile methodologies
• Administrative functions: Indexing, Backup Restore, Query tuning, monitoring, optimization

Sr. SQL Server BI Developer

Responsibilities:

• Requirements: Authored and Reviewed with Stake Holders
• Created data model (logical)
• Implemented: Data model in SQL Server (physical data model)
• SSIS packages: Extract, Transform and Load data
• Designed ETL interfaces: Various external sources
• SSRS Reports: Drill down, Matrix, and Navigating with charts
• SQL Development: procedures, views, tables, triggers, functions
• Administrative functions: Indexing, Backup Restore, Query tuning, monitoring, optimization

Confidential, Atlanta, GA

Sr. SQL Server BI Developer

Responsibilities:

• Requirements: Authored and Reviewed with Stake Holders
• Created data model (logical)
• Implemented: Data model in SQL Server (physical data model)
• SSIS packages: Extract, Transform and Load data
• Designed ETL interfaces: Various external sources
• SSRS Reports: Drill down, Matrix, and Navigating with charts
• SQL Development: procedures, views, tables, triggers, functions
• Administrative functions: Indexing, Backup Restore, Query tuning, monitoring, optimization

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• SQL Development: procedures, views, tables, triggers, functions
• Implemented: Data model in SQL Server (physical data model)
• DTS packages: Extract, Transform and Load data
• Designed ETL interfaces: Various external sources

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• SQL Development: procedures, views, tables, triggers, functions
• Implemented: Data model in SQL Server (physical data model)
• DTS packages: Extract, Transform and Load data
• Designed ETL interfaces: Various external sources