PROFESSIONAL SUMMARY:

• 7+ years of strong experience with demonstrated success in the Database Design, development and deployment of large - scale enterprise applications.
• Broad experience with Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensive experience with development, testing, debugging, implementation, documentation and production support.
• Extensive experience in Implementation of Microsoft Business Intelligence (BI) platforms including Performance Point Server 2007 (PPS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS) in SQL Server 2005.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
• Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Experience in implementing different types of Replication models like Snapshot, Transactional and Merge Replication.
• Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes. Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance.
• Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views.
• Experience in generating Ad-Hoc, Drill down, Drill Through reports using Local and Global Variables, Expressions and Filters in SSRS.
• Used DTS/Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008/2010/2012.
• Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2008/2005 databases and scheduled them according to requirements.
• Developed several packages involving script component with .net code.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experience in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc and created various user roles (SSAS)

TECHNICAL SKILLS:

Programming Language: Teradata SQL, MSSQL, T-sql, C, C#

Databases: SQLServer2005/2008/2010/2012/2014,MSAccess,MS Excel, DB2, Teradata (V2R12, V2R6,V2R5)

Teradata Tools & Utilities: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, Erwin, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, Visual Studio .Net, ProClarity, Source Team Foundation Server (TFS), BTEQ, Multi Load, Fast Load, Fast Export,Tpump,Teradata Manager, PMON, SQL Assistant, Priority Scheduler, Visual Explain.

Web Technologies: HTML, XML, XSL

Source Control/Version Control: Rational Clear Case, PVCS

Scheduling and deployment Tools: Control-M, Remedy, Endeavor

Migration Tools: Data Mover, Gloden gate

Process/Methodologies: Waterfall, Scrum, Agile Methodology

PROFESSIONAL EXPERIENCE

Confidential, Arkansa

SQL Server Developer

Responsibilities:

• Migration of existing ETL DTS Packages to SSIS and Creation of new SSIS packages to transfer data from Oracle to SQL server using different SSIS components using configuration files, variables for deployments.
• Prepared written documentation on new and modified reports, OLAP tools or ETL programs.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Created SSIS packages to transfer data from various sources like Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.
• Created various Tabular and Matrix Reports using SSRS.
• Developed Query for generating drill down and drill through reports in SSRS.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Created linked servers for data retrieval using OLEDB data source and providers.
• Involved in creating complex SSIS packages using proper control and data flow elements.
• Created SSIS packages to load data into Data Warehouse using various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task.
• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2005 and Flat files.

Environment: Windows 2000 Advanced Server, SQL Server 2000/2005, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, Windows Performance Monitor.

Confidential, MI

SQL Server Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Used various transforms in SSIS to load data from flat files, Siebel CRM and FTP to the SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Created Data warehouse Cubes inSQL Server Analysis Service (SSAS).

Environment: SQL server 2008 on Windows 2003 server, IIS, Visual Studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, Log shipping,, Framework Manager, BIDS and SSMS .

Confidential, Germantown, MD

SQL Developer

Responsibilities:

• Involved in complete SDLC process in implementing DMCS data base.
• Migrated data from Heterogeneous data sources and legacy system to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Created packages to validate, extract, transform and load data to SQL Server using OLE DB providers from the existing diversified data sources.
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application and creating new stored procedures and SQL scripts as part of the enhancements.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Experience in working with Team Foundation Server (TFS).
• Responsible for creating the reports basing on the requirements using SSRS.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, and working in conjunction with the data warehouse architect on the development of logical data models.
• Wrote the queries for the drill down reports, parameterized reports.
• Formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server.
• Actively supported business users for change requests.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Involved in creating cubes for the Enterprise Data Warehouse (EDW).
• Created Multidimensional Cubes in Facts and Dimension Tables using SSAS.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Team Foundation Server (TFS).

Confidential, Cincinnati, Ohio

SQL Server Developer

Responsibilities:

• Installed and Configured SQL Server 2005 and also Upgraded the existing database to SQL Server 2005.
• Actively supported business users for change requests.
• Created several databases in various Development and Test server by using SQL Server 2005.
• Created several tables, views using SQL Server 2005 as well as Oracle 10g by using Toad for Oracle 9.0 / 8.6. These tables, views are created based upon the function spec.
• Generated scripts and schemes by using reverse engineering through Toad Data Modeler.
• Responsible on making weekly backup databases by using SQL Server 2005 and restore these databases in different server.
• Responsible for installation, configuration, security, maintenance, restoration of SSRS on Windows Server 2003.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 8i/9i to SQL Server 2005 by using SSIS.
• Involved in SSIS Package, DTS Import/Export for transferring data.
• Imported and exported data tables wise by using Toad for Oracle and SQL.
• Gauged the effectiveness and efficiency of existing reporting systems. Developed and implemented strategies for improving and further leveraging these reports in order to transfer/ convert existing reports to SQL Server Reporting Service.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Performed report testing and Verification as per internal reporting system requirements.Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated daily, weekly and monthly trigger based reports regarding assigned projects to designated managers and clients.
• Applied security to web server and database server that affects report server installation. Managed role-based security to reports and reporting resources.
• Responsible for back up and restoration of SQL Reporting Service.
• Provided Documentation support on SSRS 2005 as assigned.
• Implemented and documented proactive monitoring scripts for production databases.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, SSIS, Oracle 8i / 9i / 10g, Toad, Toad Data Modeler, MS Office, Windows XP/NT.

Confidential

Project and Internship

Responsibilities:

• Involved in complete software development life-cycle(SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment.
• Developed the Form Classes, Objects using C# for code-behind depending on the business logic.
• Tables, views, stored procedure were created as per design needs.
• Optimized queries tuned and monitored server performance.
• Developed, monitored and deployed SSIS packages.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Actively supported business users for change requests.
• Responsible for designing table schema relationships and building base templates for web applications in visual studio.
• Worked with complex SQL queries to test the data in the backend.
• Wrote Stored Procedures in generating Reports and retrieving data to C# applications
• Gained hand-on experience in deploying Web applications on IIS web server.
• Enhanced and modified the existing GUI to ensure the best experience for users.
• Responsible for fixing bugs, troubleshooting and resolving any errors.
• Written SQL Statements to ensure the data changes affected in Backend.
• Performed Unit Testing, Functional Testing, Integration Testing, System Testing and User Acceptance Testing.

Environment: Visual Basic 6, C#, HTML, MS SQL Server, MS Access, Query Analyzer, Excel, SQL Profiler, Import & Export Data.

Confidential

SQL Server Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval and application development.
• Wrote stored procedures for querying the data dynamically by defining parameters.
• Extensively used reporting tool (Web focus) to create reports as per user requirements.
• Created reports out of the views and developed OLAP cubes.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to MS Access, flat files and EXCEL files.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing and developing database.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Responsible for enhancements and Maintenance of the product.
• Optimized SQL statements for customer summary reports.
• Developed the data warehouse to design the business process data representation, dimensions and fact tables using SQL Analysis services.
• Extensively worked on star schema and snowflake schema.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.

Environment: SQL Server 2000 Enterprise Edition, Microsoft Analysis Services, SQL Server Reporting Services, SQL Enterprise Manager, DTS, Erwin 4.1, Windows XP, MS Access, MS Excel, HTML.