SUMMARY

• Having 7+ years of experience in working with Business Intelligence and Data Warehousing applications using the Microsoft Technologies such as SSRS, SSIS, and SSAS.
• Extensive experience in constructing Complex Stored procedures, Triggers, Tables, User Defined Functions, Views, Indexes, Relational database models, Data Dictionaries, and Data Integrity.
• Expertise in database tools like SQL Server Management Studio, Enterprise Manager and SQL Server Business Intelligence Studio.
• Conversant withall phases of Software Development Life Cycle (SDLC)involving Systems Analysis, Design, Development, Implementation, and Testing with proficiency inDesigning and Documentationof SQL Server Strategies and plans.
• Involved in designing and developing more than 100+ enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on - demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in multiple Relational Database Management systems (RDBMS).
• Experience in Cube designing in Business Intelligence Development Studio using SSAS
• Created Perspective views to allow users to quickly analyze large amounts of data and show the relationship between two measures.
• Expert in ETL, Data warehousing, Operations Data Store concepts and OLAP technologies.
• DesignedSSISPackagestoextract datafromvarious data sourcessuch as Access database, Excel spreadsheet, xml files and flat files intoSQL Server2008 for furtherData AnalysisandReporting.
• Involved inData Warehousing ConceptsandData Modeling Techniqueslike Dimensional Data Modeling, Star Schema ModelingandSnow-Flake Modeling.
• Experience inPerformance Tuningof Data Warehouses including the creation of materialized views, bitmap indexes and partitions.
• Experience in generating on-demand and scheduled reports for business analysis or management decision usingSQL Server Reporting Services (SSRS).
• Strong analytical ability coupled with excellent written and verbal communication skills.
• Highly motivated, committed and a natural team player with capability to work independently, Strong analytical ability coupled with excellent written and verbal communication skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008/2012 , MySQL, Oracle 9i/10g

Operating System: Windows 2000/2003, Linux, HP-UNIX

.NET Technologies: ASP.net, C#, VB.net

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL Jobs, Replication tools, Data visualization (Composite tool).

Programming Languages: C, C++, Java

Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Script, XML, SOAP, IIS

Database Access Tech: ADO.NET, DTS

Design and Development: Visual Studio 2013/2010/2008/2005/2003 , Visual Studio 6.0

Reports: SSRS, Crystal Reports, Cognos Reporting tool, Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, IL

MS SQL Server Developer/SSRS

Responsibilities:

• Involved in designing and implementing database applications usingMS SQL Server 2008/2012and Business Intelligence (BI)tools to support transactions and business decision-making.
• Monitored performance andoptimized SQL queriesfor maximum efficiency.
• Responsible for creating reports based on the requirements usingSSRS.
• Experience in creating reports usingSSRS Report Builder 3.0
• Also involved in creating CRM Reports using Visual Studio 2010/2013.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
• Deployed the generated reports on to the server and various environments.
• Advanced extensible reporting skills, developedSQL Server reports using SSRS.
• Responsible for scheduling thesubscription reportswith the subscription report wizard.
• Designed and implemented SQL Server database objects (Complex stored procedures, functions, views and complex T-SQL/queries) to support reporting and various business processes.
• Met with various departments and end users to gather requirements for the reports and participated in testing them.
• Involved in giving demo of the created reports to the concerned department, making necessary changes, or getting the reports signed off and deploy on to the server.

Confidential, Eagan, MN

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in designing and implementing database applications usingMS SQL Server 2008/2012and Business Intelligence (BI)tools to support transactions and business decision-making.
• CreatedSSISPackages usingSSIS Designerforexport heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• DesignedETL packagesdealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations(For loop, bulk insert, Data flow, Data mining, FTP, XML tasks, etc)usingSQL Server Integration Services (SSIS).
• MigratedDTS packagestoSQL Server Integration Services (SSIS)and modified the packages accordingly using the advanced features ofSQL Server Integration Service.
• UsedPackage Configurationsto pass parent package variable values to child package variable.
• Deploying SSIS packages from various sources like bids, Management Studio, file systems etc.
• Trained and Executed Pentaho, a graphical ETL tool to load and process big data sources.
• Data Warehousing Using Data Transformation Services Package (DTS).
• Monitored performance andoptimized SQL queriesfor maximum efficiency.
• Responsible for creating reports based on the requirements usingSSRS.
• Experience in creating reports usingSSRSand worked onOLAP/OLTP environment.
• Deployed the generated reports on to the server.
• ETL process development using SSIS and DTS to load a data into a warehouse.
• Advanced extensible reporting skills, developedSQL Server reports using SSRS.
• UsedSubscriptions and Snapshotsto set upPush based Report Delivery.
• Involved in developing web pages usingASP.NETserver controls.
• Responsible for scheduling thesubscription reportswith the subscription report wizard.
• Developed stored procedures and usedSSIS2005 to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Designed and implemented SQL Server database objects (stored procedures, functions, views and complex T-SQL/queries) to support data integration (SSIS), reporting and various business processes.

Environment: MS SQL Server 2005/08/12 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), ETL, Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Enterprise Manager, MS Excel, Windows XP Professional, TFS.

Confidential, Detroit, MI

MS SQL Server Developer/ SSIS/ SSRS developer

Responsibilities:

• Work with DBA and SQL Architect to understand the existing system.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis.
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
• Optimization of queries by looking at Execution Plan for better tuning of the database.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Generated custom and parameterized reports using SSRS.
• Used SQL Server Agent for scheduling jobs and alerts.
• Provided technical guidance and support to end-users by developing documentations required.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Extensively used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Provided back-end support for functional testing, performance testing and provided testing evidence.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
• Convert existing access database process in SQL Server.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Used Serena PVCS version manager for repository and maintaining versions.
• Used Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning.
• Provided scripts to DBA for production implementation of data warehouse and several other database objects.
• Work with Business analysts to create data dictionary for end-user.

Environment: SQL Server 2012/2008, SSIS 2012/2008,SSRS 2012/2008, T-SQL, Visual studio 2008/2010, Data Analyzer, MS Access, Excel, SQL Profiler, MS Access, Erwin v7.2, Windows Server 2003

Confidential, Jersey City, NJ

MS SQL Server Developer / SSRS/SSIS Developer

Responsibilities:

• 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.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in SQL Server 2008R2 with the use of the SQL Profiler, Execution Plan, and Database Engine Tuning Wizard.
• Established backup and recovery of SQL server 2008R2 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Used Team Foundation Server (TFS) for version control, source control and reporting.

Environment: SQL Server 2008R2, SSIS 2008R2, SSRS 2008R2, Oracle 9i/10g,Team Foundation Server(TFS), T-SQL, Visual studio 2007, Data Analyzer, ETL, MS Access, Excel, SQL Profiler, MS Access, Erwin v7.2, Windows 2008 Server

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements
• Participated actively in designing the system database structure
• Performed performance tuning of stored procedures using SQL Server Profiler
• Involved in the development of custom stored procedures, functions.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Writing logic using the EDI Tool Kit to pull correct data fields, ability to interpret and implement requirements for EDI claims per carrier, testing with carriers, creating carrier specific edits, etc.
• Transmission of all EDI Claim Files - this includes ensuring files are processed and accepted, retrieving and reviewing all reports, maintaining logs, distributing reports appropriately
• Generated Reports using Data Source Views in Report Builder.
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Drill Down, Drill through, linked and sub reports using SSRS.
• Created report Model onSSASCubes as well as changing default configuration on existing Cubes.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.

Environment: SQL Server, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, SSAS.