SUMMARY

• Over 8 years of experience in Database Design, Development & Support of MS SQL Server 2008R 2/2008/2005/2000 in Production and Development.
• Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications, using SQLServer 2008R 2/2008/2005/2000 , DTS, SSIS, SSAS and SSRS 2008/2005.
• Worked on all phases of data warehouse development life cycle, from gathering requirements to testing, implementation and support.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Worked with T - SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
• Proven ability in Performance Tuning, Query Optimization and Running Database.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• In depth Knowledge in ER modeling and Dimensional modeling (Star and Snowflake schema) building Dimension and Fact tables.
• Knowledge inJob Scheduling, Replication Performance tuning, Normalization /De-normalization concepts, database design methodology
• Proficient in High Level Design ofETL DTSPackage for integrating data from heterogeneous sources(Excel, CSV, Oracle, flat file, Text Format Data).
• Expertise in developing various static, dynamic, drill- through, drill- down, matrixand sub- reports with SSRS
• Experienced in SSAS Performance Tuning, Cube Partitioning, Basic MDX Scripts and formulas, Refresh Strategy and Planning.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Expert in Extracting and transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import and Export Data.
• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Expert in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Good Knowledge on creating score cards and dash boards using MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.
• Experience inperformance tuningin SSIS packages by using transformations.
• Hands on Experience with MS visio for documenting the processes.
• Excellent verbal, writing and presentation skills and the ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS

RDBMS/Databases: MS SQL Server 2000/2005/2008/2008/2012 , Oracle 10 g

Programming Languages: T-SQL,PL/SQL, C#,VB.Net, HTML, CSS, XML

Operating Systems: MS-DOS, Windows 98/NT 4.0/XP/2000/2003 Server, UNIX

Database Design Tools and Data Modeling: MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Database Tools and Utilities: SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2012

Version Control Tools: VSS, Sub version, TFS

PROFESSIONAL EXPERIENCE

Confidential, Mechanicsburg, PA

Sr. SQL Server Developer/SSIS/SSRS

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
• Created Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data
• Upgraded DTS packages to SQL Server Integration Services (SSIS)
• Created indexes to improve the performance of the queries
• Used SQL Server Integration Services (SSIS) to perform bulk insert operations from SQL Server 2008R2/2008 databases to flat files/CSV files and vice versa.
• Configure the SSIS Package for run time Parameters and Configured files as well as developing the Documents for Logging/Error Handling for SSIS Packages
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Performed job scheduling to ensure execution of certain jobs and daily updates.
• Extensively used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Created XSLT files for loading the XML data to database.
• Implemented custom error handling in SSIS packages and also worked on different methods of logging.
• Created batch files to load the data from text file to database tables.
• Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.
• Experience in creating Drill down reports, parameterized reports, cascading parameterized reports and drill through reports.
• Created ETL/SSIS packages both design and code to process data to target databases.
• Performance tuning of SSIS packages.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created technical documents for the process of executing the packages
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables.
• Experience in MS SQL Server Configuration, Performance Tuning of stored procedures, SSIS Packages, SSRS Reports.
• Involved in Project tracking using MS Project.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Fixing some of the production issues.
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to the Share Point portal.
• Enhance/modify existing reports by creating new Parameters, Formulas etc,
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
• Logged & tracked defects in JIRA and followed up to make sure they are resolved and tested in QA environment before the code released to staging and production servers
• Created adhoc reports based on the user requirements and worked on different on-demand reports.
• Developed complex SSIS packages to migrate the data from flat files to SSIS.
• Worked on source controls VSS (Visual Source Safe), Borland Star team.
• Involved in crystal report generation and also generated EXCEL based reports for business users.
• Reported and tracked the status of the bugs per project, resolved defects based on project severity of the defects using Jira for the development & QA team to prioritize.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, PPS, MS PowerPoint, MS Project, MS Access 2003, Oracle, Business Objects, SharePoint, PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007,Borland StarTeam, Build Forge, Visual SourceSafe.

Confidential, Los Angeles, CA

Sr SQL Server Developer

Responsibilities:

• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008 as SSIS Packages. creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Worked with MDX to query cube’s data.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented Complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed
• Various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Provided critical Production support when needed.
• Developed and implemented the application code in Oracle PL/SQL and T-SQL
• Completed revamping on a slow performing workflow to greater than 5 times faster and thus processing larger volume of data/reports and meeting the current SLA.
• Developed stored procedures using Oracle 9i and 10g.
• Involved in loading the data from flat file to oracle database.
• Involved in generating the keyword file from oracle database.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, PPS, MS PowerPoint, MS Project, MS Access 2003, Oracle, Business Objects, SharePoint, PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007.

Confidential, Phoenix, AZ

SQL Server Developer/SSAS/SSIS/SSRS

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Actively participated in planning of clustering activities using an Active-Passive configuration to achieve high availability.
• Monitoring execution plans to enhance the performance of the queries.
• Created complex SQL codes using Views, temporary tables, triggers and stored Procedures.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy LookUp, For Each Loop, Multi Cast, column conversion, Script Components,
• Generated Custom ETL scripts using SSIS 2005 and develops unit test SSIS load processes for performance check.
• Client presentations, instruction manual preparation and user s for new Process Improvement activities.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005)
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Worked with the Developers and QA Leads in gathering various scenario details, transaction information and for defect management.
• Developed and Deployed different types of Reports like List, Drilled Down, Matrix, and Chart and Sub Reports etc.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Deployed and Scheduled the Reports in Report Manager.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSIS, SSAS, SSRS), Enterprise manager, PPS, XML, Oracle, Pl/SQL, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Visual Studio 2008, Business Objects, SharePoint, MOSS 2007

Confidential, Simi Valley, CA

SQL Server Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Effectively communicated with the client and involved in analysis, planning, design, development, and implementation stages.
• Created Logical and Physical data models for new requirements and Involved in Dimensional Modeling withStar Schema and Snowflakeschema.
• Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS on Windows Server 2003.
• Monitored jobs and validating the source data and destination data.
• Created complex Stored Procedures for writing the SSIS package logs into a physical database table.
• Analyzing the Cobol Programs and writing the Business Requirements for the Reports and Developing SQL Stored Procedures and Reports Using SSRS2005.
• Implemented various DDL modifications and developed Script libraries for generating Tables, Views and Functions for Reports.
• Developed complex SQL Scripts for various data manipulations and validations across ETL, Reporting and OLTP systems.
• Scheduling Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
• Extensively used triggers, stored procedures with complex joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• SSRS installation and report server configuration to Support all Renders of Reports.
• Developed reports using SSRS 2005. Used table control, matrix control for cross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Creating some Score cards and Dash Board Reports Using SSRS 2008.
• Generated of Ad-Hoc reports as per the client requirements using Report Builder.
• Worked on XML and HTML content and metadata for search engine optimization (SEO) .
• Process improvement activities -- Logging clarifications via QC which led to cost reduction and more efficient way for data tracking and management.
• Created objects like tables, views, Materialized views procedures, packages using Oracle tools like PL/SQL, SQL*Plus and Handled Exceptions.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Created weekly comparison report which validates the process of ETL.
• Used Linked server for writing complex T SQL code on SQL Server to query on IBM DB2 tables.
• Created partition function, schema and file groups for fact tables.
• Review sessions for QA leads on Test Strategies / Test plans / Regression testing to optimize the coverage area including Risk management techniques.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008.
• Performing query plans and making sure each query is using appropriate indexes.
• Provided on - call 24/7 provide support.

Environment: SQL Server 2005, SSIS, SSRS,C#, VB.Net, Visual Studio 2005, ASP, ODBC, MS Excel, MS Access, Windows 2000/XP Oracle, Pl/SQL, IIS 5.0

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.