SUMMARY

• Over 10+ years of IT experience on using MSBI tools and MS SQL Server 2012/ 2008R 2/ 2008/ 2005/ 2000 in OLAP/OLTP environments.
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) and SQL Server data tools (SSDT).
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MSExcel spreadsheets and Power Pivot.
• Experience in creating and designing SSIS Packages for Integration and Migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS in MSBI and SSDT.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Experience in deploying SSIS packages to multiple environments using different methodologies and performing Automation of SSIS Packages using SQL Server agent and different third party automation tools.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in configuring, scheduling reports for subscriptions on timely basis using SSRS report manager.
• Experience in designing conceptual, logical and physical database models using Erwin.
• Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.
• Experience in implementing SQL Server data services (SSDS) in optimizing and for Performance tuning and using SQL Profiler.
• Experience working in Agile and Waterfall model working methodologies.
• Strong analytical and problem - solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Databases: MS-SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 11g/10g/9i Microsoft Access, SharePoint 2013/2010/2007 , Oracle SQL Server 9i/10g/11g

Programming Languages: T-SQL, PL/SQL, HTML, DHTML, XML, VB.NET, C#.Net

IDE Tools: Visual Studio .Net 2010/2008/2005

Framework: Microsoft .Net Framework 4.0/3.5/3.0

Data Modeling: Erwin, MS Visio 2010/2007/2005

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Informatica

Reporting Tools: SQL Server Reporting Services (SSRS) 2008R2\2008\2005, Crystal Reports, Business Objects, Cognos.

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), performance point server 2007.

Configuration Management Tools: JIRA, Team Foundation Server (TFS) 2012/ 2010/2008/2005

Third party tools: Tidal, Avaya, and windows Application server

Operating System: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows NT, Windows XP Professional /Standard

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. SQL Server Developer

Responsibilities:

• Worked on the integration of existing systems at Data warehouse and Application systems level.
• Data analysis of existing data base to understand the data flow and business rule applied to different data bases by SQL.
• Worked to standardizing the new architecture, data flow and documentation of the process and business flow at enterprise level.
• Participated in all phases of project including Architecture, Design discussion, Requirement gathering, Analysis, Coding, Testing, Documentation.
• Developed Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.
• Extensively used SQL for Data Analysis and to understand and documenting the data behavior within and between two companies.
• Reverse engineered existing data bases to understand the data flow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.
• Designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Worked on defining deadlines and helped team to meet the deadlines.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling jobs.
• Designed Mapping Documents and Mapping Templates in SSIS ETL Tool.
• Wrote complex SSIS packages as ETL to extract data from ERP to SQL server.
• Deployed naming standard to the Data Models at enterprise level and followed company standard for Project Documentation.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, Entity Framework and SQL.
• Designing ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert them to physical data model including capacity planning, object creation and aggregation strategies, partition strategies, Purging strategies as per new architecture.
• Working on Gap Analysis of existing warehouse models.
• Conducted meetings with the business and technical team to gather necessary analytical data requirements in JAD sessions.
• Partitioned tables based on the requirement and developed purging and archival rules.
• Designing and developing strategies for Data Conversions and Data Cleansing
• Creating Data mappings, Tech Design, loading strategies for ETL to load newly created or existing tables using SSIS.
• Created Schema objects like Indexes, Views, and Sequences, triggers.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Pre-populate the static tables in the Data warehouse.
• Responsible and Involved in Application Performance Monitoring
• Developed strategies and loading techniques for better loading and faster query performance.

Environment: SQL Server 2016, 2014, Visual Studio 2015, DTS, SSIS, SSRS, SharePoint, T-SQL, .Net framework 4.5/4.0, ASP.NET, C#, Microsoft Office, Erwin, Windows Server 2008 R2.

Confidential, Charlotte,NC

MS SQL/BI Developer

Responsibilities:

• Involved in Interacting with the user for gathering business requirements and resolving the claims for the client accounts.
• Responsible for making an analysis of transactions of the client and determining solution for settlement of the client account.
• Responsible for extracting and loading client historical data from source to SQL environment for performing various business operations using SSIS
• Having hands on experience in DR Processes including Log Shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• 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).
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working knowledge with Talend ETL tool to filter data based on end requirements.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Experience in creating SSRS reports using pie charts, bars etc for business analysis purpose.
• Experience in writing Excel macros using vb script to format the excel report.
• Responsible for designing, development and deployment of SSRS reports using SSRS report designer.
• Responsible for Scheduling reports to run daily, weekly and monthly basis using SSRS Report Manager.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Responsible for creating complex Cross tab, OLAP Cube report using Crystal Reports integrated with SSMS.
• Designed Report Templates, Bar Graphs and Pie Charts in Crystal Reports for data analysis.
• Configured OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions to business.
• Used several OBIEE reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, Security etc)
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements
• Involved in development of the application by determining standard procedures to execute from the users end.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Good understanding of the client claim terms and conditions in performing the settlement for the given securities in determining the solutions
• Responsible for creating and managingvarious database objects such as tables, stored procedures, views, UDF’s, Triggers, and Database Constraints to meet business requirements.
• Responsible for designing, development of SSIS Packages using various control flow tasks and dataflow tasks for performing ETL operations.
• Experience in deployment of SSIS packages into different environment using configurations for deployments to different environments.
• Responsible for scheduling SSIS jobs to automate the processes using SQL Server Agent.
• Responsible for performing performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels etc.
• Experience in working with CMD Utility tool to run command files.
• Responsible for implement Unit testing and performance improvement purposes.
• Responsible for creating and maintaining high-level design documentation considering future changes.

Environment: MS-SQL Server 2012/2008R2 Enterprise Manager, TOAD, MS Business intelligence 2008R2 (BIDS) SSIS, SSRS,SSAS, SharePoint Server 2010, Crystal Reports, XML, MS office 2010, MS Visio 2010, Visual Studio 2010, VB.Net, C#.Net, Windows Server 2008, SQL Server Agent, SQL CMD Utility.

Confidential, Charlotte,NC

SQL/ETL Developer

Responsibilities:

• Analyzing the business requirements and building logical and physical data models.
• Creating high level design of the ETL process.
• Implementing RDBMS concepts and good understanding of database schemas.
• Experience in creating and managingstored procedures,indexes, views, UDF’s, Database Constraints to meet business requirements and policies.
• Involved in improvement of optimized query performance by creating Indexes and implementing SSDS operations.
• Experience in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
• 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, XML 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 the packages extensively to implement in multiple environments easily using configuration
• Automated various processes by scheduling the packages using SSMS Scheduler and third party tools.
• Experience in Handling Transactional systems for performing various automated processes.
• Experience in extracting the data from SQL Server and using XML and present it to the end user in XML format.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, CrossTab Reports, Mailing Label Reports and Ad hoc reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Experience in writing Excel macro’s using VBA and delivering Excel reports to the Business analysts.
• Responsible for unit testing, Smoke Testing and creating design documents and uploading it to share point server.
• Excellent verbal and communicational skills include interacting with users for requirement gathering and problem solving skills.

Environment: MS-SQL Server 2012/2008 R2/2008 Enterprise Manager, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, MS Visual Studio 2010\2008, SharePoint Server 2010, MS Visio 2010, MS-Office 2010, XML, Windows Server 2008, TFS 2010.

Confidential, New York, NY

SQL / MSBI Developer

Responsibilities:

• Involved as a team member for requirement analysis in design phase of the Project.
• Project involved maintenance of existingOLTPdatabases as well as designing SSIS packages for custom warehousing needs.
• Experience in handling Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Experience in extracting huge data from SSAS cubes to perform various business operations.
• Experience in working with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Experience in working with different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc.
• Deployed different SSIS packages on development and test environments.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
• Involved in development and deployment of the Cube.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Linked Reports and Ad hoc reports using SSRS.
• Created Reports and integrated reports into ASP.Net Application.
• Scheduled reports to run daily, weekly and monthly based on the requirement Report Manager.
• Defined Report Layouts for formatting the report design as per the need.
• Generated test data and tested new database consistency with existing databases.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Knowledge in integration of SQL code into SAP application.
• Responsible for unit testing, SDET and creating design documents and uploading it to share point server.

Environment: Visual Studio 2010/2008, MS-SQL Server 2008R2/2008 Enterprise Manager, TOAD, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, MS Access, MS Visio 2007, SharePoint Server 2010, XML, MS Excel, C#.Net, Visual source safe, Windows Server 2008,TFS 2008.

Confidential, Glen Allen, VA

MS SQL/SSRS Developer

Responsibilities:

• Extensively involved in understanding the requirement provided by the client and analyzing the functional specification and discussing issues with business analysts.
• Working knowledge of various kinds of records (patient records, insurance data, lab records, medical records, Medicare records, Medic Aid records), and implementing rules using HIP AA constrains.
• Worked on writing T-SQL code for complex stored procedures to extract all the claims data based on the diagnosis code, member eligibility for plans.
• Worked on designing stored procedure for extracting the providers associated to NPI, SPI, DEI, TIN data provided by CMS for non-contracted providers as a part of Medicare PQRI program for finance department to generate checks.
• Also created claims detail report as a part of Medicare PQRI program to support any queries received from providers needing further explanation on bonus checks for customer service department.
• Generated Drilldown, Drill trough Cascaded, Ad-hoc reports using SSRS 2008.
• Created reports with Drop Down menus and multi-select variables as parameters which are passed to stored procedure to populate the report accordingly.
• Worked with SSIS for creating ETL jobs in migration of data from one database to other.
• Created different SSIS Packages for performing various automated tasks using controls and components elements of SSIS Package.
• Experience in Scheduling the SSIS packages for automatic process of extract transform and load (ETL).
• Worked on performance issues of the T-SQL queries and stored procedures which were early executing for more than 1 hour.
• Responsible for Unit testing of the reports before moving them for validation by the Business Analysts.
• Responsible for cleansing up database for maintenance work.

Environment: Visual Studio 2005/2008, SQL Server 2008/2005 Enterprise Edition, SharePoint Server, Microsoft Business intelligence development studio(MSBI) SSIS, SSRS, SSAS, Crystal reports 10, Oracle, Share Point Services, VB.net, and Windows Server 2003.

Confidential, Washington D.C.

Database developer

Responsibilities:

• Created databases objects using T-SQL, scripts, stored procedures views and DTS.
• Conducted GAP Analysis and Function Point Analysis to estimate the benefits of the new system v/s. the existing system
• Scheduled and, conducted meetings with client/user work group members to identify requirements, documented them in SR Specification Documents and Identified Priorities
• Designed Logical and Physical data models using ERWIN data modeling tool.
• Created complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Experience in implemented Stored Procedures and Triggers for automating tasks.
• Experience in migrating Visual source safe (VSS) repository to Team foundation server (TFS).
• Knowledge in working with SAP application.
• Generated MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Compressed data files by removing empty database pages and updating index statistics.
• Managed and monitored the system utilization.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), DB2, Microsoft Visual source Safe (VSS), SharePoint MOSS, Oracle9i, XML, ASP.Net, Windows 2003/2000, TFS.