SUMMARY

• Over 8+ years of extensive experience in database design, development and administration with MS SQL Server versions 2008/2005/2000/7.0 using SSIS, SSAS, SSRS (BI Tools) in Financial, Retail, Healthcare, Insurance and Banking industries.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Proficient in Installing SQL Server 2008/2005/2000 and configuration of their tools.
• Excellent Transact - SQL/ T-SQL (DDL/DML) programming skills using complex Stored Procedures, effective functions, Views, Indexes, appropriate Triggers with optimized Performance Tuning etc.
• Good Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience with Business Inelegance Studio 2005.(SSIS/SSAS/,SSRS)
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Involved in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages implementing data warehouse concepts (OLTP & OLAP)
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema forDeveloping Cubes usingMDX in SSAS
• Expertise of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Providing customized ETL solutions using SSIS script components using VB.Net & C#
• Expertise in migration of business reports from SSRS 2005 & other report authoring tools into SSRS 2008 R2
• Worked as a SQL Server DBA in data warehouse environment; responsible for developing, support and maintenance for the ETL processes.
• Proficient in Creating Databases based on Functional Requirements and System Design.
• Extensively worked with QA, release team and developers to give the required environment.
• Strong experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS:

• MS-SQL Server 2012/2008R2/2005/2000
• SQL Server Enterprise Manager
• Query Analyzer
• Transact-SQL (T-SQL)
• MS SQL Server Reporting Services (SSRS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Services (SSIS)
• Data Transformation Services (DTS)
• SQL Server Management studio (SSMS)
• SVN
• JIRA
• ITG
• Business Intelligence Development Studio (BIDS)
• MS Access
• MS Visual Studio
• Bulk Copy Program (BCP)
• Microsoft Office
• MS Visio 2003/2007
• C
• HTML
• ASP .NET
• Crystal Report
• Erwin 7.3/4.1/4.0
• Performance Point Server
• Visual SourceSafe (VSS)

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Sr SQL Developer

Responsibilities:

• Analyze the current process flow for receiving SKU content from multiple providers as well as importing them into the backend OLTP catalog database through the application layer to the sale website 
• Analyze the associated data process objects for the existing process like stored procedures, tables, triggers, constraints, SSIS packages etc and optimize them to confirm to new architectural requirements
• Create new tables, stored procedures, constraints etc to support the newly designed process flow architecture in SQL Server 2012
• Assist in unit testing as well as performance testing of new data import and delivery processes, associated stored procedures, tables, functions to conform to business and architectural needs.
• Analyze and document existing data process flows within the various system architectures using Data-flow diagrams, ER diagrams etc in Visio for future reference and analysis
• Create and schedule jobs in SQL Server agent using SQL server objects, SSIS packages, Endeca Build scripts etc (search component)
• Assist with administrative processes like database recovery as well as removal of redundant objects like tables, stored procedures etc based on analysis
• Optimized existing stored procedures and functions to ensure backward compatibility with legacy SQL Server 2000 databases while maintaining performance objectives.
• Create business reports using their in-house tool (Webcat) for SKU content analysis
• Assist with data migration projects including documentation of existing objects supporting SKU data import process as well as changeover to new SKU ID’s
• Assist in optimizing SEO optimization logic for product placement on the web based on sales data and implementing them within the backend database using stored procedures and tables
• Authored classes and functions in .Net to parse through XML data feed for SKU content data from content providers to be called in SSIS packages
• Built Ant scripts to automate processes calling SQL server stored procedures, Endeca build scripts etc to streamline SKU ranking build process within Endeca Search component
• Optimized existing SSIS import packages to include enhanced logging, error handling mechanisms for automation and audit history
• Debug data and process issues in Production in a timely manner as required

Tools: and Technologies:Microsoft SQL Server 2008R2, Visual Studio 2008, Visual Studio 2010, Microsoft SSIS (SQL Server Integration Services), BIDS (Business Intelligence Development Studio), SSMS (SQL Server Management Studio), SQL Server 2012, SSDT (SQL Server Data Tools), ADO.NET, SVN, JIRA, Windows Server 2003, IT

Confidential, Pittsburgh, PA

SQL/BI Developer

Responsibilities:

• Translated business needs and architectural requirements into code units using various technologies like SQL Server 2008R2 and Visual C# .Net
• Wrote SQL scripts that were used to validate the sourced data, including XML on multiple parameters as specified by the business rules
• Optimized existing Stored Procedures and User-Defined functions to account for increased demands in scalability and functionality, especially for XML data as per emerging business needs
• Authored C# .Net functions and classes to pull in data from multiple sources including but not limited to custom-format flat files, web sources (using native web services) in an efficient manner using Visual Studio 2010
• Created SSIS packages to migrate customer usage attribute data from different environments and legacy databases (Oracle) to native OTS environment (Operational Transaction Store)
• Authored Reports in SSRS on sourced and calculated customer and meter usage attributes as per business requirements
• Used transforms like Derived Column Transform, Conditional Split transform, Lookup Transform, merge Transform, Fuzzy Lookup transform etc to design SSIS packages as per business needs to import data and cleanup in Data Warehouse
• Optimized SSIS packages to include logging and audit features to improve the overall business process flow and error reporting in Data Warehouse data load
• Used SSIS Script Task and Script Component transforms to import data from flat files with custom proprietary formats into OTS to load into Data Warehouse

Tools: and Technologies:Microsoft SQL Server 2008R2, Visual Studio 2008, Visual Studio 2010, Microsoft SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), BIDS (Business Intelligence Development Studio), SSMS (SQL Server Management Studio), ADO.NET, VSTO (Visual Studio Tools for Office), LINQ

Confidential, Horsham, PA

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Expertise in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Created Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Proficient in SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
• Developed complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Exceptional ability in calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance

Tools: & Technologies:Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDSMicrosoft Visual studio 2005, Windows server 2003

Confidential, New York, NY

SSIS/BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Designed SSIS Packages to transfer data from various sources like Informix Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server 2008.
• Performance tuning of complex SQL queries and Stored Procedures to increase the performance and Worked on Exception Handling.
• Developing SSIS packages for extracting the data from Staging Database, Perform the QC Rule Check and loading into the National Property Database.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008

Tools: & Technologies: MS SQL Server /2008, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential, Dallas, TX

SQL Developer/SQL Server DBA

Responsibilities:

• Configured and implemented replication OLTP databases to support disaster recovery and business continuity for the existing Backend database network for E-commerce, supplier network and other backend databases
• Performed data analysis of existing operational and customer data, data modeling and design with Microsoft Visio, implementation and importing of existing data into newly built high-performance databases in SQL Server 2008R2
• Created new Stored Procedures, Triggers, Views, User-defined Functions, Power-shell scripts in T-SQL and interfaced them with front-end ASP.net pages as well as Software applications, using C# to support E-Commerce and Supplier network, for high availability.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Generated Custom ETL scripts using SSIS 2008 R2 and develop and unit test SSIS load processes for performance check.

Tools: & Technologies:MS SQL Server 2005/2008, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential, Kansas City, MO

SQL SSIS/SSRS Developer

Responsibilities:

• Designed and Created databases, tables, views, stored procedures and triggers.
• Assisted with user management on the application front-end from a system-administration standpoint
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation
• Queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousingw worked on Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Tools: & Technologies:Microsoft SQL Server 2005, T-SQL, Windows Server 2003, SSIS, SSRS, VB Scripting, Erwin, Visual Studio 2005.

Confidential, New York City, NY

MS SQL Developer/SSIS/SSRS Develop

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Analyzed data quality, by working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP sources like MS SQL Server 2000, Oracle, Text Files, Excel and Access to OLAP with the help of MS SSIS.
• Used SSIS to manually transfer DTS packages 2000 to SSIS packages 2005 using MS SSIS 2005

Tools: & Technologies:MS SQL Server 2005, SSRS 2005, SSIS 2005, T-SQL, ETL, C#, .NET 2.0, Visual studio 2005, Erwin 4.2

Confidential

SQL Developer/Front End Developer

Responsibilities:

• Wrote complex stored procedures to process prospective customer information and balanced the processing load between front end and back end.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2000.
• Monitored query using query analyzer and tuned queries and procedures to boost database performance.
• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
• Assisted in designing and creating user Interface.
• Involved in designing, developing GUI forms.
• Involved in Database design, Data modeling and writing Stored Procedures.
• Designed database and generated customized reports.

Tools: & Technologies:ASP.NET2.0, ADO.NET, Microsoft Visual Stuidio.NET 2005, IIS V5.1, SQL, HTML,SQL Server 2000, SQL Profiler,.NET Framework 2.