PROFESSIONAL SUMMARY:

• Over 9 years of experience in professional application and database development with thorough knowledge of different phases of software development life cycle including analysis, design, development, documentation, deployment and system support.
• Over 7 years of experience with forecasting, analyzing and consolidating data as well as creating key business metrics, reports and dashboards for senior management based on business requirements and conditions.
• Have very good communication and interpersonal skills, with the ability to deliver quality and effective results with minimum supervision.
• Always interested to learn new skills and able to adopt new situations and environments quickly.
• Can handle cumbersome projects from start to finish while managing customer expectations.
• Have very strong analytical, problem solving and troubleshooting skills.

TECHNICAL SKILLS:

Database Technologies: SQL Server 2000/20 R2/2012/2014, PostgreSQL, SAP HANA, MS Access

Languages: SQL, T - SQL, BPC Script Logic, PL/SQL, XML, HTML, CSS, VBA, PowerShell

Tools: SSRS, SSIS, SSAS, Tableau, MicroStrategy, Visual Studio, TFS, GitHub, LightSpeed, Spotlight, SolarWinds DPA, Skype, Jira, Slack, IBM Notes, IBM Sametime, MS Office, MS Visio, Support Works, SAP BI/BW/BPC, WEBI

Web Servers: IIS, Apache

Operating Systems: Windows NT/2000/XP/Vista/Window 7/Window 8/Window10

Big Data POC: Hadoop ecosystem for EMR and registry data

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Warehouse Developer

Responsibilities:

• Analyze various data (clinical, appointment, procedures and labs and vitals etc.) and send to top management to support decision making.
• Write advanced T-SQL queries, complex stored procedure, tabular and scalar functions, temp tables, CTE’s, views and table variables based on the business logic.
• Create advance SSIS packages to load data from various sources to Data warehouse environment.
• Lead to upgrade SSIS packages from SQL Server 2008 R2 to SQL Server 2014 project deployment model.
• Install and configure SSRS services for reporting and create advance dashboards/reports on SSRS to analyze the medical trends and ROI analysis for the clients.
• Lead to upgrade SSRS reports and dashboard for SQL server 2008 R2 to SQL server 2014.
• Automate and streamline the existing reports and ETL packages to meet the client requirements and enhance production process.
• Create reports, dashboards and scorecards on tableau and work with FP&A and marketing team to forecast future revenues as well as marketing behavior and models.
• Lead to design logical database model, RDBMS and implementation for new processes and requirements in data warehouse environment.
• Using Solarwinds DPA to monitor SQL servers and root-cause analysis of performance issues.
• Create SQL server agent jobs and maintenance plans to automate the ETL process, database backups, automate report schedule and maintain indexes on SQL server 2014.
• Write scripts and processes to collect and analyze database performance statistics on SQL server 2014.
• Deploy SQL objects, SSIS packages and SSRS reports through each environment from Development to Production.
• Performance tuned existing and new code using minimally logged transactions such as truncate vs. delete where possible, and refactored parts of code to minimize length of transactions.
• Gather detailed requirements of user needs and perform tasks for initiative development through implementation for all projects assigned.
• Work with other team members and performing script review and peer review before any release deploy into production environment.

Confidential

Sr. BI Developer/Database Administrator

Responsibilities:

• Performed tuning of SQL queries by using SQL Profiler and Activity Monitor; optimized query performance by re-writing logic or creating indexes or updating statistics or updating queries.
• Created various reports, dashboards, intelligence cube on Micro Strategy. Wrote advance expression in micro Strategy to implement business logics and work flows.
• Created dynamic SSRS reports (Drill through, drop down, Multi-parameterized, ad-hoc, Sub-report, link report) by using advanced expressions, custom as assemblies and custom codes. Maintaining existing reports based on the user requirements.
• Created ad-hoc reports on Web intelligence (WEBI) and Analysis for Office and SSRS as well as dashboard on design studio.
• Created Reports, input forms, script logics and business process flow on BPC for planning, forecasting and consolidating financial data.
• Worked with Accounting and Finance team to resolve any accounting issues and problems as well as database services team to resolve any issue on SQL 2012 and HANA 1.0 databases on daily basis.
• Worked with FP&A, Accounting, Finance and District Managers to collect data, analyze and report weekly and monthly performance of job districts to senior management.
• Closely worked with other team members and performing script review and peer review.
• Actively participated in creation of logical database model, physical database design and implementation of large database models.
• Created ETL packages on SSIS 2008 and SSDT 2012 to migrate old legacy system data into SAP ECC system
• Wrote advanced T-SQL queries and stored procedure to collect, analyze database performance statistics. Kept track of SQL server 2008/2012 activity on daily basis.
• Monitored disk space availability and log file growth to make sure that we are at least 20% free.
• Deployed SQL objects and SSRS reports through each environment from Development to Production.
• Participated in code review process of all SQL objects getting deployed to the production environment.
• Performed in place and side-by side upgrade SQL server database and SSRS reporting services from and from .
• Created a nightly maintenance plan that includes re-indexing based on a percentage of fragmentation, Full/Transaction log backups and database integrity check.

Confidential

BI Developer

Responsibilities:

• Created database, functions, triggers, stored procedures, views, tables, packages and T-SQL script for application and to meet the requirements of the business users.
• Identified major threats in the production cycle, evaluate adequacy of various control procedures and deal with those threats.
• Fine-tuned the database queries; created appropriate indexes for better performance plans.
• Experienced on creating customized fancy reports in SSRS 2008R2 using different report items (Chart, Gauge, Map, Data Bar, spark lines and Indicators) and Cubes using SSAS 2008R2.
• Worked comprehensively on complex dynamic SSRS 2008/2008R2 tabular and matrix reports and embedded these reports into different applications.
• Created ETL packages through SSIS 2008 to load data to Data Warehouses and created SSAS cubes to store data to OLAP Databases.
• Used SSIS packages/jobs broadly to migrate and transform data from legacy database system.
• Served as part of Database modeling and designing based on database development life cycle.
• Migrated data across different data sources and SQL server environments.
• Created packages to migrate data from different data sources to data warehouse.
• Used TFS 2010, a Source Control Tool for different projects created on BIDS 2008 and check in projects into TFS.
• Created log shipping on servers for backup, copy and restore transaction logs.
• Created Report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Hosted virtual and physical technical review on weekly basis.

Confidential

SQL Developer

Responsibilities:

• Created stored procedures to transform data using complex joins, dynamic SQL, CTEs, variables, error handling routines, advance string manipulation, @@ functions, sub queries and control flow logic.
• Created user defined Scalar, table- valued and multi- statement table- valued function which would later be used for creation of data models.
• Created complex and dynamic Reports using SSRS 2008 and Report Builder 2.0 from OLAP Cubes and OLTP.
• Consolidated existing reports to SSRS dashboards for improving business process and effective presentation of data for the stakeholders.
• Automated and streamlined existing reporting and develop new reports to meet client requirements and enhance production process.
• Configured and maintained Report Manager and Report Server for SSRS 2008.
• Created SSIS packages on SQL Server 2008 to migrate old legacy system data into centralize atmosphere environment.

Confidential

SQL Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Developed SSIS packages to extract and load data between source and targets, applying business rules.
• Migration of database from SQL Server 2000 to SQL Server 2005.
• Updated VSS for version control and granted permission/roles to the users.
• Involved in the complete life cycle of the project; conducted unit and system testing.
• Performed Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business/IT needs.
• Provided support to the Application developers on the application databases.