PROFESSIONAL SUMMARY:

• Over 7+ years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2005/2008/2012/2014.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Experience in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Proficient in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from DB2, AS400, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Strong ability in creating SQL server Reports using SSRS 2005/2008.
• Good knowledge in creating Report Models for building Ad hoc reports using SSRS.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down, Top N, Summary and Sub reports and formatting them.
• Proficient in handling parameterized reports and Cascade Parameterized Reports in SSRS 2005.
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS),Tableau, Informatica Power Center Designer, Performance Point Server 2007

Relational Databases: SQL Server 2016/2014/2012/2008/2005, MS Access, DB2, MS Excel

Tools and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, DTS, Informatica B2B Data ExChange, Data Transformation Studios, Microsoft Visual Source Safe, Crystal Reports9.0, MDX, Visual Studio .Net, ProClarity, DB Pro, Visual Source Team Foundation

Languages: T-SQL, PL/SQL, V.B6.0, MDX, C, C#, VB.Net.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS, UNIX, Linux

Web Technologies: HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

PROFESSIONAL EXPERIENCE:

Confidential, Wisconsin

SQL/ BI Developer

Responsibilities:

• Actively interacted with the Business Analysts and Business Users to gather, verify and validate various Business Requirements.
• Designing and developing SSIS Packages to import and export data from MS Excel, SQL Serverand Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Using Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Working on a Up-gradation Project, which involves upgrading the existing SQL 2008 SSIS packages to 2016 SSIS Packages.
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports, which take longer, time in execution with SQL Server 2008.
• CreatingSSISpackages for File Transfer from one location to the other using FTP task.
• Exposure to Informatica B2B Data Exchange that allows to support the expanding diversity of customers and partners and their data with capabilities that surpass the usual B2B solutions
• Working with the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events.
• Exposure to Informatica B2B Data Transformation that supports transformation of structured, unstructured, and semi-structured data types while complying with the multiple standards which govern the data formats.
• Designing Mappings using B2B Data Transformation Studio.
• Using Data Transformation Studio to transform unstructured to structured forms
• Using major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
• Extensively used Informatica Power Center 8.6 to extract data from various sources, which included Flat files, Sqlserver, Oracle, Ms-Access and XML.
• Extensively used Informatica Client tools-Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Working extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, Union, Normalizer, and Transaction Control.
• Developing ETL mappings industry healthcare standards.
• Involved in creating Mappings using Mapping and Session Parameters in the mappings and workflows to eliminate hard coding wherever possible.

Environment: MS SQL Server 2008, SSRS 2008, Informatica Power Center 9.6.1, Infomatica B2B, Data Transformation studio 4.0, MS Access, SSIS, Windows 8 Professional

Confidential, Wisconsin

Data Analyst

Responsibilities:

• Database Administrator, Database Programming
• Created SQL server Analysis Projects using MS SQL Server 2012
• Defined granularity with in a measure group and drill through actions
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Good knowledge in creating Drill-down, Parameterized and Sub-Reports using RDL
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases
• Migrated DTS 2008 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
• Strong Data Conversion and Analysis Skills
• Created various Tables and Views
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application
• Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes
• Extensively used joins and sub queries to simplify complex queries involving multiple tables

Environment: MS SQL Server 2008/2012/2014, SSRS 2008/2012,MS Access, SSIS, Tableau,Windows 8 Professional

Confidential, Dover, NH

Data Analyst

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Good knowledge in creating packages in both DTS and SSIS
• Created packages and scheduled it to get data from OLTP
• Proficient in creating ETL package for data conversion using various transformations tasks
• Backup and recovery of Master, MSDB and Application databases
• Rebuilding Indexes and Tables as part of performance tuning exercise
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc
• Scheduling Jobs and Alerting using SQL Server Agent
• Developed custom reports using SSRS/SQL Server BI studio
• Created custom and Ad hoc reports using SSRS
• Created reports that call Sub reports in SSRS
• Created datasets for reports using T-SQL and stored procedures
• Experience in creating different Data Layouts for the Business users depending on the requirement and providing them different Drill Down capabilities using Proclarity
• Responsible for Query optimization and Performance tuning
• Performing query plans and making sure each and every query is using appropriate useful indexes
• Developed complex SQL queries for data retrieval from various database objects including tables and views
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS 2008, SSRS 2008,C#, XML, T-SQL, SQL Server 2008, VisualStudio.NET IDE, Windows 7 Server, ASP, XML, T-SQL, MS Excel, MS Access, Visual Studio 05