SUMMARY

• Over 6+ years of experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments, experience as a Business Intelligence solutions using MS SQL server(2008R 2/2008/2005/2000 ) and Microsoft’s suite products ( DTS, SSIS, SSRS and SSAS) .
• Has Strong business knowledge in different domains including Logistics, Health Care Services, Financial, Insurance Industry, Human Resources.
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS)
• Very good T - SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Highly proficient in writing parameterized queries for generating reports.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Worked in OLTP & OLAP environment that includes Production and development databases in SQL Server.
• Extensive experience in designing and developing data migration systems between homogeneous and heterogeneous data sources using SQL server data extraction, transformation and loading (ETL) tools (SSIS, DTS, bulk insert, and BCP).
• Experience in working with SSIS for Data integration services. Worked with connection manager, configuration issues and validation errors. Deployed SSIS Packages in development server as well as in production server. Experience in creating and scheduling Jobs using SQL Server Agent.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, User defined data types and functions.
• Expert in Backup/Restore, Data Import/Export, Troubleshooting.
• Extensive experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Extensively used SQL Reporting Services to generate reports and deployed reports to Report Server. Wrote queries to generate reports for analysis of data. Involved in generating summary reports; Tabular, Matrix, Parameterized and Drill down using SSRS.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Expert in Dimensional Data Modeling and Cube Design in SQL Server 2008/2005 Analysis Services (SSAS) and deploying them.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS). Experience in writing MDX queries in OLAP cubes.
• SQL Server 2005 OLAP database development including Data mining, Working with changing dimensions.
• Identified and defined Key Performance indicators (KPIs)
• Expert in designing Star Schema and Snowflake schema with Facts, Dimensions, Measures and Cubes.
• Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem solving skills
• Extensive experience in database tuning, server logins and database permissions.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Business Intelligence: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Database Engine Tuning Advisor, SQL Server Surface Area Configuration, Reporting Services Configuration, MDX, Data Transformation Services (DTS), ODBC, OLAP, OLTP, BCP, SQL profiler .

RDBMS/DBMS: MS-SQL Server 2008 R 2 /2008/2005/2000 , MySQL

Design Tools: MS Visio 2003/2007,UML, SQL Server Database Designer, Erwin Data Modeler 7.2/4.1/4.0, MS Visual Studio 2008/2005, Data Base Tuning Advisor

Programming: C, C++, Visual Basic 6.0, HTML, XML, Transact-SQL ( T-SQL), PL/SQL

Operating Systems: Windows 7/ Vista/XP/ 98, Windows Server 2007/2003

Others: MS Office 2003/2007, Crystal Reports, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Memphis,TN

SSIS/Logical DBA / BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information.
• Responsible for creating database objects like table, Store Procedure, Triggers, Functions, Views etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Developed and deployed SSIS packages for ETL from OLTP, various sources to staging and staging to Data Warehouse using Lookup, Derived Columns, Condition Split, Ole DB Command, Aggregate, Slowly Changing Dimension and more.
• Designed SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Implemented calculations to aggregate physical measure.
• Modified the existing SSIS packages to meet the changes specified by the business prospective.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Scheduled jobs to run SSIS packages on daily basis.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Responsible for Monitoring and Tuning performance of SSIS packages, SSRS reports.
• Fine tuned parameterized queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled report and exported in PDF format.
• Provided documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2008 R2/2008, MS Visual Studio 2010/2008, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting service(SSRS), SQL Server Management Studio (SSMS), T-SQL, Windows 2003 Advanced Server, Erwin.

Confidential, New York, NY

MS SQL Server/BI Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2008 a using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated list report, table report, matrix report, Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled report and exported in PDF format.
• Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2008 R2/2008, MS Visual studio 2008, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting service(SSRS), SQL Server Management Studio (SSMS), T-SQL, Windows 2003 Advanced Server, Erwin.

Confidential, Boston, MA

SQL Server Developer/DBA Consultant/ BI Developer

Responsibilities:

• Continuously interacted with users to gather business requirements.
• Actively involved in designing the logical and physical architecture for Confidential database.
• Created new tables, written stored procedures for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Designed, developed and troubleshoot the SSIS packages that implement complex ETL processes in the environments.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Fuzzy Grouping, Conditional Split, Bulk Insert, merge and union all.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Created various reports by comparing the growth of employee appointment based on each quarter by using bar charts and Excel spreadsheets.
• Configured the report viewing security for various users at various levels using Report Manager.
• 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.
• Analyzed the Previous Data and predicted the forth coming Results.
• Documentation of all processes involved in maintaining the database for future .

Environment: MS SQL Server 2005/2008, Windows 2003 Advanced Server, MS SQL Server Integration Services (SSIS)2008, MS SQL server Reporting Services(SSRS), Microsoft Visual Studio 2008, SQL Server Management Studio(SSMS), MS Excel, T-SQL, MS Visio, Erwin Data Modeler, SQL Profiler.

Confidential, VA

SQL Server Developer/BI Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each Vendor system interfacing with the High Point system.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2005.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor, Execution Plan.
• Created SQL Server Database objects including Tables, Views and Indexes.
• Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.
• Created SSAS cube and set up role based security in the cube.
• Defined Testing strategies and designed Test Plans to test each system Interface output and validated output data from each Interface based on respective Test Plans.
• Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Extensively used Calculations, Variables and Drill Down for creating Business Objects reports.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Coordinated the activities of subordinates in the Interface Team and organized weekly status Meetings.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.

Environment: SQL Server 2008/2005 Enterprise Edition, MS Visual Studio 2008, Microsoft Data Transformation Services (DTS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Query Analyzer, T-SQL, Microsoft Visio, SQL Profiler, MS-Office, MS-Access, Windows 2003 Advance Server.

Confidential

SQL Server Developer/Business Intelligence Developer

Responsibilities:

• Installed SQL server 2005 on Windows 2003 servers and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, View, stored procedures, triggers.
• Tuning the indexing using the database engine tuning advisor to get better performance of query.
• Worked with Integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Handel the Packages Error using error Handling, Logging feature for log the data form packages.
• Use Check point to prevent package start form first step.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Developed an automated report subscription process using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts using SSRS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled the monthly/weekly/daily/quarterly reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.

Environment: MS SQL Server 2005/2000 Enterprise Edition, Windows 2000/2003, MS Access 2000/2003, T-SQL, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), Erwin Data Modeler, MS-Office.

Confidential

DBA Developer

Responsibilities:

• Created DTS packages to transform data from various data sources using OLE DB connection.
• Logical and Physical design of database for project on basis of user requirements.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Migrated databases from MS .
• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Developed standards and guidelines to maintain, develop and administer the SQL Server database.
• Performed database backups (operating system, flat file backups & export/import).
• Wrote complex stored procedures for the purpose of application development.
• Optimized SQL Queries using SQL Query Analyzer.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created Complex SQL Statements, Procedures both as SQL developer and Crystal reports developer.
• Enabled performance tuning using performance monitor and maintained database.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, Index tuning wizard.
• Created tables, stored procedures, views, triggers to facilitate the web application basis.

Environment: MS SQL Server 2000 Enterprise Edition, T-SQL, MS-Office, Query Analyzer, Crystal Reports.

Confidential

MS SQL Server Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Designed Database, Tables and Views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and SQL Performance Tuning.
• Helped end users with the ability to access and utilize the data stored in the data mart.
• Generated Reports and Charts using Crystal Reports.
• Tuned SQL statements (e.g. - Using Indexes) and Stored Procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assisted end users with development of complex queries.
• Involved in Implementation and Maintenance of Disaster Recovery solutions such asReplicationand Log Shipping.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, Index tuning wizard.

Environment: MS SQL Server 2000 Enterprise Edition, Access 2000, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, MS SQL Profiler, Crystal Reports .