SUMMARY

• 7+ years of strong experience wif demonstrated success in teh Database Design, development and deployment of large - scale enterprise applications.
• Broad experience wif 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 wif 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 wif T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Highly proficient in teh 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 wif Dynamic Management Views (DMV) for improving query performance.
• Monitoring and optimizing teh performance of teh 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 wif Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008/2010/2012.
• Developed ETL process using SSIS wif 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 wif .net code.
• Experience in creating SSIS packages to automate teh 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) wif 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 wif 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 wif 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: SQLServer 2005/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, Golden 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 wif users, team lead, DBAs and technical manager to fully understand teh requirements of teh 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 teh 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 teh business requirements.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked wif 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 teh 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 teh existing diversified data sources.
• Analyzed teh bottlenecks in teh stored procedures, SQL queries and tuned them for improving teh performance of teh application and creating new stored procedures and SQL scripts as part of teh 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 teh integrity
• Deployed teh 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 wif Team Foundation Server (TFS).
• Responsible for creating teh reports basing on teh requirements using SSRS.
• Identified teh database tables for defining teh queries for teh reports.
• Gathered business requirements, definition and design of teh data sourcing and data flows, data quality analysis, and working in conjunction wif teh data warehouse architect on teh development of logical data models.
• Wrote teh queries for teh drill down reports, parameterized reports.
• Formatted teh reports using teh Global variables and expressions.
• Deployed teh generated reports on to teh server.
• Actively supported business users for change requests.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Involved in creating cubes for teh 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 teh 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 teh 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 teh TEMPeffectiveness 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 dat effects 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 teh Form Classes, Objects using C# for code-behind depending on teh 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 teh database tables for defining teh queries for teh reports.
• Gathered business requirements, definition and design of teh data sourcing and data flows, data quality analysis, working in conjunction wif teh data warehouse architect on teh 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 wif complex SQL queries to test teh data in teh 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 teh existing GUI to ensure teh best experience for users.
• Responsible for fixing bugs, troubleshooting and resolving any errors.
• Written SQL Statements to ensure teh data changes effected 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 teh 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 teh data dynamically by defining parameters.
• Extensively used reporting tool (Web focus) to create reports as per user requirements.
• Created reports out of teh views and developed OLAP cubes.
• Optimized queries using SQL Profiler and performance monitors to enhance teh 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 teh jobs, data consistency and troubleshooting teh issues.
• Worked closely wif developers, end users and Administrator in designing and developing database.
• Worked wif Implementation team and closely moved wif end users to implement manufacturing solutions.
• Responsible for enhancements and Maintenance of teh product.
• Optimized SQL statements for customer summary reports.
• Developed teh data warehouse to design teh business process data representation, dimensions and fact tables using SQL Analysis services.
• Extensively worked on star schema and snowflake schema.
• Prepared teh 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.