PROFESSIONAL SUMMARY:

• A skilled software professional with 8 plus years of industry experience in design, development and implementation of business requirements with MS SQL Server 2000/20 R2 database system in client/server environment.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC).
• Prepared the Technical and Function specifications based on the project requirements.
• Expertise with Table Design, Index Design and performance Tuning. Involved in improving efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.0/7), designing and developing jobs using DataStage Designer and DataStage Director.
• Migrated jobs from development to QA to Production environments.
• Working experience in creating and scheduling process flows, jobs in UC4.
• Extensive knowledge in Tuning T SQL queries (DDL and DML) to improve the database performance and availability.
• Expert in implementing business logic and procedure in backend using complex Stored Procedures and effective Functions.
• Expert level skills in Object creation such as Tables and Views, Table Normalization, Defined Functions (UDF), User created Data Types, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Expert in extracting and transforming data using DTS Import/Export, DTS Packages, Bulk Insert and BCP.
• Proven ability in defining Query for generating drill down reports in SSRS 2005.
• Has strong Object Oriented Analysis, design and programming technical skills, ability to learn new emerging technologies and adapt quickly.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail
• Migration/ Upgrading from SQL Server 2000 to SQL Server 2005/2008.
• Experience in designing and implementing SSIS,SSRS and SSAS
• Provided after hours and 24/7 database maintenance and support.
• Interacted with End user community to understand the business requirements and in identifying data sources.
• CCNA (Cisco Certified Network Associate) 893/1000 CISCO ID: CSCO10962889

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/XP/NT/2003, Vista, DOS, LINUX.

Databases: MS SQL Server 6.5/7.0/2000/2005, Oracle 8i/9i/10g, MS Access.

Languages: C, C#, Visual Basic 2005, Visual Basic.NET, Visual Basic, SQL/T-SQL, PL-SQL, VBScript, JavaScript.

Tools: &Technologies: ASP, ASP.NET, Visual Studio 2005, Visual Studio 6.0/5.0, Oracle Developer 2000 forms and reports, VBScript, JavaScript. Enterprise Tools: MTS, MS Visual SourceSafe 6.0/2005, Oracle, AOL, LDAP, Microsoft Visio, Microsoft word, Microsoft PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

SQL Server SSIS Lead Developer

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked as with business team to gather requirements
• Designing & documenting the functional specs and preparing the technical design.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).
• Planned, designed and implemented application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
• Designed complex packages for ETL to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, OLE DB, Excel and Access to SQL Server, DB2, flat file.
• Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Deployed the packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the SQL Server database.
• Scheduled jobs using UC4 scheduler.
• Developed UC4 jobs and Process Flows in UC4 to schedule datastage jobs, .bat files with all dependencies.
• Worked on troubleshooting, performance tuning and performances monitoring for enhancement of DataStage jobs and builds across Development, QA and PROD environments.
• Migrated jobs from development to QA to Production environments.

Environment: MS SQL Server 2000/2005/2008, DB2, IBM Information Server DataStage 7.5, IBM Information Server DataStage 8.0,T-SQL, MS Excel, TFS, MS Access, Visio, Windows 7,Windows XP professional, SSIS, UC4 Scheduler.

Confidential, San Antonio, Texas

SQL Server SSRS/SSIS Lead Developer

Responsibilities:

• Worked as lead and interacted with users to gather business requirements.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data and normalized tables.
• Established Joins and created Clustered/Non-clustered Indexes where ever necessary.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Implemented various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Designed and implemented ETL processes with SSIS packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files, Text files, etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, For each loop and Sequence container, Execute SQL task, Execute Process task, Execute package task and Script task, File System task Send Mail Task. etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc and used configuration files and Environment variables for production deployment.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc).
• Extensively used variables, package configurations, logging, and exception handling processes for each ETL process.
• Generated Sub-Reports, Drill down reports, and Parameterized reports using SSRS.
• Created Tabular reports, Matrix reports, List & Chart reports, Cascading Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created many complex stored procedures/functions and used them in Reporting services directly to generate reports on the fly.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Involved in Performance tuning and Query Optimization.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Created and tuned Event Handlers, Checkpoints and logging to maintain active SSIS packages.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.

Environment: MS SQL Server 2005/2008/2008 R2 Enterprise Edition, DB2, Teradata, T-SQL, MS Excel, HTML, IIS, MS Visual Studio.Net3.0/3.5,C#, ETL,TFS, MS Access, Visio, JavaScript, Vb.Script, XP professional, Crystal reports, Progress, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, SSRS,SSIS,SSAS.

Confidential, Dublin, Ohio

SQL Server SSRS/SSIS /DBA Developer

Responsibilities:

• Involved in designing the architecture for database.
• Involved in data conversion from Sql 2000 to Sql2005/2008.
• Created new tables, wrote stored procedures for application developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Involved in importing Excel reports to Sql Server Reporting Services.
• Created and managed users, roles and groups and handled database security.
• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Experience in migrating Windows Server .
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle, Progress, DB2 and Access database, Flat files to SQL server.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Documented whole process I went through in this project along with the Estimation of work I did for the project.
• Work as part of a team and provide 7×24 supports when required.
• Do general technical trouble shooting and give consultation to development teams.
• Performed development support, document reviews, test plan, integration of the system.

Environment: MS SQL Server 2005/2008 Enterprise Edition, DB2, Teradata, T-SQL, MS Excel, HTML, IIS, MS Visual Studio.Net3.0/3.5,C#, ETL,TFS, MS Access, Visio, JavaScript, Vb.Script, XP professional, Crystal reports, Progress, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, SSRS,SSIS,SSAS.

Confidential, Houston, Texas

SQL Server/SSRS/SSIS Developer

Responsibilities:

• Created new tables, wrote stored procedures for application developers and some user defined functions.
• Performed data conversion from flat file into a normalized database structure.
• Create new SSIS package to extract date from legacy to SQL Server Objects.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Modified DTS to SSIS packaged to accomplish critical business logic.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to respective people when a SSIS process failure or success. Created alerts and generate auto e-mails.
• Created various Weekly and Monthly reports showing detailed information.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Formatted the reports using the Global variables and expressions.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Scheduled many Jobs using SQL Server Agent.
• Data migration (import & export - BCP) from Text to SQL server.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Assisted the front end application developers with their queries.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Developed Web forms, User controls and Custom controls for the web application in ASP.NET, C#, Vb.net.
• Created sub reports, bar charts and matrix reports. Extracting data from MS Access into Sql Server.
• Worked with business users, programmers, testing staff, and database administrators to develop database requirements, test plans and database schemas to transition MS ACCESS database to SQL.
• Performed system testing and debugging, creating test case and reporting the bugs.
• Deployed the reports in to the report server.
• Documented of all processes involved in maintaining the database for future .

Environment: MS SQL Server 2000/2005 Enterprise Edition, T-SQL, MS Excel, ERWIN, HTML, IIS, MS Visual Studio.Net3.0, C#, VB.net, ETL,TFS, MS Access, Asp.net 3.0,Visio,Webservices, JavaScript, Vb.Script, XP professional, Crystal reports.

Confidential, Philadelphia, Pennsylvania

SQL Server Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports.
• Created SQL Server Reports using SSRS 2005.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Responsible for transferring the data using SSIS packages.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and Data Flow Task.
• Developed Stored Procedures for schedules, reports and other client interfaces.
• Tuning Reporting services to the .net Application.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Visual Studio.Net2005, C#, Asp.net,Vb.net MS Access, Vision, VSS, SSIS, VB Script, Windows Server 2003.

Confidential, South Hattiesburg, Mississippi

MS SQL Developer/ SSRS/SSIS Developer

Responsibilities:

• Created Stored Procedures, Triggers, Views and Functions for the Application. Provided extensive testing on the Performance of the Stored Procedures.
• Imported various Sources, Targets and Transformations using transact-SQL Server.
• Developed complex T-SQL code for the application conversions.
• Wrote and integrated Stored Procedures to generate the Reports.
• Migrated the data from Oracle database to SQL server 2005 database using SSIS.
• Transferred the data from SQL Server 2000 to SQL Server 2005 database using SSIS.
• Used Query Analyzer to optimize SQL Queries.
• Created Alerts and scheduled DTS Packages to generate reports.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers and maintained Referential Integrity.
• Scheduled many Jobs using SQL Server Agent.
• Uploaded reports on to the report manager and organized them in folders.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Involved in Data Administration and Database Design. Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2000/2005 Enterprise Manager, T-SQL, DTS, SSRS, SSIS, Windows2003, Visual Basic 6.0, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created ASP.NET web forms and Class libraries containing code for business and data access Designed and created tables, views, and stored procedures in SQL Server 2000.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Documented and maintained history of changes for future .

Environment: SQL Server 2000, Query analyzer, DTS, Enterprise manager, ASP, XML, VB Script.