SUMMARY

• 7+ years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2005/2000/7 in Development, Test and Production Environments with various business domains like financial, manufacturing and health care
• Involved in all phases of Software Development Life Cycle (SDLC)
• Expert in SQL Server tools like SSAS, SSIS and SSRS of MS SQL Server 2005.
• Experienced in creating Cubes, Named Queries, Dimensions and deploying them into the analysis server by using SSAS.
• Experience in performing Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experienced in identifying KPI’s and writing MDX queries to access data from cubes,
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Expert in generating Drill Down Reports in SSRS 2005 and Generated daily, weekly and monthly reports for the managers.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Extensively involved in installation of MS SQL Server 2008/2005/2000/7.0.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, creating databases / file groups/files/transaction logs.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC)
• Experienced in Up gradation and Migration of SQL Server 2005 to SQL Server 2008.
• Experienced with Agile development methodologies such as XP and Scrum.
• Experienced with mathematical computation algorithms such as artificial intelligence, data mining, fuzzy logic, sparse matrices, linear algebra, or geometrical transformations.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

Database: MS SQL Server /2008, ORACLE

Languages: XML, ASP, Visual Basic 6.0, VB Script, HTML, C/C++, VB.NET, T-SQL

Database and ETL Tools: SQL Server Enterprise Manager, OLTP, Query Analyzer, SQL Profiler, DTS, SSAS, SSIS, ERWIN

Operating Systems: Windows XP/Server 2003/2000/NT4/98/95, Linux

Reporting Tools: Crystal Report, SSRS

Web Tools: MS FrontPage, Internet Information Server

Other tools: Microsoft Office, Adobe Photoshop 7, Adobe Illustrator

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Tx

MS SQL Server Developer

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level Documentation for the Database Design and Database Objects
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Created SSIS packages to extract data from OLTP to OLAP systems and created alerts for successful and unsuccessful completion of Scheduled Jobs. Using Upgrade Advisor analyzed and resolved all the issues encountered in migrating from SQL Server 2000 to SQL Server 2005.
• Using DTSxChange tool to convert DTS packages to SQL Server 2005 SSIS packages
• Converting and deploying of existing DTS Packages to Integration Service (SSIS) Packages over the Development, Testing and Production environments.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Configured and Maintained Report Manager and Report Server for SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.
• Involved in Debugging and Deploying reports on the production server.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes.
• Fixed issues in the existing Crystal Reports.
• Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: MS SQL Server 2005/2000, Business Intelligence Studio, SQL Server Reporting Services, SSIS, DTS, TSQL, PL/SQL, SQL Profiler, Windows XP/ NT / 2000/2003.SQL Query Analyzer, SQL Profiler.

Confidential, Birmingham, Alabama

MS SQL/ BI Developer

Responsibilities:

• Gathered Requirements from the users and checked the structure of the schema and data with the Data Modular.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed DTS packages to move data from production environment to different environments within the organization.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Migrated database from SQL server 2000 to SQL server 2005 using Bridging Scripts, Column
• Experienced in developing data access layer using C# classes and ADO.NET.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS 2005.
• Developed and maintained a combined data store for Confidential for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports as per client’s requirements using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Established backup and recovery of SQL reporting services

Environment: MS SQL Server 2005, SSRS 2005, SSIS 2005, T-SQL, C#, .NET, Visual Basic 6.0, ASP, DTS, Performance Point, Data Analyzer, Visual Studio 2005, VB Script, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2.

Confidential, Jersey City, NJ

SQL BI Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Responsible for the design and development of .Net web applications for firm's Solutions.
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
• Participated Databases Architecture and data Modoling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Reviewed and developed data models and database designs with development teams
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• In charge of converting data using SQL Server 2005 using SSIS

Environment: MS SQL Server 2005 and 2000, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Confidential, Dallas, TX

Sr SQL Server BI Developer

Responsibilities:

• Worked on ETL SSIS Development, Created packages using various transformation techniques and also created jobs that are scheduled to run daily night and thus load the Data Warehouse.
• Developed Crystal Reports using SSRS as per user requirements. Interacted with users, their inputs were taken and then developed the crystal Reports as per their need.
• Being an ETL Developer, I wrote lot of Stored Procedures and developed lot of SSIS Packages in DW environment. I was responsible for ETL jobs scheduled to run daily. I was associated with daily DW load.
• Worked on Complex Crystal Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Generated Reports in Pro Clarity tool using MDX queries, by connecting through Analysis services.
• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various data sources and thus developed Cubes.
• Created Validation Stored Procedures to make sure same number of records gets loaded from Flat Files to Database in Production.
• Worked on troubleshooting lot of Stored Procedures.
• Worked on Type-1 and Type-2 Stored Procedures in DW environment and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services.
• Bulk data migration using SSIS from flat files.
• Maintained Data Warehouse Models using ERWIN tool.
• I implemented data cleansing scripts and other data migration routines, focusing on reference data first and if the resources are available, working on other scripts in parallel.
• Developed packages utilizing import/export wizard and SSIS Package Designer to transform/load the data.
• Worked with various tasks of SSIS that include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Scheduled the SSIS packages to run at different intervals to load the data.
• Created documentation as required for operational support.
• Worked on ETL Data Warehouse environment. Created Jobs in Data stage and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.

Environment: SQL Server 20005, DBA, Crystal Reports, SSIS, SSRS, ERWin 4.0, MS Outlook, FTP, TSQL, Windows 2003

Confidential, South Birmingham, AL

SQL Server Developer

Responsibilities:

• Developed physical data models and created DDL Scripts to create database schema and database objects.
• Experienced with defining and implementing new processes, workflows, or policies within an organization.
• Managed the development and deployment of new applications, systems software, and/ or enhancements to existing applications throughout the enterprise.
• Oversaw installations, upgrades of SQL 2000, SQL 7.0 to SQL 2000.
• Involved in Database design, Creation and Maintenance of Databases.
• Designed & implemented Stored Procedures and Triggers for Automating Tasks.
• Created XML configuration files (.dtsconfig files) to dynamically alter package properties.
• Designed and implemented DTS packages to import data from Oracle and SQL Server.
• Created for key transaction tables and Inserted/Updated Log Table for each transaction using Triggers.
• Provided Disaster Recovery procedures and policies for Backup and Recovery of Databases.
• Experienced in Performance Tuning in SQL Server 2000 using SQL Profiler and Data Loading.
• Allocated Resources, Added Users and granted Permissions. Closely worked with front-end Programmers.
• Worked on database designing, logical and physical data modeling, worked on large scale data migration using BCP, DTS, SQL Scripts, Stored Procedures, Triggers, Views, etc
• Resolved Deadlocks Issues with the Database/Servers on a real time basis.

Environment: MS SQL Server 2000,DTS,MS Access, SQL Query Analyzer, TSQL,PL/SQL,SQL Profiler, Crystal Reports, Windows XP/ NT / 2000/2003, Microsoft Excel, ODBC, Oracle 8i/9i,Toad,Microsoft Visio.

Confidential, Burbank, CA

SQL Server Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
• Configuring, tuning, and optimizing SQL Server 2000.
• Modeling and architecture of the SQL Server 2000 database.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• Developed stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Performance testing on existed stored procedures, indexes, and triggers.
• Created DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Worked on DTS import and export wizard.
• Created views and stored procedures and optimized them as required by front-end developers for easier implementation.
• Job Monitoring and making sure all jobs run successfully every night.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Generated daily, weekly, monthly, quarterly and yearly Reports using crystal Reports.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Participated in testing and debugging of the system.

Environment: Windows 2000, SQL Server 2000, Oracle 9i, MS Office Access 2003

Confidential

SQL Server Developer /DBA

Responsibilities:

• Managed high-availability SQL Server environment supporting financial, business intelligence and CRM systems with load-balancing across multiple data centers.
• Managed for business continuity and disaster preparedness in all database systems in multiple sites for storm coverage.
• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Conducting root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, hardware bottlenecks or network latency.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system using diagnostic manager from Idera.
• Performance tuning, and optimization of procedures and queries.
• Responsible for the creation and maintenance of entity relationship diagrams, Meta data repository and comprehensive system documentation including everything from environment configuration information through standards, policies and procedures.
• Responsible for change control management documentation.
• Hands on work experience with Lumigent Log Explorer to get the trace of some unwanted data manipulation.
• Suggested and Implemented Third-party backup solution from Idera which reduced backup and recovery time to 50% while saving huge disk space.
• Interacted with higher management for reporting root cause analysis and suggested best practices to reduce the down time.
• 24x7 Production support.

Environment: SQL server 2000, Windows 2000 Advanced Server, Windows 2000, SQL Diagnostic Manager.