SUMMARY

• 8 Plus years of experience in IT industry as ETL and Database Developer.
• Microsoft Certified Technology Specialist with SQL Server 2005 Implementation & Maintenance
• Experienced in Database Design, Development/Maintenance/Administration on SQL Server 2000/2005/2008
• Experience in designing, developing and deploying Business Intelligence solutions using SSIS 2008/2005
• Expert in designing and implementing enterprise level ETL strategy using SSIS 2008/2005, MS DTS from heterogeneous data sources.
• Expertise in T - SQL queries, Views, Normalization, Stored procedure, Functions and Triggers.
• Experienced in creating generating Ad-hoc Reports, Scheduled Reports, Data extracts for business analysis using SQL Server Reporting Services (SSRS) and Excel.
• Implemented best practices in developing SSIS packages for better performance.
• Developing reports using SQL Server reporting services (SSRS) from a variety of data sources including analysis data cubes and external databases.
• Expert in tuning database by choosing indexes and using tools Database engine tuning advisor, SQL Profiler.
• Exposed to all phases of software development life cycle (SDLC) including in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem management and escalation procedures
• Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects
• Excellent team work spirit and capable of learning new technologies and concepts.

TECHNICAL SKILLS:

Languages: Visual Basic,C#,VB.net, C,T-SQL,PL/SQL

RDBMS: MS SQL Server 2008, 2005, 2000, MS-Access,DB2,Sybase

ETL/BI Tools: Import/Export wizard, SSIS 2005,2008, DTS

Reporting Tools: SSRS, Crystal Reports, Excel Spread Sheet

Database Tools: BIDS,SQL Server Management studio, DB2, Aqua Data, AQT

Data Modelling&Version Control Tools: Microsoft Office, Microsoft Visio, Erwin, Adobe Photoshop, Visual Source Safe, PVCS,Rational Clear case

Scheduling Tools: SQL Server Agent, Autosys,Maestro

Operating Systems: Windows XP/NT/2000/Vista, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, BRIDGEWATER, NJ

Sr SQL/ BI Developer

Environment: MS SQL Server 2005/2008, Visual Studio 2008, SSIS, DB2, Cognos. NET

Responsibilities:

• Worked with business users to understand there business needs and developed ETL process for their research and analysis requirements.
• Worked on multi terabytes Databases, datamarts and relational databases.
• Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process implementation from Initial phase, Ongoing, Deployment to Production Environment.
• Designed, built and automated SSIS packages for the initial load and Incremental loads.
• Built and created configuration files for SSIS packages to make them portable from server to server. Developed scripts/batch files/jobs for Development, QA and Production environment to run the SSIS packages as ad hoc and scheduled Jobs.
• Performed Unit testing and Integration testing of the developed SSIS Packages.
• Implemented business rules and requirements using multiple transformations like Conditional Split, Look up Transform, Derived Column and Union All. Also along with audit tracking and ETL error logging.
• Created Report Extracts for the users as per the business interface agreement documents.
• Implemented business logic using T-SQL programming and new features SQL Server 2008.
• Created Batch scripts, FTP scripts for file downloads. Worked with heterogeneous data like Mainframe files, XML, Flat/Fixed width files, Excel, CSV, SQL, DB2 and MS Access.

Confidential, NY

SQL SERVER/ETL Developer

Responsibilities:

• Enhanced the application functionality to implement the new hierarchical changes requested by the business users.
• Designed, developed and debugged Stored Procedures, User Defined Functions, and Views.
• Designed, created, configured, scheduled SSIS Packages from different sources like Flat Files, Dat Files, CSV Files and Excel Files in different environments.
• Analyzed and designed the Script Components in SSIS Packages using VB.NET.
• Designed and implemented a Promotion Process to deploy the SSIS Packages, Configuration Files on to different environments.
• Designed and implemented error handling at different levels using Stored Procedures, SQL Queries, SSIS Packages, etc to feed the down stream systems.
• Deployed and scheduled jobs using Sql server agent to get done all daily, weekly, monthly and quarterly task.
• Assigned permission to user(s), roles(s), and object. Administrated security for server’s logins (Windows and SQL Server account).
• Coordinating with the front-end .NET team and Share Point team to fix the user reported issues.

Technologies: SQL Server 2000/2005, COGNOS, .NET, SHAREPOINT

Confidential, NJ

SQLAnalyst/Developer

Responsibilities:

• Created new reports based on the requirements and enhancements in the business requirement document.
• Wrote store procedures and queries for the existing and new Custodial Agents.
• Developed SSIS packages to format the incoming text files and to further develop the monthly statement files.
• Designed and migrated all Data Transformation Services (DTS) Packages to SQL Server Integration Services (SSIS) and modified the packages accordingly.
• Reused the existing SSIS templates and made enhancements for greater functionality and performance.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server 2005 databases using SQL Server Integration Services (SSIS)
• Performed unit testing and UAT testing for all the written code using test database before moving into the production.
• Experience in writing SQL and PL/SQL scripts for backend testing finding defects and reported the defects using Share point portal

Technologies: SQL SERVER 2005/SSIS/SSRS, cold fusion, Net, Share Point 2007

Confidential, Cincinnati

SQL Server /ETL Developer

Responsibilities:

• Worked on the Data warehouse module of the project as a developer on MS SQL Server 2005/2000.
• Actively involved in designing and developing the data migration modules ( Confidential, Confidential ) dat migrates data using SSIS packages containing tasks and transformations.
• Developed SSIS Packages using xml, OLEDB, file system task in SQL SERVER Integration Services to load the ETL DATA.
• Developed stored procedures for Batch Processing, to ensure data consistency on database tables, reduced the process execution time
• Created drilled down, parameterized, ad hoc reports from data sources using SSRS reporting tools
• Creating Reports with MS Reporting Services 2005.
• Developed Report Models as per the requirements and generated Ad hoc Reports using SQL Server Reporting Services (SSRS).
• Generated Drill Through, Drill Down, and Ad hoc Reports.
• Took an active part in supporting the releases and fixed bugs and issues appropriately
• Involved in Preparing Detailed technical documents, Code Review and preparing unit test cases.

Technologies: SQL Server 2005/2000, Windows OS, .NET, MS Integration Services (SSIS), SSRS, Crystal reports

Confidential, Boston

SQL Server Developer

Responsibilities:

• Managing Extraction, Transformation and Loading (ETL) process pulling of data from various data sources using DTS, BCP applications to staging areas.
• Created appropriate database objects (stored procedures, views, triggers) for multiple project solutions
• Created end of the day and intraday reports for users daily using the reporting tools.
• Involved in creating database objects, complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins.
• Transferred Flat Files from the old system to the staging area by using BCP and then to SQL Server 2005.
• Extensively worked with FTP (file transfer protocol) for transmitting and receiving file from vendors and clients.
• Jobs were also scheduled through Auto sys jobs and corrected existing scripts of Sybase databases and in case of any errors it notify thru emails.
• Modified current database according to the business changes by adding tables and relationships to support online system.
• Created logical and physical database design, data structures, and implemented databases using Erwin.

Technologies: SQL Server 2000/2005, Query Analyzer, DTS, UNIX shell scripting, Sybase, Erwin

Confidential, Boston

SQL Server Developer

Responsibilities:

• Derive the logical and physical design of the application
• Create data model and schema objects
• Created Stored Procedures, User Defined Functions and improved efficiency by critically evaluating the code and optimized the slow running queries
• Worked on MS SQL Server tasks such as data loading, batch jobs, DTS, and Indexes
• Created DTS Package to import and export data from SQL Server to Text and Excel files.
• De-normalized some tables dat used lots of computations and joins thus improving the performance.
• Documentation of the entire system flow and guidance points for using the application

Technologies: MS Sql Server 2000, HTML, T-SQL, Windows 2000

Confidential

SQL Server Developer

Responsibilities:

• Worked on the Supply and Distribution module project as a developer on MS SQL Server 2000 (T-SQL, scripts, stored procedures and views).
• Involved in logical & physical design, development and testing of the system.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files and Access
• Maintained SQL Script for creation of Database Objects.

Technologies: SQL Server 2000, T-Sql, UNIX shell scripting, windows 2000