SUMMARY:

• Around 8+ years of experience in Database Design, Development and maintenance of database applications on SQL Server 2000/ 2005/2008/2012 R2 in OLTP/OLAP/BI environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/ using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Experience in in transformation data from DB2 to SQL Server.
• Data migration from text files, DB2, excel files to SQL server.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SSAS
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report on SSAS Cube and using SSRS to develop Drill - down, Drill-through And Cascading reports.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

MS SQL Server 2008/2005/2000/7.0 , MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), MS SQL Server 2005/2008 Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), SQL Profiler, Enterprise Manager, Management Studio, Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2 , Microsoft Visio 10.0/11.0, T-SQL, VB.Net, C#, HTML, XML, XSL, Visual source safe 2005, MS office 2003/2007, Windows 2000/2003 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

MS SQL BI Developer SSIS/SSRS/Database

Responsibilities:

• Worked as a lead database and SQL developer, did extensive work on creating partitions on tables, creating relational databases.
• Migrated DTS packages from and to 2008 SQL Server and also modified Stored Procedures to comply with the current versions of SQL Server.
• Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
• Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
• Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.
• Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.
• Worked extensively with the Business Analyst using the Rally to create user stories based on the business requirements.
• Created and Modified Stored Procedures, Triggers, Tables, Views and also making use of Merge Statements instead of Cursors in T-SQL
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• 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.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: MS SQL Server 2008R2, Reporting Services (SSRS), Integration Services (SSIS), DB2, Microsoft Performance Point Server 2008R2, Microsoft Sharepoint Server, T-SQL, .NET, C# MS Access and Excel.

Confidential, Pittsburgh, PA

MS SQL Server T-SQL/SSIS Developer

Responsibilities:

• Worked as a lead developer and also worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Converted the Legacy system to PeopleSoft
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement
• Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.
• Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: MS SQL Server 2005/2008/2012 , MS SQL Server Integration / Reporting Services 2012 OLTP.

Confidential, Minneapolis, MN

MS SQL Server /SSRS/SSIS/SSAS

Responsibilities:

• Gather requirements and understand the specifications of wholesale access certification needs.
• Designed and built prototype for access certification challenge on the wholesale end to integrate with Enterprise access certification tool.
• Involved in design and creation of data mappings from sources like Flat files, DB2, Excel files, OLEDB and ODBC data sources which contains bulk data.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Worked as a lead developer and also worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Used SQL Server 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, and data center services.
• Managed the historical data in the data warehouse from various data sources.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.

Environment: MS SQL Server 2005/2008/2012 , Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), DB2, visual studio 2005, MS Visio 2010.

Confidential, New York, NY

MS SQL Server SSIS /SSRS Developer

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Deploying new Database objects in production environment.
• Designed new SSIS packages and deployed them.
• Performed data extraction and migration activities for populating test (or non-production) and customer databases.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Writing Stored Procedures, Triggers, cursors and creating indexes.
• Fixing Bugs and Automating jobs.
• Testing and loading the data on Development and Production.
• Created DTS Package designs for Import/Export from different servers like oracle to SQL Server.
• Managing the use of disk space, memory and connections.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Performing query plans and making sure each and every query is using appropriate indexes.
• Provided support for in-house and off-shore Development Team.

Environment: MS SQL Server 2005, MS SQL Server Integration / Analysis Services 2005, OLTP, MS Access

Confidential, Garden Grove, CA

MS SQL Developer

Responsibilities:

• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.
• Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: SQL Server 2005, MS BIDS, T-SQL, SSRS, MS Access and Excel.