SUMMARY

• 10 Years of extensive IT experience as a Microsoft SQL Server /2008/2008 R2/2012. Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Telecomm and HealthCare.
• Expert in Analyzing, Designing, Developing, Installing, Configuring and Deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008/2012 , SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Excellent understanding of full Software Development Life Cycle (SDLC).
• Extensive experience in developing Stored Procedures, Views, Triggers, Functions, Joins, XML and Complex Queries.
• Experienced in Performance Tuning, Query Optimization and using DBCC utilities.
• Well - versed with database Installation, Configuration, Maintenance, Monitoring, Backups and Recoveries.
• Very good knowledge about performing hybrid Normalizations to minimize redundancy.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS 2005/2008/2012 .
• Good knowledge in Data migration using SSIS 2005/2008 across different databases like Oracle, MS Access and Flat Files and migration of DTS packages to SSIS packages.
• Experience in deployment of SSIS packages and SSRS Reports to UAT, DEV and Production Servers.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools such as Star Schema, Snow Flake Schema, Data-Warehousing, OLAP cubes, Partitioning and Aggregations.
• Thorough understanding of designing and developing cubes using SQL Server Analysis Services 2005/2008/2008 R2/2012 and using the advanced BI functionality of SQL Server.
• Knowledge in creating calculated measures and dimensions members using MDX, mathematical formulas and user defined functions.
• Experience in designing, maintaining & tuning various RDBMS like SQL Server, Oracle and MS-Access databases.
• Hands on Experience with Erwin, Visio and strong knowledge of Relational database modeling, dimensional database modeling concepts.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2012 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Proficient in using Global Variables, Expressions and functions for the reports and also skilled in handling sub reports in SSRS 2005/2008/2008 R2/2012.
• Worked on development, staging and production environments and used Team foundationserver and Visual Source Safe for version controls and communications.
• Team player and self-starter with very Good Communication and Analytical Skills as well as flexible to learn advancements in the IT industry.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, CSS, XML, JavaScript, ASP.NET, VB, C#

RDBMS: MS SQL Server 2012/2008/2005/2000 , MS Access.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

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

Operating Systems: UNIX, Windows Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

Tools: and Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, TN

Senior SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2008 database to MS SQL Server 2012, by using Detach/Attach, Back up & Recovery.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports and SSIS packages.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Design and implementation of stored procedures and triggers for automating tasks.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Views to reduce database complexities for the end users.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created Functions, Stored Procedures, Database Triggers
• Created checks and constraints to maintain data integrity.
• Involved in development, enhancement, testing and performance tuning of the application.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows 2007 Server, SQL Server 2012/2008, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2012/2008, OLE DB, SharePoint MOSS 2010, Crystal Reports, HTML, Sybase, Interactive SQL 9.0, DB2,, SQL Profiler, Microsoft Visio.

Confidential, Dallas, TX

Senior SQL Server BI Developer

Responsibilities:

• Actively involved in writing T-SQL Programming for implementing StoredProcedures and Functions and cursors,views for different tasks
• .Created packages using DTS andSSIS for data extraction from FlatFiles, Excel Files OLEDB to SQL Serverusing ETL Tool.
• Designed dynamic DTS and SSISPackages to transfer data crossingdifferent platforms, validate dataduring transferring, and archived datafiles for different DBMS.
• Performance Tuning the StoredProcedures used in SSIS Packages.
• Wrote Stored Procedures indesigning various SSIS packages.

  Involved in Performance tuningof ETL transformations, data validationsand stored procedures.

• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

Environment: Windows 2003 Server/XP, SQL Server 2008/2005, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, HTML.

Confidential, Pittsburgh, PA

SQL Server BI Developer

Responsibilities:

• Develop ETL Packages and Reports.
• Create tables,stored procedureswhen required.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Involved inrelational database modeling(like designing the tables, algorithmic diagrams for the input data (entity diagrams), index's etc.)
• Extensively involved in designing theSSISpackages to export data ofheterogeneous data(like XML, Excel, CSV, PGP, Flat file) source to staging tables in SQL Server Database.
• Extensively worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly-basis,file-transfersfrom one location to other.
• UsingFTPandSFTPtasks,Encryptinganddecryptingthe files usingOpen PGPtask etc.,
• Hands on experience in using different transformations likedata Conversions,lookups, derived column transformationsetc., fordata cleansingto remove unnecessary columns, eliminateredundant,inconsistent dataand unnecessary Datalike removingempty rowsusing SSIS.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Created complex package to import data into OLAP where it inserts or updates data in web server by using aC#script, and also someVB.Net scripts to convert the text files to XML and insert the data into the respective tables.
• Create Dashboards using SSRS.
• Modified different packages where the issues (likeremoving the duplicaterecords or just updating a record and disable the previous records that had different IDs for one person,) rose after the user interference.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry,performingdatabase capacity planning.
• Enhancing anddeploying the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team and other groups outside the team when issues rose in the packages.

Environment: SQL Server 2005,Enterprise Manager, Query Analyzer, SQL Profiler-SQL, Windows 2000, NET, C#, ASP.NET, Microsoft SQL Reporting Services and Integration Services, UNIX.

Confidential, Overland Park, KS

SQL Server BI Developer

Responsibilities:

• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Worked on Complex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Reports Design.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Created checks and constraints to maintain data integrity and created Complex Stored Procedures.

Environment: MS SQL Server 2005/2008, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), BIDS and Windows 2003, SharePoint (MOSS) 2007.

Confidential, Mayfield Village, OH

SQL Server BI Developer

Responsibilities:

• Extensively used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Performance tuning and optimization of Stored Procedures and Queries.
• Involved in Data Warehouse design and imported data from various sources into a Staging area and merged the data into OLTP Data Model.
• Created SSIS packages with error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis and tested them.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Defined report layouts for formatting the report design as per the needs.
• Developed reports using SSRS 2005 and used table control, matrix control for cross tab reports.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, MS Visual Studio 2005 (SSRS, SSIS, SSAS), Windows Server 2003, MS Access 2007.

Confidential

SQL Server Developer/Administrator

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Installation, configuration of MS SQL Server 2000 for development and testing purpose
• Involved in developing database objects such as triggers, constraints, indexes and views.
• Used T-SQL to build dynamic stored procedures.
• Managed Database files, transaction log and estimated space requirements.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Using joins, database links and formatted the results into reports and kept logs.
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
• Designed and implemented several complex reports and administration modules.
• Created DTS package to schedule the jobs for batch processing.
• Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

Environment: Server 2000 Enterprise Edition, T-SQL, Enterprise manager, MS Office and Windows 2000.