Steephen Kuriakose

***** ******* ******, ********** *****, Michigan, USA 48335

Cell#: 248-***-**** Email: ad0gkx@r.postjobfree.com

SUMMARY

Experience in SQL Server database development in various domains like Finance, Insurance, and Healthcare.

Experience on writing T-SQL queries, Stored Procedures, Functions, Triggers, CTEs, and creating Views.

Expertise in query optimization and performance tuning using execution plans, SQL profiler, and proper usage of indexes.

Knowledge in database Backup, Restore, Recovery, log shipping, replication, and Linked Servers.

Expertise in BIDS to develop different kinds of reports (tabular & matrix, drill-down & drill- through) on SQL Server Reporting services (SSRS).

Proficient in high level design of ETLs (DTS and DTSX packages) for integrating data from various sources.

Experience in creating reports and dashboards using Microsoft Power BI.

Embedding Power BI reports in Salesforce using Visualforce pages.

Microsoft Certified Professional.

Technical Skills:

Databases: MS SQL Server

Programming: Visual Basic 6.0 (VBA), MS Access

Operating System: Windows

Dashboard/Reporting Tools: Power BI, SSRS, Crystal Reports, MS Access PROFESSIONAL EXPERIENCE

PopHealthCare, Franklin, TN Feb 2023 – Till date

Senior ETL Developer

PopHealthCare offers a fully integrated approach to care delivery, risk adjustment, and quality enhancements, serving the highest risk populations with unwavering commitment and dedication. From comprehensive home-based primary care solutions to prospective and retrospective risk adjustment programs, PopHealthCare helps to provide exceptional care for members, manage costs, and ensure you receive credit for the care you provide. Responsibilities:

• Create/Manage SSIS packages to load data for different clients and systems into SQL Server databases.

• Write SQL queries to pull data for various customers based on the requirements.

• Create and schedule SQL jobs to execute them at required intervals. Softura INC, Farmington Hills, MI Jun 2012 – Jan 2023 Senior SQL Server Developer

Client: Brightview

BrightView is the nation’s leading commercial landscape company. We take pride in delivering consistently excellent results for clients across the country, throughout the lifecycle of their landscapes.

Responsibilities:

• Create different reports and dashboards using MS Power BI.

• Perform high-level testing of the Power BI reports Client: Davenport Financial

Description: Davenport Financial offers a variety of services related to Tax Lien Investment and Collateral Management. With a strong emphasis on excellent diligence and customer service, we work to unlock revenue while focusing on building strong relationships. Responsibilities:

• Normalize database tables and written SQL scripts to insert data into these tables from existing flat tables.

• Created/modified Tables, Views, Stored Procedures, and Functions.

• Created various SSRS reports and deployed them on the Reports Server.

• Created SSIS packages to insert data into SQL tables from Excel sources. Client: University of Michigan

University of Michigan has an in-house application called AECtion for Architecture, Engineering and Construction departments to maintain and mange every project from its inception to execution and closing, tracking project progresses including budget, timelines, resources, etc. Responsibilities:

• Created different complex reports using SQL Server Reporting Services (SSRS).

• Deployed and integrated SSRS reports in Share point webserver.

• Developed and created new database and database objects including tables, views, index, stored procedures and functions.

• Created various SQL jobs and scheduled them to pull data from different databases and insert into the DW database.

Client: Centurion Medical Products (Medline)

Description: Centurion Medical Products develops unique products and innovative services that respond to the changing requirements of the healthcare industry. Responsibilities:

• Created various complex SSIS packages which pulls data from different sources like Excel, SAP and SQL databases.

• Deployed and scheduled the SSIS packages to run at different time intervals.

• Created reports using SQL Server Reporting Services (SSRS).

• Developed new database objects including tables, stored procedures and functions. Client: Orlans Associates

Description: Orlans Associates, P.C. is a Michigan law firm that serves the real estate financial industry and provides legal counsel in the default services industry. Responsibilities:

• Created various reports using SQL Server Reporting Services (SSRS) and deploy them on the report server.

• Created Linked Servers to manage and interacts data between different servers.

• Performed Log shipping to move data from one server to another server, and scheduled to move this data at different intervals.

• Replication setup was completed to move production data on to a secondary server. Synechron Technologies Jan 2011 – Jun 2012

SQL Server Developer

Customer - Wells Fargo, Charlotte, NC

Nexsure, the Internet insurance agency management solution that connects agents, carriers, brokers, wholesalers, and policyholders, driving efficient business production, superior customer service, and insightful business management. Nexsure offers robust contact management, sales force automation, advanced work flow, standard and custom lines of business, policy life cycle management, CRM, and multi-office accounting and reporting. Nexsure is a scalable, web- architected, Microsoft .NET application with built in web services, data processing, and transactional capabilities.

Responsibilities:

• Extensively worked on Profiler, Performance monitor to tune the databases and query tuning.

• Optimized query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

• Analyze execution plans and provide suggestions for performance improvement.

• Created, deployed and managed reports using SQL Server Reporting Services(SSRS)

• Created ER-Diagrams and Data Models for various modules. Accenture Services, Bangalore, India Jun 2007-Dec 2010 SQL Server Developer

Client: Goldman Sachs Apr 2009 – Dec 2010

The Goldman Sachs is leading global investment banking, securities and investment management firm. They provide a wide range of financial services to a substantial and diversified client base that includes corporations, financial institutions, governments and high-net-worth individuals. Responsibilities:

• Created reports using BIDS and ad-hoc reports using reporting services Report builder.

• Configured IIS, Report manager, Report server and implemented role-based security to end users.

• Writing stored procedures, triggers, and functions and maintained coding standards.

• Used SQL Profiler to capture the activities of the databases and used the trace file for Database Tuning.

• Worked on DTS, Import and Export utility, for transferring data. Client: Best Buy Jun 2007 – Feb 2009

Responsibilities:

• Created Documentation, schema designing, ER Diagrams using MS Visio and involved in architecture, Monitoring, and optimizing performance of the database servers.

• Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration.

• Participated to migrate Crystal reports to SQL Server 2005 SSRS instance.

• Developed SSRS custom, sub reports, drill through and drill down reports.

• Created Ad-hoc reports using report models and report builder. HealthAsyst, Bangalore, India Aug 2005 – May 2007

SQL Developer - DBA

HealthAsyst serves the Healthcare organizations worldwide to support their business strategies with world-class and value-for-money IT Consulting, Management and System Integration services. They offer wide range of services and solutions including for the Healthcare industry. Some of their expertise include: ICD 9-10 conversion, Healthcare EDI, Healthcare Mobility. Their services include: Product Engineering, Application Development, Testing & QA, and Implementation. Responsibilities:

• Setup new MS SQL Server instances and databases.

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer.

• Designed new job process, new database maintenance plans, DTS packages.

• Used SQL Profiler utility and trace file, and involved in performance tuning processes.

• Monitor failed and long running MS SQL Server jobs.

• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Certifications:

DA-100: Analyzing Data with Microsoft Power BI

768: Developing SQL Data Models

461: Querying Microsoft SQL Server 2012/2014

Contact this candidate