SUMMARY

• 6 years of Experience in Business Intelligence, Database Development, Quantitative Analytics experience with deep expertise in System Analysis, Design, Development, implementation and support of MS SQL Server 2005/2008//2008 R 2/2012/2014/2016 .
• Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers & Cursors
• Development, implementation, administration & support of ETL processes for large - scale Data Warehouses using SSIS 2008 with various control flow, data flow tasks and store procedures for work order validation process
• Migrating SSRS Reports from SQL 2000 to SQL 2005, SQL 2008 & SQL 2008 R2
• Creating and managing fragmentation of Indexes to achieve better query performance
• Good interaction with clients, understanding Business Application, Business Data Flow and Data Relations.
• Good understanding of technical trends, architectures and highly motivated to know more about least technology, new software and products.
• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Ability to handle multiple tasks concurrently and meet the deadlines.
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS

Languages: T- SQL, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML

Databases: SQL Server 2012/ 2010/ 2008 R 2/ 2008/ 2005/ 2000

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000 , Report Builder 3.0

Operating Systems: Windows/ 98/ 2000/ 2003/ XP/ Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. MSBI/SQL Developer

Responsibilities:

• Worked with Technical Architects &Database Analysts to design summary tables required for efficient report design
• Created complex SQL stored procedures using Microsoft SQL Server 2008 &2008 R2
• Designed functional &technical documents, report templates &reporting standards to work on report development using SSRS 2008 &SSRS 2008 R2; generated reports from cubes with SSRS Connection.
• Created cubes, dimensions &measures and calculated measures as per business requirements; created several SSIS packages to perform ETL operations like data transformation from a cube using MDX
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008 and deployed SSIS Packages & Reports to Production Servers; created database maintenance plans & deletion of history data using SSIS packages
• Performed data transfer from files in remote server to folders in another server using FTP
• Developed SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005; created interface stored procedures used in SSIS to load/transform data to the database
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup &management of linked servers to Non-SQL-Server databases
• Involved in Report Authoring, Report Delivery using Pull & Push strategy and Report Management for various reports
• Created snapshots of static reports and configured subscription.
• Created hierarchies for date ®ion dimension tables, browsed cube for data analysis &validation and processed cubes &dimensions using SSIS tasks; developed and extended OLAP Cubes, dimensions and data source view
• Built cubes for production application, partitioned cubes to decrease processing time &increase performance of queries running on front end application using SSAS 2008
• Involved in SSAS storage & partitions, aggregations, calculation of queries with MDX, Data Mining Models &developing reports using MDX &SQL; built database queries & test cases to test reports
• Handled logical/physical data analysis, modeling, database design, star schema, programming &implementation
• Extracted data from CSV files, Oracle, &MS SQL 2000 and stored in intermediate Staging Database using SSIS ETL
• Transformed the data from the staging database and performed the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS
• Scheduled Reports to run on daily/weekly basis in Report Manager and emailed to director &analysts for review
• Prepared reports for daily/weekly/monthly purposes in various formats like MS Excel, PDF, HTML, XML, etc.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ProClarity, MS Excel

Confidential, VA

Sr. SQL Server BI Developer

Responsibilities:

• Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs for various customers
• Used SSDT to design SSIS packages to transfer data between servers, load data (Excel layouts) into database, and archived data file from different DBMS. Scheduled the job to do this task periodically
• Created SSIS script tasks, Lookup transformations and Data flow tasks using C# and VB scripts and other transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created SSIS packages to transfer XML file data into SQL server database.
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
• Using Power BI as a front-end BI tool and Microsoft SQL Server 2012 as a back-end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views. Also modified and created Joins to Improve the Database execution speed.
• Designed and Developed matrix, tabular and parametric, Drill down and Drill Through reports with Drop down menu option using SSRS and scheduled to generate all daily, weekly, monthly and quarterly Reports including the status.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View to visualize reports.
• Used stored procedures in SQL server for retrieving the data from the database for solving complex queries. Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Involved in new KPI generation for Scorecards.
• Created Web reports utilizing custom SQL queries and changed over them to Tableau dashboards for advanced visualizations.
• Strong knowledge of managed claims management process, Knowledge of Medicaid and Medicare Services. CMS, Health Assessment Systems, Hl7 Standards, HIPAA, PPACA (Patient Protection and Affordable Care Act), Compliance issues, HL7 Message Validation, ICD 9, Electronic Health Records, Electronic Medical Records.
• Involved in Mock testing, Unit Testing and Integration testing in SSIS.

Environment: SQL Server 2012, SSIS, SSRS, SSAS, SSDT, Teradata, Visual Studio 2012, Erwin 4.0, QlikView, Power BI, Power Pivot, MS Excel 2010, C#, Team Foundation Server (TFS), Windows Server 2010, Tableau Desktop 10.2/9.3, Tableau server 10.x/9. X, AIX/Linux Shell Scripting

Confidential, Rancho Cordova, CA

SQL Server BI Developer

Responsibilities:

• Worked on Agile/SCRUM methodology for iterative and incremental development.
• Actively involved in gathering and analyzing stakeholder's requirements.
• Extensively involved in gathering business requirements that will facilitate the planning and the implementation phase of a data warehouse.
• Created new and modified existing stored procedures for better performance and also for documentation.
• Generating scripts and schemas by using reverse engineering through Erwin Data Modeler.
• Designed and implemented OLTP database using Microsoft SQL SERVER 2008.
• Created objects such as: Stored Procedures, Triggers, User define functions, Indexes, Views, and Indexed views.
• Designing dashboards using SSRS, Power view, power pivot and PerformancePoint services.
• Analyzed the historical data and extracted required data using both T-SQL and SSIS to support the management decisions.
• Optimized the existing queries to improve performance with the use of SQL Profiler, DTA and Execution Plans.
• Involved in scheduling packages through SQL Server Agent and setting up shared schedules.
• Handled the reporting server and was actively involved in creation of various types of complex reports.
• Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed Perspectives and Hierarchies in SSAS Tabular model.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model.
• Created several reports using SSRS like drill down, drill through, parameterized, linked and sub reports.
• Responsible for identifying and defining the Datasets for the report generation, writing the queries for the drill down reports, and identifying and adding the report parameters.
• Created and Maintained security (system level as well as item level), subscriptions and delivery on managerial requirements.

Environment: MS SQL Server 2012/2014, Visual Studio2012, SSIS, SSRS, desktop, Query Analyzer, Azure, Database Engine tuning wizard, T-SQL, MS Access, MS Excel, Windows Server 2012, MS-Visio

Confidential, Corpus Christi, TX

SQL/BI Developer

Responsibilities:

• Responsible for Design, Development and testing of SSIS Packages to load data from various Databases and Files.
• Support and maintain several databases including production databases running Oracle 10g & 11g, Microsoft SQL Server 2008 and EnterpriseDB PostgreSQL on Linux and Windows Operating Systems. Installed, configured, upgraded and migrated Oracle, PostgreSQL and MySQL Databases.
• Implement EnterpriseDB PostgreSQL one-to-one Replication, develop and enhance scripts to automate and execute various DBA tasks. Assess the DB performance and lead the effort to patch, upgrade and/or tune the DB for optimum performance and keep the PostgreSQL DBs current.
• Review SQLs and DB transactions developed by software engineers and assist in improving the efficiency of the code for best possible DB performance.
• Support and maintain several databases including production databases running Oracle 11g and EnterpriseDB PostgreSQL/Community PostgreSQL on Linux and Solaris Operating Systems.
• Setup and Monitor schema replication in Oracle 11gR2.
• Migrated Oracle database to EnterpriseDB PostgreSQL.
• Installed EnterpriseDB PostgreSQL/Community PostgreSQL Databases version 9.3, 9.4, 9.5, 9.6 and
• Implemented Community PostgreSQL master/slave database on 3 cluster node with pgpool.
• Implement EnterpriseDB PostgreSQL MDN and NMDN XDB replication.
• Setup Backup and recovery using BART.
• Develop and enhance scripts to automate and execute various DBA tasks.
• Upgrade and/or tune the DB for optimum performance and keep the PostgreSQL DBs current.
• Setup Partitioning in PostgreSQL and automated creation of partitions on a Monthly basis.
• Design and implement backups/disaster recovery solutions for the PostgreSQL Database using custom scripts manage the databases in development and QA environments.
• Implemented EDB Failover Manager on a 3-cluster node in AWS.
• Migrated EnterpriseDB PostgreSQL/Community PostgreSQL 9.3 to 9.4, 9.5, 9.6 and 10
• Apply various PostgreSQL Patches
• Setup SQL Server transactional replication with updatable subscription and Peer to Peer Transaction replication.
• Performed SQL Server database backup and recovery.
• Performed database maintenance such as shrinking datafiles.
• Installed and configured MySQL on Redhat Linux
• Migrated Oracle database to MySQL database.

Environment: MS SQL Server 2014/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Power BI, Power Query, SSMS, Team Foundation Server (TFS), SQL Server Data tools, Business Objects, SharePoint 2012, Tableau Desktop 10.2/9.