SUMMARY:

• Over 8+ 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.
• Good knowledge of SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports, ad - hoc reports and Crystal Reports with thorough knowledge of report service architecture. (Table, chart and matrix report) using SSRS.
• 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 creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in configuring, scheduling reports for subscriptions on timely basis using SSRS report manager.
• Strong understanding of relational database theory including OLAP and OLTP database design.
• Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data
• Knowledge on SSAS multi-dimensional model in creating cubes and dimensions, measures, KPI’s and import and export data into a cube.
• Experience in creation of Tabular model in SSAS for creating Power pivots, PowerView reports and Dashboards.
• 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.

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 ReportsBusiness 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

Sr. SQL Server BI Developer

Responsibilities:

• Worked on Agile/SCRUM methodology for iterative and incremental development.
• Actively involved in gathering and analyzing stakeholder's requirements.
• Installed and Configured SQL Server 2014 successfully.
• Worked on latest version of all software's like Visual Studio 2012 ultimate, Management Studio 2014.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Designed many technical documents individually to help the team understand the requirement for Building packages using SSIS.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Responsible for Deploying, Scheduling, Alerting and Maintaining SSIS packages.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Used Execution Plan to optimize and enhance the performance of SQL Queries.
• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Created SSIS packages to import data from MS Access, Excel to SQL 2014.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Proficiently created Reports based on the requirements using SSRS.
• Defined parameters for parameterized Reports.
• Converted few reports from crystal reports to SSRS.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Held responsibility for database maintenance plans.
• Handled error logging and row level loggings while creating dynamic packages.
• Explored Erwin for Data Mapping and Modeling.
• Created alerts, notifications, and e-mails for system errors.
• Performed unit testing for every package created.
• Deployed and scheduled tidal Job a job for SSIS Package for different environment.

Environment: MS SQL Server 2014, Visual Studio2012, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, MS Access, TFS, MS Excel, ERWIN, Windows Server 2012, Oracle 11g, Toad, MS-Visio, ETL Informatica

Confidential, Alexandria, VA

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 managing various 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, Richmond,VA

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 managing stored 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, Jersey city,NJ

SQL / MSBI Developer

Responsibilities:

• Involved as a team member for requirement analysis in design phase of the Project.
• Project involved maintenance of existing OLTP databases 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 store d 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, 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.

Tools: MS SQL Server 2012/2008R 2/2008/2005/2000, MS Visual studio 2010/2008 (SSIS/SSRS/SSAS), Microsoft Access 2007/2003, Microsoft Excel, Outlook, MS SQL Profiler, SQL Server Query Analyzer, Index Tuning Wizard, ASP.Net Frame Work 2.0, C#, Oracle, DB2, Crystal report, Erwin8/7.3/3.5,Windows 2007/2005 Advanced Server/Professional, Windows XP, MS Access, Java, My SQL, HTML, CSS, SQL Server BI Development Studio (BIDS), SQL Server Integration Services (SSIS) 2012/2008R 2/ 2008/2005/2000, SQL server Analysis Services (SSAS) R 2 /2008/ 2005/2000, SQL server Reporting Services (SSRS) 2012/2008R 2/2008/2005/2000, Oracle 10g/9i/8i, MS Access, T- SQL,C,C++,C#,HTML, XML, Java, ASP .NET, VB6 .NET, Crystal Reports, Erwin7.2/4.5/4.0, MSVisio2007/2003, Clear Quest, Autosys, DTS, windows7/Vista/NT/XP/ 2003/2000/98, Rational Clear Case, Windows 2000Advanced Server, queries, views, stored procedures, Waterfall & Agile development, ETL, MDX and MDM, OLAP and OLTP, TFS, IIS, DTS, Oracle PL/SQL, XML, HTML, Web Services, Crystal Reports, Javascript, DAX, Visual Studio, QA, Data Modeling, performance tuning, SOAP, .NET, ASP.NET, ADO.NET, VB.NET, PowerPivot, PowerView, Star Schema, REST, WCF, JSON, Ajax, ASP/JSP, JSF, Query Optimizer, Dashboard, Oracle OBIEE, BIDS, ERP, SAN technology, IFS ERP/CRM, PostgreSQL, Tableau, Cognos, Cosmos, UNIX, Linux.