SUMMARY

• 6+ years of experience in IT industry performing Database Administration, Design and Development using SQL Server 2005/2008 R2/2012.
• Expertise working with SQL Server 2005/2008 R2/2012 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
• Experience in data Normalization and Data Modeling using Erwin and generating mapping documents.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL server 2008R2 Integration Services (SSIS) and SQL Server 2008R2 Reporting Services (SSRS).
• Experience with Ad - hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
• Configured and administer BPA (Business Process Automation) for designing ETL work flow and including multiple packages within the work flow
• Documenting all ETL projects and work flows by using Bi Documenter and also including supporting documents for troubleshoot for each project.
• Developing Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11.
• Working with new data quality services (DQS) in SQL 2012 as part of creating rules for data mapping and data cleansing.
• Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
• Experience in Data Migration by using side-by-side upgrade process Management.
• Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions.
• Implementing SQL Server security and Object permissions.
• Hands on experience in configuring TEMP DB with considerable MEMORY and RAID LEVELS for better performance.
• Good experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC.
• Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace and 3rd party tools.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.
• Managing Production Server and Development server for SCCM Reporting.
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Experience in Query Tuning by Using Execution Plan, query analyzer and tuning advisor.
• Good understanding and knowledge of Relational Database Management Systems RDBMS .
• Migrated DTS Packages to SSIS using various versions of SQL Server.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Experience in creating Jobs, Alerts and scheduling SSIS Packages in SQL Agent.
• Good Knowledge of Web development technologies such as HTML, XML, DHTML and Visual Studio 2008/2010.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS

• MS-SQL Server 2012/2008 R2/2008/2005
• SQL Server Enterprise Manager
• Transact-SQL (T-SQL)
• MS SQL Server Reporting Services (SSRS)
• MS SQL Server Integration Services (SSIS)
• Master Data
• DQS
• MS Access
• MS Visual Studio
• Microsoft Office
• MS Visio 2003/2007
• XML
• ASP.NET
• Crystal Report
• Erwin 9.0
• Share Point 2010
• TFS 2010/2012
• HP Quality Center (HPQC)

PROFESSIONAL EXPERIENCE

Confidential, San Antonia, TX

SQL/ BI Developer

Responsibilities:

• Extracting data from various sources like flat files (delimited, fixed width), Siebel CRM, SQL 2008R2 and load it to SQL database for further process.
• Gathered requirement from the end user and worked with ETL team in developing a work flow for various ongoing projects
• Handling most of independent packages as well projects and troubleshooting it in case of any failure.
• Good exposure of SQL Server Management Studio for writing queries and comparing the result with SQL audit tables.
• Developed various subprograms, procedures, packages, functions, database triggers and DDL, DML complex queries in T-SQL.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Configuring and administering BPA (Business Process Automation) for designing ETL work flow and including multiple packages within the work flow.
• Administrating the CRM data projects and deliver the data to vendor for further analysis and development.
• Documenting all ETL projects and work flows by using BI Documenter and also including supporting documents for troubleshoot for each project.
• Creating a template for the projects and making sure that following the same template across the project for better view and knowing.
• Supporting data modeler for the design prospect and help them to review it.
• Handling status call for every week and noting the work done and ongoing for the team.
• Created and maintaining audit for all the projects to store the execution logs in SQL database with insert, update and delete records.
• Developing Data warehouse solution for customer & marketing analytics group data and designing the ETL data flows to load history tables.
• Configuring and maintaining reporting services for ad-hoc reporting and report models for the users.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.

Environment: MS SQL Server 2008R2/2012, SQL server integration services 2008R2/2012, SSRS 2008R2/2012, TFS, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL, Erwin 9.0, Report Builder 2.0/3.0,Siebel CRM, BPA (Business Process Automation).

Confidential, Atlanta, GA

SQL/BI Developer

Responsibilities:

• Closely worked with business users for gathering requirements and conducting a weekly meeting for BI team.
• Worked with Data modelers to create physical and logical models by using ERWIN.
• Developed DDL script using ERWIN and implemented rollout data models to design further SQL development.
• Creating test cases to implement the changes to QA and PROD for new ETL development and existing ETL packages.
• Extracting data from I series (AS 400), SQL 2005 and flat files using SSIS and performing all necessary procedures for data cleansing.
• Maintaining Landing zone and staging zone for data dumping.
• Performed intensive data quality on various data migration and written various post scripts to perform data correction.
• Used various tasks like fuzzy lookup, for each loop, file system task for data cleansing and automate the process.
• Documented all ETL packages and applying versioning with other changes.
• Also created supporting documents for future failures. Worked on multiple projects for ETL development and system integration for new environment.
• Provide resolution and escalation of tickets assigned to Data Management group using Remedy force.
• Worked with TFS 2012 for check in, check out and deploying packages to QA and PROD.
• Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
• Multiple views were created to reduce the complexity of writing procedures and increase database performance.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW) and offshore team management.
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Configuring and administering MDM services for direct client access.
• Hands on experience using DQS services and DQS task for Data Cleansing and creating rules for business.
• Highly skilled in developing Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11.
• Good exposure on Cognos 10.1 report studio and Framework manager.

Environment: MS SQL Server 2008R2/2012, SQL server integration services 2008R2/2012, SQL server Reporting Services 2008R2/2012, TFS, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL, AS 400, MS Access, Erwin 9.0, Report Builder 2.0/3.0, SEQUEL Viewpoint, System I Navigator, TFS 2010.

Confidential, Strongsville, OH

SSIS/SSRS Developer

Responsibilities:

• Involved in gathering requirements for Database creation, scheduling status review meetings, documents and code review.
• Good exposure in creating and managing conceptual, physical and logical data models.
• Createddata mapping and sourcing documents for various sources to NPS (New App).
• Involved in designing and implementing relational database (RDBMS) model as per business needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server 2012 integration services.
• Extracting data from IMS/DB2, MS Access, and SQL Server 2005/2008 for migration and performing various transformations in SSIS (ETL) per business rules.
• Configured integration services 2012 and reporting services 2012 for developing new environment for NPS systems (New Application).
• Converted existing DTS packages to SSIS (ETL) and tune the connections pointing towards new applications.
• Conducting a meeting with BSA to gathering more information on work flow for data migration and to understand new terminology for new application.
• Used change data capture (CDC) to simplify ETL in data warehouse applications.
• Experience in creating jobs, alerts, SQL mail agent and schedule SSIS (ETL) packages.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.
• Experience Type 1 SCD and Type 2 SCD mappings to update slowly changing dimension tables.
• Experience pulling data from SSAS cube and developing and maintaining cubes.
• Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services (SSRS).
• Performs System testing for all the modules and helps business in User Acceptance Testing.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.
• Well Experience in using tools like SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.
• Coordinating with offshore team for on time delivery of products and query resolution activities.

Environment: MS SQL Server 2005/2008 R2/2012, SQL server integration services 2008 R2/2012, SQL server Reporting Services 2008 R2/2012, TFS, Microsoft Visual Studio 2010/2012, SQL Server Management Studio, MS Excel, T-SQL, DB2 Mainframe, MS Access, Erwin 9.0, Report Builder 2.0/3.0.

Confidential, Portland, TX

SSIS/SSRS Developer

Responsibilities:

• Extract Transform Load (ETL) development using SQL Server 2005, SQL server 2008R2 Integration Services (SSIS) and SQL Server 2008R2 Reporting Services (SSRS).
• Captured Plan information for heavy, slow-running, and poorly performing T-SQL in SQL Sentry Performance advisor to providing a record of all plan changes and optimizing query based on results.
• Developed and maintained ETL packages (SSIS Packages) to extract the data from various sources and involved in debugging and upgrading of several ETL structures as per the requirements.
• Build Development Server for Reporting and creating SCCM Reports Based on infrastructure needs.
• Publishing Reports on Reporting Server and Share point portal.
• Managing Production Server and Development server for SCCM Reporting.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS.
• Formatted the reports using the Global variables and expressions. Managed security by defining roles and rights.
• Manages the implementation and support of SQL Server 2008R2 and SCCM across multiple applications.
• Experience in data migration (using tools like DTS, Bulk Insert, BCP and Replication) between different homogeneous and heterogeneous systems and SQL Server.
• Working knowledge of disaster recovery and high availability solution like replication, transaction log shipping, mirroring and clustering.
• Monitored the database server performance and if required go for tuning of the T-SQL queries, stored procedures etc. Proven ability to handle database of more than 500 GB in size.
• Conducted root cause and analysis for database incidents and problems. Provide 2nd and 3rd level support and rotating on-call support.
• Monitored data activities (i.e. database status, logs, space utilization, extents, checkpoints, locks and long transactions).
• Developed and maintained scripts, utility jobs or implement needed software for database maintenance.

Environment: MS SQL Server 2008 R2, SQL server integration services 2008 R2, SQL server Reporting Services 2008 R2, TFS, .NET Framework, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL, SCCM 2007 Console, SQL Sentry Power Suite (Performance Advisor for SQL), Report Builder 2.0/3.0.

Confidential, Simi Valley, CA

MS SQL/BI Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Worked in Active passive cluster environment. Used log shipping for synchronization of databases. Update statistics, database integrity check and Backup operations
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Migrating databases from legacy system to SQL server and involving in rewrite codes and validate after migration.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Developed T-SQL for maintaining, developing and creating database and fine tune Stored Procedures and Queries to improve performance of system.
• Proficient in creating and tuning database, developing views and having good exposure of C# and .NET Framework.
• Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.
• Developed, monitored and deployed SSIS packages and user Defined Functions for giving Scores and views for the application.
• Generated reports from SSRS (SQL server reporting services) and SSAS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.

Environment: MSSQL Server 2005/2008 R2, SSRS, SSIS, SSAS, DB2/UDB 9.5, .NET Framework, C#, ASP.NET, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access.

Confidential

SQL Developer

Responsibilities:

• Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2008 and Defined the report layout and identified datasets for the report generation.
• Created different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.
• Design and created financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as stored procedures, triggers, functions, indexes and views.
• Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a version control.

Environment: MS SQL Server 2005/2008, SQL server integration services 2008, SQL server Reporting Services 2008, VSS(visual source safe), .NET Framework, ASP 3.0, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL,ERWIN