SUMMARY

• Around 8 years of professional experience in analyzing, designing and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2012/2008/2005 , SQL Server Integration Services (SSIS) and Reporting Services (SSRS), Analysis Services(SSAS).
• Expertise in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.
• Hands on experience in designing the database model and maintain referenced relationships for the data integrity.
• Expert in creating Stored Procedures (Dynamic and static), effective User - Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Hands on experience with analyzing query plans, extended Stored Procedures, managing indexes to provide quick results for Applications.
• Designed SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data Analysis and Reporting.
• Ability to transform the data from the staging database and transform the data using Data Flow Tasks and worked extensively with on ETL process using SSIS Packages.
• Experience in Migration using SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Packages Migration Wizard and knowledge on Storage Management.
• Experience in using SSIS tools like Import and Export Wizard, Package installation, SSIS package Designer.
• Good Knowledge on Error handling, Performing Incremental Loads and Logging Operations using SSIS.
• Worked in OLTP & OLAP environments that include QA, Production and development, implemented and maintained database schema and Entity relationship diagrams from business requirements.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Extensive experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SSRS.
• Experience in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Proven ability in generating Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2008/2005.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Experience in working, creating Multidimensional cubes using SSAS for sales, Inventory, operational, merchandising and financial environment.
• Developed Multidimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
• Hands on Experience with Microsoft Azure.
• Worked on Bi-weekly and Monthly Reports for different Auditors using Power BI, SSRS.
• Experience in POWER BI Reports, which can be created from scratch within Power BI, can be imported with dashboards that colleagues share, or can be created when connected to datasets from Excel, Power BI Desktop, databases. worked on a variety of Healthcare data ETL loads which include Claims (both Medical and Pharmacy claims), Providers, Eligibility, HRA and Biometrics, Member-PCP links
• Excellent communication, interpersonal and organizational skills.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, VB.NET

RDBMS: MS SQL Server 2012/2008-R 2/2008/2005/2000 , MS Access 2010/2007/2003/2000/97 , Oracle 10g/9i, DB2

Query Languages: T-SQL, PL/SQL, MDX

Markup Language: XML, XSD, HTML

Utility Tools: MS Project 2000, Toad, SQL Loader, DB visualize, Rapid SQL, POWER BI, Azure

Application Software: MS Office 2010/2007/2003/2000/97 , MS Visio 2000

SQL Server Tools: Server Management Studio, Enterprise Manager, Query Analyzer, Profiler Export & Import (DTS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tableau

Operating Systems: Win 9X, Win ME, Win NT, Win XP, Win 2000, Win 2007, Win 8

PROFESSIONAL EXPERIENCE

Confidential, Hagerstown, MD

Sr. SQL BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MSSQLServer 2005 database to MSSQLServer 2012, by using Detach/Attach, Back up & Recovery.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel and Flat files.
• Implemented SSIS packages for data export/import and created maintenance procedures and deployed them to the server.
• Responsible for creating and for testing the ETL SSIS packages.
• Added indexes from the tables where we pull the data from so as to reduce the execution time of the queries.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Built Control flows and data flows for incremental data loads.
• Worked with SSIS package event handlers, property expressions.
• Created new Views, Synonyms, Stored Procedures, Functions and Triggers to accomplish the changes in the requirement.
• Successfully fixed the errors in the SSIS packages and was able to rerun the jobs from the check point files.
• Created Different Graphs and Charts for analyzing related Information using Power BI Features. (PowerQuery, PowerPivot and PowerView).
• Worked on different kinds ofTransformations like Import Column, Export Column, Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, Conditional Split, Union all, Script componentinSSISas per the client’s Requirement.
• Implemented the changes depending on the new releases into data warehouse, adding new columns, changes in the data types of the columns, new tables etc.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated complex custom Reports using SSRS 2005 as per the customer requirement.

Environment: MS SQL Server 2012/2008 R2/2005, SSIS 2008/05, SSRS 2008/05, DTS, T-SQL, SQL Server Profiler, Windows XP, SQL Server Management Studio, Windows Server 2000/2003/2008 , Query Analyzer, MS Access 2007, Azure, Power BI

Confidential, Tampa, Florida

MSBI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, and deployment.
• Involved in Physical design of database, creating and managing the database and all the database objects.
• 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 etc.
• Modified existing packages and SSRS reports as per requirements.
• Created process and work units for scheduling SSIS packages and stored procedures using APE(Automated Processing Environment) tool.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Used SQL Server Reporting services for creating, editing and scheduling various reports
• Created and maintained database objects, Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications.
• Created various reports using SQL Reporting Services.
• Developed complex reports, which are migrated from different reporting tools.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler.
• Created and wrote database objects such as tables, indexes, views, procedures, functions, triggers, SQL code with proper grants to all the users and roles.
• SQL performance tuning by modifying SQL or adding/changing indexes.
• Created and automating the regular jobs.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Integrated Stored Procedures to generate the Reports.

Environment: MS SQL Server 2008-R2, MS SQL Server 2008, MS SQL Server 2005, SSIS, SSRS, Visual Studio 2008, Rapid SQL 7.7.1, SharePoint 2010

Confidential, Hartford, Connecticut

SQL Server Developer | BI Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Designed and implemented stored Procedures and triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/Modified SQL Joins, sub - queries and T-SQL code to implement business rules.
• Loaded the data from different sources to SQL server database using SQL Server Integration Services (SSIS) 2008.
• Used the concepts of priority constraints, look up tables to validate data while dealing with SSIS.
• Developed and scheduled the SSIS packages to perform the daily ETL tasks.
• Scheduled the SSIS packages to process the cubes in order to update the data from OLTP to OLAP.
• Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
• Created, calculated measures and dimension members using multi-dimensional expression (MDX).
• Created complex reports using SSRS 2008 from the OLAP cubes for end user analysis.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Published the reports and scheduled the reports in different formats (Email, Public Folder).
• Scheduled tasks to run every day to update changes in the base tables.
• Involved in documenting the project steps and presenting to the team members.

Environment: MS SQL Server 2008, Windows 2007, SSIS, SSRS 2008, SSAS, SQL Server Profiler, MS Share Point Server.

Confidential, TAMPA, FL

SQL Server Developer

Responsibilities:

• Setting up new MS SQL Server instances and databases.
• Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Managing logins, roles, assigning rights and permissions.
• Created views to implement security.
• Involved in programming module screens like Employee, Work Assignment etc.
• Monitoring SQL Server activity through profiler.
• Query tuning and optimization through T-SQL.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database
• Designed database schema validation tool using stored procedures
• Migrating data from Access, Text file to SQL Server through DTS
• Job, Scheduling, batch, alert and E-mail notification setting.
• Tuning and optimizing queries and indexes.
• Designed reports using SSRS according to the customer requirements.

Environment: SQL Server 2000/05, SSRS, SSIS, Query Analyzer, Enterprise Manager, DTS Designer, Index Tuning Wizard, Windows XP, MS Excel, MS Access.

Confidential

SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Participating in weekly Systems and DB Meetings and updating the Project status to the Project Manager.
• Created & scheduled SSIS packages from OLTP to various data warehouses. Also Migrated SQL 2000 DTS packages to SSIS packages
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Developed Stored Procedures, Functions and Database Triggers.
• Involved in SQL Server Integration Services (SSIS).
• Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Involved in troubleshooting of existing SSIS Packages.
• Worked on SSIS Packages, changes Structure of tables and created new Columns during transformation using SSIS packages.
• Experience in SQL Server Reporting Services (SSRS).
• Developing a Report as per user requirement using MS Reporting Services
• Tuning the database servers, when the user reports that a particular region is running slow.
• Created and monitored the jobs to perform tasks such as database cleaning, backups, data loading.

Environment: MS SQL Server 7.0/2000/2005 , Windows 2000 Server, Windows NT Server, TSQL, SQL Server Query Analyzer, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS)