SUMMARY

• Over 7+ Years of IT experience as SQL Server Developer building Data Warehousing, Data Modeling, ETL and Business Intelligence solutions.
• Proficient in all phases of software development life cycle (SDLC), Interacting with Business Users for Requirements Gathering, Analysis, Application Design, Development, Testing, Deployments and Maintenance of Data Warehouse and Data Mart systems in HealthCare, Insurance and Finance industries.
• 5+ years of strong experience in design and developing ETL using MS SQL Server Integration Services (SSIS). Worked with various versions starting 2000, 2005, 2008, 2008 R2 and 2012.
• Experienced in Data Profiling, Data Integration, Data Quality and Metadata Management.
• Experience in Installing and Upgrading MS SQL Server suite of products in Windows environment from R2 and from 2008 R2 to 2012.
• Excellent skills in design and development ofETLpackages usingSSIS for integrating data from heterogeneous sources (Excel, CSV, Oracle, Flat File and Text File) using multiple transformations available inSSIStoolbox such asData Conversion, Conditional Split, Bulk Insert, Merge, Lookup andUnion all.
• Hands on experience working with Data Marts, Data Warehouses building Facts, Star and Snow Flake dimensional models.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in report development using SSRS, BO Reporting tools like Universe, Web Intelligence and Crystal Reports.
• Well versed in implementing business logic using SQL Queries, Stored Procedures, Functions, Views, Data base tuning and performance techniques.
• Expertise in Database Management Systems including but not limited to Microsoft SQL Server 2012/2008/2005 , Teradata, DB2 and Oracle 11g/10g/9i.
• In depth knowledge of designing Entity Relationship and Data Flow Diagram for Business processes.
• Outstanding communication and interpersonal skills, ability to learn quickly, hardworking, good analytical reasoning and high compliance to new technologies and tools.
• Good understanding and hands - on experience on XML, XSL (XSLT, XPath, XSL-FO).
• Experience with defect tracking and analysis using different defect tracking tools such asTFS (Team Foundation Server)
• Good knowledge of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake Schema Modelling. Written MDX query in OLAP databases.
• Experience with Data warehousing and STAR schema. Extensive knowledge on visualization of data and knowledge of tools such as Tableau.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER DB, MS Access, Teradata, DB2 and Oracle.

Reporting Tools: MS SSRS, BO Web Intelligence and BO Crystal Reports.

Operating Systems: Win 2000/NT/ 2003/2008/2012 server.

Programming: Unix, C#, ASP.Net, Visual Basic, Java, SharePoint, XHTML and XML.

Data Modeling: ER-Win 4.0, MS Visio 5.0

BI Tools: MS SQL Business Intelligence, Power BI, PowerPivot, QlikView

ETL Tools: Data Transformation Services (DTS), MS SSIS and BODS.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio.

PROFESSIONAL EXPERIENCE

Confidential, cincinnati, OH

SQL BI Developer

Responsibilities:

• Experience in Extract, Transform and Load Process/design, source-target mapping, reviewing, writing, tuning Complex ETL jobs - daily and high frequency.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
• Exposure to complete development life cycle of Enterprise Data Warehouse design and Development
• Developed data warehouse in start schema, fully participated in Dimension modeling using Kimball model
• Experience working with Medicare Advantage Organizational Health Plan and also strong in SQL/SSIS
• Experience in SSIS, SQL Stored procedures development experience dealing with large volume health care data processing and analytics
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.
• Published views and dashboards inTableauServer for auditor review.
• Used Data Contract as the standard mechanism in the WCF for serializing .NETobject types into XML.
• Experience in dimensional data modeling using star and snowflake schemas for fact and dimension tables using SSAS.
• Responsible for data modeling, ETL process design, SSAS cubes design and suggesting designs forBIdashboards on MicrosoftPowerBIandTableauv9.1.
• Proficiency in writing advanced SQL, & PL/SQL programming
• System Design & Mapping of Business Process in MS Dynamics AX 2012R3
• Developed data extraction strategies to extract data from Excel and XML
• Experience in data modelling using STAR schema
• Experience in extracting data from different sources like database tables, Text Files, XML and Excel sheets - transforming data - and loading it into multiple targets.
• Experience on SAP tables and strong knowledge of SAP Master Data.
• Good Knowledge of Health Care industry.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Manage workload to deliver according to business priorities.
• Created and PublishedTableauDashboards intoTableauServer.
• Identify and analyze data according to specific needs to Prepare report and maintain database of application and processes through Cognos
• Monitor database performance and analyze issues, primarily with Microsoft SQL Server 2008 R2
• Developed stored procedures with advanced programming techniques includes minimal logging, accurate execution plans and index seeking methodologies
• Use Cognos Connection to access the Cognos data Monitor metrics and create business intelligence reports.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Wrote custom support modules for upgrade implementation using Pl/SQL, Unix Shell Scripts
• Involved in physical and logical data modeling using Erwin along with the architects.
• Migrated data from on-premises data servers ontoMicrosoftAzurecloud platform utilizingAzure data factory.
• Backed-up enterprise databases toAzurestorage in block BLOBs and bacpac files inAzure environment.
• Regular and timely communication of status of projects and issues to management team

Environment: T-SQL, MS SQL Server 2008 R2/2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, SQL Server Analysis Services (SSAS), SAP, OLAP, XLST, XPATH, C#, Azure, Power BI.

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Experience with T SQL (DDL and DML) in constructing tables, user defined functions, views, complex stored procedures, relational database models, data dictionaries, data integrity and appropriate triggers to facilitate efficient data manipulation and consistent data storage
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed & maintained Web Forms with C#.Net.
• Familiarity with the insurance industry and financial services
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created incremental refreshes for data sources onTableauserver.
• UsedTableauDesktop for blending databases and creating different interactive views and dashboards.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Used C# to create application and to insert records into database.
• Developed and maintained web forms with C#.Net
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS)
• Generated several drill down and drill through reports using SSRS.
• Expert in creating STAR schema cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Designed and developed the reporting layer for SpotfireBIanalysis and reporting.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Charts and other visualization using Power View.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Provides technical documentation of the system
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Presenting data using graphs, tables, charts with data visualization tools like Tableau.

Environment: MS SQL Server2005/ 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), AX2012R3, SQL Server Analysis Services (SSAS), Lotus Notes Client, MS Visual Studio.NET, C #, 2008, TFS (SharePoint), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server, T-SQL, Power View, Power BI, Tableau.

Confidential

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created SQL server Reports using SSRS 2008, Identified the data source and defined them to build the data source views.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Created Packages in SSIS with error handling and Time Dimensions on OLAP Cubes using SSAS.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Responsible for Testing the BI Reports (QlickView) of Sales module individually. Also responsible for other modules in giving Test Scenarios to the team.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: MS SQL Server 2008 and 2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS, ETL, ODBC, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports.
• Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Used AngularJS MVC framework, JavaScript, HTML, and CSS for front end web designing.
• Involved in creating, deploying and configuring reports according the requirements.
• Involved in writing scripts for the clients requirements for generating reports.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers. Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Involved in creating, deploying and configuring reports according the requirements.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Fixed reports and bugs in stored procedures.
• As a DBA involved in maintaining the Database Backups for the team using SQL lite speed backups, database performance tuning, using migration methodologies for improvement.
• Managed the security of the servers (Logins and users).
• Installed and Configured SQL Server 2005, Integration Services (SSIS) and Reporting services (SSRS) for Dev and QA environments.
• Documented the flow of the project.

Environment: MS SQL Server 2000/2005, SSRS, SSIS, Project server 2007, Crystal Reports, HTML, VSS, Office 2007 bundle, Windows XP, Windows 2003 Server.