SUMMARY

• 8+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2/2005/200 in Production, QA and Development Environments.
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005/2008 Reporting Services (SSRS), SQL Server 2005/2008 Integration Services (SSIS) and in SQL Server 2005/2008 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
• Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Worked with Business Analysts, Web development team, and users on database solutions.

TECHNICAL SKILLS

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0, HP QC, ProClarity 6.2,SharePoint 2007, Team Foundation Server

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2000/ 2005/2008/2012 , MS Access 97/2003/2005/2008.

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008 , UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Neenah, WI

Sr. SQL Developer

Responsibilities:

• Responsible for extracting data from multiple operational and financial sources and assemble them into meaningful business intelligence
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server stored procedures within MS SQL Server environment.
• Develop and maintain complex reports, multidimensional cubes and flexible dashboards.
• Create and maintain data flow diagrams for existing and future ETL processes.
• Create and maintain detailed source-to-target ETL mapping specifications.
• Assist in the definition of the database requirements; analyze existing models and reports.
• Evaluate alternate solutions and design processes and systems which include user impact considerations, cost and benefit analysis, and processing specifications.
• Develop optimized SQL Server stored procedures, functions, and database views.
• Translate business requirements into BI application designs and solutions.
• Performance monitoring, tuning and capacity planning.
• Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio 2008 & 2005,MS Visio 2007,TortoiseSVN.

Confidential, Newark, NJ

Sr. SQL Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server .
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Executed stored procedures using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio 2008 & 2005,MS Visio 2007,TortoiseSVN.

Confidential, Chicago, IL

Sr SSRS Developer

Responsibilities:

• Conduct meeting with clients/business analysts to gather requirements for new developments or change requests.
• Developed datasets to perform reporting and created interactive Drill Down, Drill Through, Tabular, Cross Tab, Parameterized, Cascaded and Sub-reports using SSRS 2008/2005.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis and deploy OLAP cubes on Development server.
• Managed the historical data in the data warehouse from various data sources and generated various drill down, drill through, matrix and chart reports from SSAS cubes using SSRS 2008.
• Developed/modified Stored Procedures, Views for different reports and performed optimization techniques for these database objects to improve the performance.
• Responsible for fixing all the Production defects logged by the business users
• Responsible for Report Deployment, documenting changes on VSTS for each onsite delivery
• Document test cases and perform Unit testing for every change requests/new developments.
• Knowledge transfer Functional/Process flow to the new team member
• Responsible for maintaining the different report versions using Team Foundation Server (TFS)
• Extensive use of Visual Studio Team System (VSTS) for bug tracking

Environment: MS SQL Server 2008 R2/2005, BIDS 2008/2005, MS SQL Server Integrated Service (SSIS), MS SQL Server Analysis Service (SSAS), MS Visual Studio Team Suite, Team Foundation Server (TFS)

Confidential, Atlanta GA

Sr MS SQL SSRS Developer

Responsibilities:

• Implemented Complex Stored Procedures and automated them using SQL Server Agent
• Experienced using Sharepoint to enhance collaboration among the team members.
• Programmed Triggers (Instead Of and After) for Auditing Purpose
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms such as Lookup, Fuzzy grouping and Row Count Transformations and type 1 and type 2 slowly changing dimensions
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Generated country wise, region wise reports using global variables, expressions and functions using SSRS.
• Scheduled the same SSIS packages by creating the corresponding job tasks
• Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
• Defined report parameters and wrote queries and procedures for drill down and parameterized reports using SSRS.
• Created and design the multiple dimensions and fact table for business report purpose.
• Created Report Snapshots to improve the performance of SSRS
• Generated parameterized/Drilldown reports to enable/disable the parameters based on user selection in SSRS
• Regular responsibilities for updating dimensional databases
• Performance tuning, writing stored procedures, indexes

Environment: MS SQL Server 2008, T- SQL MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), VB, VB.NET, Microsoft SQL Server Analysis Services (SSAS),SQL Server Data Tools.

Confidential, Deerfield, IL

MS SQL Server Developer/ SSRS Developer

Responsibilities:

• 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.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On warning, On Pre and Post Execution, On Task Failed etc.)
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.
• Created OLAP models based on Dimensions and Facts for efficient loads of data.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.
• Implemented perspectives and KPI using calculated measures based on requirements.
• Identified and defined the datasets for Report generation.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel.

Confidential

SQL Server Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Worked on replication server and managed.
• Fine tuning of database objects and server.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Extensively wrote MDX queries for calculating measures.
• Design/ developing SSIS (ETL)/SSAS (OLAP) MDX developing components.
• Manage customer expectations by clearly documenting and maintaining project deliverables, plans, and status throughout life of the project.
• Used Report Builder for Ad-hoc reporting.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Recovering the databases from backup in disasters.
• Handled database objects with Enterprise Manager and Query Analyzer.
• Involved in developing logical and physical database using Erwin, Normalization, Dimension Modeling and Enterprise Manager.
• Debugging PL/SQL packages to troubleshoot issues.
• Worked on EJB components related to J2EE.
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Environment: SQL Server 2000/7.0, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS, Oracle 8i, MS-ACCESS
• Worked on making on the enterprise-wide use of XML applications, content management systems, taxonomies, and search engine optimization.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Java, C#, VB.Net, ASP.Net, Oracle, Pl/SQL, Enterprise manager, VBS, MSOffice & Windows 2K platform.