SUMMARY:

• Around 8 years of professional experience in development, implementation and administration of database systems using MS - SQL Server 2012/2008R2/2008/2005/2000 for both OLTP & Data Warehousing Systems applications.
• Experienced in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Well-developed skills in SQL Server Integration Services 2005/2008/2012 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, SQL Server.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Extensively used SSIS, SSAS & SSRS for various BI requirements.
• Expert in designing high level ETL architecture for overall data transfer from teh OLTP to OLAP with teh help of SSIS.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server and SQL Server Integration Services (SSIS) in MS SQL Server with .NET, Import/Export data, Bulk insert and BCP.
• Expert in SSIS script transformations and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to teh user requirement using SQL Server Reporting Services (SSRS).
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc and created various user roles (SSAS).
• Created calculated measures and dimensions members using MDX, mathematical formulas and user defined functions
• Possess detailed knowledge of aggregation using OLAP analysis services cube.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin and MS Visio.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Knowledge of developing cubes in SSAS and Analyzing Dimensions and Measures.
• Worked on SharePoint development and scheduling reports using it.
• Expert in automation of creating jobs, error reporting using Alerts, SQL Mail Agent.
• Experience in Interacting with Business users to analyze teh business process and transforming requirements into screens, performing ETL, documenting and rolling out.
• Ability to quickly adapt to new environment and work with variety of people at various levels.
• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.
• Excellent communication skills, bridging Client Interaction and Team player. Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to new technologies with teh ability to take new roles in minimum time with little training

TECHNICAL SKILLS

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

Languages: C, VB.NET, C#, VB, ASP.NET, Java, Java Script, T-SQL, PL/SQL, PHP, HTML, XML

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Tools: Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, SQL Server Management Studio, SQL Server data tools (SSDT).

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Operating Systems: Windows NT/2000/XP Pro/Vista, Windows Server 2000/2003/2008, Linux, Unix

Case Tools: MSOffice 2010/2007/2003,MSExcel 2010/2007/2003,MSOutlook 2010/2007/2003, MS Vision, SharePoint Server.

Database Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP, Bulk Insert, SSIS,SSAS,SSRS, BIDS,VSS, Crystal Reports, ERWIN.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr.SQL Server BI Developer

Responsibilities:

• Worked as a developer and acquired excellent skill in creating complex Stored Procedures, Functions, and Triggers for automating tasks, Views and complex SQL queries for applications.
• Managed and resolved design issues during development and production.
• Cleansed and transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008 by using SSIS packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS packages.
• Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from flat files to SQL Server.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Provide quality assurance/testing and analysis for deployed reports under UAT and post production deployment as per Software Development Life Cycle (SDLC) Process.
• Create Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.
• Gatheird end user requirements, developed applications and different Audit functionalities depending on teh requirement acting for both system analyst and an application developer.
• Extensively studied teh existing OLTP system(s) to create data mart and warehouse systems using teh facts, dimensions and star schema.
• Wrote user requirement documents, created technical specs and design documents.
• Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations.
• Written complex Stored Procedures using temporary tables, table variables, error handling (TRY & CATCH) methodology for data loads.
• Involved in creating teh tree view folder structure in teh application using C#.net to handle different reports.
• Involved in designing and development of Data access layer and Business access Layer for C#.Net applications using WCF Service to enable interaction with SQL server 2012
• Created and maintained logins, roles and permissions on teh SQL instances and databases and provided required privileges according to teh user's requirements.
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages.
• Involved in complex SSIS package development with Microsoft BI standards and Development strategies to pull data from various data sources such as (SQL Server, Oracle, DB2, Excel, and Flat file).
• Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates. Involved in scheduling, creating snapshots and subscriptions for teh reports (SSRS 2008R2/2012).
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts.
• Manage change control based on customer requirements to according to project work flow.
• Assisted in change/release management and deployed various packages in different lower environments.

Environment: MS SQL Server 2012/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Power Pivot, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C# .Net,Asp.Net, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Confidential, Livonia, MI

MS SQL Server /SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Actively participate in teh Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers.
• Project-manage Oracle MDM implementations for Oracle customers.
• Set Customer best practices expectations revolving around MDM.
• Advise Oracle MDM usage and design to best fit customer business process requirements
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package dat executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using Web Services Call.
• Wrote and modified various Stored Procedures used in teh application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for teh table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period of time.
• Created SSIS 2012 Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system, DSR to SQL server.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Used SQL Server Profiler to trace teh slow running queries and teh server activity.
• Actively participated in review meetings with Project Manager to ensure dat teh development of projects meet business and system requirements.
• Documented teh project work and process.

Environment: Microsoft SQL Server 2012, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2005, C#, SQL Profiler, Microsoft SharePoint 2010.

Confidential, Knoxville, TN

MS SQL Server Developer/Report Programmer and Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as CONCUR, KRONOS, and LOFTWARE.
• Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
• Involved and supported users with ITSM incidents and Change management issues.
• Implemented Service Now and Migrated data from ITSM databases to Service Now.
• Resolved issues on Concur Travel and expenses configuration issues Audit rules and Cognos reports.
• Migrated data and objects from Oracle to SQL using SSMA (SQL Server Migration Assistant).
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
• Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers.
• Migrated from ITSM to Service now with along with vendor. Customized teh application reports and worked as Service now admin.
• Upgraded SQL Databases and changed compatibility levels, configured and implemented Always On availability.
• Created Shared storage, created machine user names to resolve configuration issues in Always On availability setup.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• Provide database coding to support business applications using T-SQL.
• Experienced with Clustering setup and Active Directory in Windows 2010.
• Implemented Always on Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
• Develop new processes to facilitate import and normalization, including data file for counter parties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Created many Cascaded parameters in teh reports using MDX and T-SQL.
• Involved in Database Modeling, Database Mapping, And Normalization Using ERWIN.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among teh servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Ad hoc request and ETL related operations.
• Teh packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Supported 24X7 in production issues and User's issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2014 / 2012 / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, Visual Studio 2013/2012/2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Confidential, Woonsocket, RI

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Responsible for gathering requirements for teh database designing for teh middle office with teh Data Architect. Involved in understanding teh current system and analyzed teh overall compatibility of teh all systems with teh proposed Middle Office Database design.
• Created new database schema and tables for teh Middle Office.
• Involved in creating new and modifying teh existing stored procedures and functions.
• Cleaned teh data using SQL Server Integration Services (SSIS).
• Created reports using SQL Server Reporting Services (SSRS) as per user requirements.
• Deployed reports and configured security and subscriptions for teh reports.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Created User Defined Tables (UDT’s) and used for teh creation of stored procedures.
• Involved in creating Indexes and tuned teh performance of SQL Queries.
• Used various SSIS transformations for loading teh data into teh Middle Office tables.
• Created table driven configuration for SQL Server Integration Services (SSIS) packages.
• Designed various reports like chart, drilldown, drill through and matrix reports based in teh user requirements using SQL Server Reporting Services (SSRS).
• Developed reports in SSRS 2008 R2 and deployed reports into SharePoint Server 2010.
• Modified teh Existing SSIS Packages and added more audits and alerts in case of package failure.
• Followed agile methodology and delivering fast iterations to teh users.
• Used Visual Source Safe (VSS) to check in teh project work to maintain teh version control.
• Created various jobs using SQL Server Agent.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Extensively used SQL Server Profiler to trace teh slow running queries and teh server activity.
• Actively participated in review meetings with Project Manager to ensure dat teh development of projects meet business and system requirements.
• Created OLAP cubes on top of teh data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report Server.
• Automated and updated daily tasks on IT Service Management System (ITSM).
• Documented teh project work and process.

Environment: Microsoft SQL Server 2008R2, SQL Server2008,T-SQL, SSIS, SSRS, Embarcadero, Visual Studio 2008, SQL Server Agent, Windows server 2008, Visual Source Safe 8.0, SQL Profiler, SharePoint 2010, Team Foundation Server(TFS), ITSM 6.3.4, C#, Erwin, MS Access.