SUMMARY

• 8+ Years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2016/2014/2012/2008 R2/2008/2005 and Business Objects BO Crystal Enterprise 2013/2008.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Used MS SQL Server 2012 SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Expertise inSQL Server Analysis Services (SSAS)to deliver online analyticalprocessing (OLAP)and data mining functionality for business intelligence applications.
• Experienced in Agile development mythology like SCRUM.
• In-depth knowledge of understanding all stages of Software Development Life Cycle (SDLC).
• Expertise in working on both Normalized and De-Normalized Database.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) andSQL Server Analysis Services Database (OLAP)and included various reporting features.
• Experience in Relational(OLTP)and Dimensional modeling(OLAP)concepts and constructs.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models using SQL Server Reporting Services (SSRS) based on client requirement and also ad-hoc reports in excel using pivot table/charts.
• Experienced in designing, creating, testing, and implementing complex reports using SSRS, Crystal Reports, Webi reports and Business Objects Enterprise reporting tools.
• Extensive experience in Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations.
• Responsible for publishing of Crystal reports to Business Objects Infoview and configuring the database in Business Objects Content Management Console (CMC).
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Reviewed andoptimized SQL queries, CDC,stored procedures, functions, Indexes, views and triggersfrom other developers to achieve maximum efficiency and scalability.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Database Technologies: SQL Server (2005, 2008,2008R2,2012,2014,2016), Oracle 10g SQL, PLSQL

Programming Languages: SQL, T-SQL, HTML, HTML5, CSS, XML, C, C++, C#

Business Intelligence Tools: MSBI (SSIS, SSRS & SSAS), Metadata, Power Bi, MS Access

IDEs /Tools: MS Visual Studio 2012/2008/2005/2000 , SSMS

Other Tools: MS Office Suite (Word, Power Point, Visio), OLAP, OLTP, TFS, JIRA

Operating Systems: Microsoft Windows 98/2000/2003 Server/XP/7/8/2008 Server/10

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2012/2008/2005/2000 ), Crystal Reporting, Webi Reporting, Microsoft Access 2013,Excel slicers .

PROFESSIONAL EXPERIENCE

Confidential - Sacramento, CA

Sr Sql BI / Reports Developer

Responsibilities:

• Lead in building architecture and programming reporting tools, acting as lead to troubleshoot technical issues and refine SQL coding for reporting, and maintain databases as necessary
• Developed various types of reports by using excel slicer tool that shows providers performance on region, county levels.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Developed SSIS packages to fetch data from source DB, manly for running multiple scripts in parallel and performing bulk insert using SSIS Script task.
• Developed SSIS packages using Change Data Capture (CDC) functionality using complex stored procedures, Execute SQL Task and Data FLOW Task in Control Flow and OLE DB Source, Script Component Transformation and OLE DB Destination in Data Flow.
• Developing SQL script in a way to fetch data from several old databases and store it to the staging of Umbria system as delta pull.
• Developed SQL scripts to transform and populate data into the production environment ensuring execution order of production scripts.
• Created Drilldown reports, Parameterized reports, linked reports, Sub reports and filters, Snapshot Reports, Visualization Reports (charts) in SSRS 2008/2012.
• Performed daily tasks includingbackup and restoreusing scheduledSQL Jobs and alerts.
• Used Excel slicers to generate analyzer report and summary reports tools.
• Participated in migration of major data bases from Access database to Sql Server.
• Created Stored Procedures in back up process and automated by weekly and monthly.
• Database enhancements and reconciliation
• Created complex Stored Procedures, Triggers, Cursors, Tables and otherSQLJoins and sub queries Statements inSQLServer Management studio (SSMS).
• Participated in extensive database design, with specific focus on performance tuning.

Environment: MS SQL Server 2014,2016, MS Access data base, SQL Server Reporting Services, SQL Server Integration Services (SSIS), Power Bi, Excel Slicers, ETL, Visual Studio, OLAP, SharePoint.

Confidential - Sacramento, CA

Sr. SQL BI Developer

Responsibilities:

• Worked with end users in understanding the requirement and have designed the reports accordingly.
• Identified the required data objects in the database and created various T-SQL and PL/SQL complex queries to pull data for reports.
• Created reports on claims, Billing/Finance, Provider Relations, Accounts Management and Fulfillment using SSRS and Crystal Reports.
• Experience with SQL Server Reporting Services (SSRS) and Power BI to author, manage and deliver paper- based, Web-based reports and Interactive Dashboards.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Generated custom and parameterized reports using SSRS.
• Created Parameterized reports, linked reports, Cross-Tab reports, Drill down reports & Summary reports by UsingSSRS.
• Created various types of SSRS reports like drill down, drill through, sub reports, Nested Chart reports and create report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types queried and non-queried parameters.
• Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Created various SSIS packages to extract data from one data source and load in to other data ware house.
• Designed and Developed packages for system integration, product development and ongoing maintenance of the tables usingSSIS.
• Created SSIS packages to import the data into SQL server.
• DesignedSSISPackages to extract, transfer, load (ETL) existing data intoSQLServerfrom different environments for the SSAS cubes.
• 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 task, active script task, xml task.
• Created SSIS packages to import the data into SQL server.
• Involved in Troubleshooting of the already existing SSIS packages.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Extensively worked on OLAP cubes using SSAS.
• Expert in creating Star schema cubes and OLAP CUBES using SSAS.
• Built many Crystal Reports using “Add Command”, assigning parameters at command level, and applying criteria at Select Expert.
• Created Crystal Report to Monitor a list of all imaging orders scheduled for a day, including their current statuses, to ensure the schedule stays on track.
• Performance testing on stored procedures, indexes, and triggers.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Loaded data from one schema to another schema within the database through stored procedures.
• Performing SQL server daily health check and preparing a report based on it.
• Validate the data in reports with respect to data in the application.

Environment: MS SQL Server 2012,2014,2016, SQL Server Reporting Services, SQL Server Integration Services (SSIS), ETL, Business Objects XI 4.0/3.1, Crystal Reporting 2013/2008, Info View, CMC, Visual Studio, OLAP.

Confidential, RTP, NC

Sr. SQL BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2012 using SSAS, SSIS/DTS, SSRS.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Development and deploying of the SSIS 2005/2008/2012 packages to maintain update and migrate the data into and from the FACETS application database.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Querying and manipulating multidimensional cube data through MDX Scripting inSSAS.
• Experience in Designing, Creating, Deploying and Processing of Cubes usingSSAS.
• Experience in creating and managingSSASTabular models, creating Dimension and Fact Tables.
• ETL Programming for capturing data from disparate sources using SQL Server Integration Services (SSIS, SSRS) with Visual Studio, and Analysis Services.
• Generated various reports with drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.
• Deployed the SSRS reports in Microsoft office share point portal server.
• Developed numerous ad-hoc reports using SSRS for day to day reporting.

Environment: SQL Server 2012/2008/2008 R2/2012 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), TSQL, C#, XML, MS Visual Source Safe and Windows Server 2010.

Confidential, Chicago, IL.

Sr. SQL BI Developer

Responsibilities:

• Involved in technical decisions for business requirement, interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Installed and Maintained MS SQL Server 2000/2005.
• Involved in creating clustered and Non-Clustered Indexes to improve the database transactions performance.
• Involved in database development using stored procedures, triggers, views and cursors.
• Converted, loaded and integrated data from Access, Excel, text.csv files and internal database applications including the mainframe with data captured for security applications
• Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Generated reports using Crystal Reports and Developing SQL stored procedures, views and triggers.
• Developed SSIS solution for developing a fully-fledged data warehouse solution.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), TSQL, C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

Database Developer

Responsibilities:

• Designed logical and physical models for staging database and data warehouse using Erwin database modelling tool.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Created different kind of reports like parameterized reports, drill down reports, and sub reports to support business needs and involved in report deployment and report security.
• Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Integrated mode.
• Created a SQL reporting services (SSRS) and SSIS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Create SSRS reports against Team Foundation Server Database.

Environment: SQL Server 2008, Transact-SQL, Extract transform Loading (ETL), SQL Server Integration Services (SSIS, SSRS, SSAS), Extract Transform Load, Transact-SQL, Visual studio, C#.Net, ASP.NET (2.0), Erwin, Windows Server, ProClarity, Query Analyzer, Web Services.

Confidential

SQL Server Developer

Responsibilities:

• Involved in design and analysis of underlying database schema, altering and creation of the table structure.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Backing up master & system databases and restoring them.
• Design and developing SSIS Packages, migrating DTS Packages to SSIS Packages.
• Migrated database objects from MSSQL 2000 to MSSQL 2005.
• Created Cubes and performed data mining on the data using the fact table and the dimension.
• Experience in data mining and analysis, design and construction of data marts, data views.
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Used various tasks in control flow and data flow to cleanse and filter duplicates in tables.
• ETL through SSIS and responsible for loading Data to DB from different input sources.
• Generated specifications for analysis reports by using SQL Server 2005/2008 Reporting Services (SSRS).
• Scheduled Jobs and Alerts using SQL Server Agent.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.

Environment: MS SQL Server 2005/2008, MS Visual Studio 2005/2008, Windows 2000/2003, SSIS, SSRS, SSAS, MDX, OLAP, ETL, T-SQL, Query Analyzer, SQL-Profiler, SQL Server Enterprise Manager.