Rohith M

SR.SQL/ETL DEVELOPER

E-Mail: ac7bz9@r.postjobfree.com

703-***-****

Professional Summary:

Having 7+ years of experience as SQL developer. Experience in all phases of SDLC including requirement analysis, application design, and development of multitier applications, testing, implementation and maintenance.

Proficient in writing SQL database objects and scripts based on requirements to deliver maximum efficiency.

Experienced in designing, modeling, developing & integrating with Microsoft SQL Server SSIS/SSRS and expertise in performance tuning of SSIS packages.

Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).

Experienced in optimizing SQL code by understanding execution plans, using SQL Profiler, DMVs, Index tuning wizard and other tools.

Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.

Experience in creating informatics mappings, sessions and workflows using Informatica.

Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, UDFs and Triggers on Microsoft SQL Server.

Knowledge in Normalizing and De normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.

Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.

Strong experience in SQL Server Database Administration, Upgrading, Migrations and Development in Production\Nonproduction environment.

Expertise in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.

Strong experience in assigning permissions to the valid users for executing the reports & deploying reports to report servers.

Expertise in Business Intelligence Process for Data Integration and Migration services.

Extensive knowledge of Relational Database Management Systems (RDBMS).

Experience on performance point server and dashboards, scorecards, building reports and created management reports.

Experience in generating Drill down reports, Crystal reports, Parameterized reports, Linked reports, sub reports, Adhoc Reports, charts using SSRS

Experience with Database Backup, Recovery and Disaster Recovery Procedures.

Experience in working in AGILE environment, and ability to work in pressurized environment with tight deadlines.

Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.

Suggested Application level tuning changes for code, queries SQL objects which may not be performing up to the optimum database performance standards.

Experience in using source code analysis tools, automated build process and unit testing, debugging.

Excellent Database backend skills Using SQL.

Extensive experience in troubleshooting the issues during the database migration.

Involved in writing Business Process Testing Manual Components.

Excellent communication skills, analytical skills, understand business requirements in various domains. Effectively manages time spent on multiple projects to meet deadlines.

As a key player in the team with strong interpersonal and communication skills, I am ready to expand my knowledge where it is necessary and that I am eager to learn new technologies.

Technical Skills:

Operating Systems

Windows 95/98/NT/XP/Vista, UNIX, LINUX

Languages

SQL, PL/SQL, C, C++, Java, VB, .NET, Python.

Tools/utilities

SQL*Loader, SQL*Plus, SQL Developer, Putty, Forms, Toad, Autosys, Erwin Data Modeller, Tableau, Jenkins, Git, Aws.

SQL Server Tools

Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, SharePoint.

Databases

Hive, IBMDB2, Oracle Database Enterprise Application Server, MS SQL Server 2008/2012 R2, 2005, 2000, SQLCMD

Data Modeling

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snowflake schema, Fact tables, Dimensional tables), Entities, Attributes, E-R Diagrams.

Office Tools

Microsoft Word, Excel, Outlook, Access, PowerPoint, Google Sheets.

Education:

Master’s in computer science & Technology from SHU, Connecticut.

Professional Experience:

Client: Inovalon, MD OCT 2017 – Till Date 2018

Role: SR.SQL Data Analyst

Description:

Inovalon is a leading technology company that combines advanced cloud-based data analytics and data-driven intervention platforms to achieve meaningful insight and impact in clinical and quality outcomes, utilization, and financial performance across the healthcare landscape. Inovalon's unique achievement of value is delivered through the effective progression of Turning Data into Insight, and Insight into Action. I worked on tickets and performed analysis to develop solutions that will support the various custom.

Responsibilities:

Designed database objects for collection, tracking, and reporting of administrative clinical data and Operational Product Data for IT Operational performance analysis using SQL Server Management Studio 2008/2012.

Identify, address and support issues in relation to the Hadoop environment by working closely with the various Inovalon teams.

Prepare documents and presentation materials describing multiplatform IT Automation design and solutions, analytic methods, observations and findings of analytics, and/or business logic flow employing MS office suite.

Extract Transform Load(ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS)

Perform root cause analysis to identify data flow issues/ system performance issues and/or data discrepancy issues of the IT Operations team.

Identify and Perform analytics on manual operational bottlenecks across various Product offerings for performance optimization and streamline IT operational deliveries.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries

Understand Products, processes and procedures to support the ticket requests that come from various business teams.

Involved in designing and developed software product applications for automating the manual Operational tasks across various Product offerings. Involved with full software development lifecycle including testing, implementation and auditing.

Diagnose and address issues as necessary and work with product team to implement correction plan.

Ensures designs, code and processes are optimized for performance, scalability, security, reliability and maintainability; Works without supervision on highly complex projects

Worked on SQL Oracle database to extract data and build Business reports.

Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance jobs.

Member of our Agile Improvement team to support uniform rollout across our organization

Analyzed and assessed business processes by altering, manipulating, and retrieving data from SQL database.

Involved in creating Hive tables, loading with data and writing Hive queries which willconvert internally into MapReduce jobs

Supported strategic Agile/Lean growth in our organization organizing quarterly feedback, Agile workshops, and focused training sessions for new and existing teams.

Used SQL Server Management Studio to design, develop and perform advanced-level Data Analysis in support of the product offerings.

Environment: MS SQL Server 2008/2012, Microsoft Visual Studio 2010, MS Access, MS Excel, MS Visio, SQL Server Profiler, SSIS, SSRS, Hadoop, Windows, Linux, Agile.

Client: Fannie Mae, VA NOV 2015– OCT 2017

Role: SQL Developer/Data Analyst

Description:

Fannie Mae is a leading source of financing for mortgage lenders, providing access to affordable mortgage financing in all markets at all times and financing makes sustainable homeownership and workforce rental housing a reality for millions of Americans. My work is Planning and coding the database tables in order to store the application's data.

Responsibilities:

Created database tables, Indexes, triggers and other SQL objects as per business requirements.

Worked on optimizing large complicated SQL statements as part of performance improvement for speedy client deliverables.

Created SQL queries to facilitate the user to retrieve and create the formulary information of various plans.

Analyzed data using complex SQL queries, across various databases.

Worked on Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.

Help dev teams identifying possible containerized applications in the AWS environment.

Support the code builds by integrating with continuous integration tool (Jenkins)

Created required SQL queries to be integrated to Java code to meet the requirement for generating the user defined formulary reports.

Ensures designs, code and processes are optimized for performance, scalability, security, reliability and maintainability.

Python and PHP web application development using the SQLAlchemy.

Created and Maintained Database Maintenance Plans.

Configuring SQL Server Agent-Events, Jobs, Alerts, maintenance plans, Database Mail and Operators.

User creation, package update and maintenance of the infrastructure

Actively involved in unit testing, application testing and involved in deploying developed application.

Worked on Synergy as the repository.

Provided Business Analysis support and process improvement recommendations and supported the implementation of application enhancement.

Use SVN for source control, IBM Rational Tools for Tickets and Bug tracking, JIRA, Wiki and SharePoint for workflow and documentation.

Used service now tool for raising and addressing the tickets as per the requirement.

Coordinated with QA and Production team to for efficient client deliverables

Environment: MS SQL Server 2008/2012, SSIS, SSRS, Data studio, AWS, IBM Rational Tools, Windows, Linux, C++, Python, service now.

Client: Geico Corporate Office, MD JAN 2014–OCT 2015

Role: SQL Developer

Description:

Geico is one of the largest insurance providers which provides a wide range of safe, quality and affordable Car insurance coverage for individual and families. I had participated in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.

Responsibilities:

Contributed from design to implementation and maintenance phase of the application in AGILE environment/methodology.

Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes.

Created packages with override functions that could be utilized by other systems that interface with this application.

Created materialized views that refreshes data from other databases, via DB Links.

Performed data analysis primarily Identifying data sets, source data, source meta data, data definitions and data formats.

Provided assistance and support to programming team members as required.

Designed physical and logical data model and data flow diagrams.

Worked with several tools to access and perform several operations on database. Experience in generating reports.

Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Co-ordinate with multiple application development teams since the application interfaces with multiple systems.

Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created huge volumes of test data to test heavy data loads across multiple systems / databases.

Used joins, indexes effectively in where clauses for query optimization.

Assisted quality assurance team with any functional and regression testing efforts.

Worked on various tables to create Indexes to improve query performance. Involved in writing several queries and procedures.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Analyzed data using complex SQL queries, across various databases

Developed Tableau workbooks from multiple data sources using Data Blending.

Assisted quality assurance team with any functional and regression testing efforts.

Restricted data for users using Row level security and User filters.

Environment: MS SQL Server 2008/2012, Oracle 10g, TOAD, PL/SQL, UNIX, Shell Scripting, Tableau server versions (7.0 and 8.2), UNIX Linux, Windows, java, Control M.

Client: State of Indiana, In JAN 2011 – DEC 2013

Role: SQL Developer

Description:

State of Indiana provides support services to other agencies. My part is to Identify and write best possible code in case of new deployments or rewriting code when migrating to newer version of SQL Server.

Responsibilities:

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.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Analyzed data by creating simple SQL queries and identified fact and dimension tables.

Designed mapping using various transformations such as source qualifier, expression, joiner, sorter, union, etc.

Performed data analysis primarily Identifying data sets, source data, source meta data, data definitions and data formats.

Designed Physical and Logical Data model and Data flow diagrams.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Designed, constructed, and tested ETL processes. Created SSIS packages to extract data from the transactional and/or operational databases, transformed the data according to analytical / reporting business needs, and loaded the data into a data warehouse or data mart.

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.

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)

Expert in creating Star schema cubes using SSAS.

Extensively worked on OLAP cubes using SSAS.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Generated several drills down and drill through reports using SSRS.

Co-ordinate with data architects team, to import required source and target tables from specific database schemas

Create test data, that can be used in Unit testing most effectively

Perform load testing, with huge amounts of data to validate the performance of mapping.

Environment: MS SQL Server2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows 2008 Server, UNIX, Informatica 8.x/9.x, Web Services, Control M.

Client: NETAPP, BANGALORE Aug 2009 – NOV 2010

Role: Jr SQL Developer

Description:

NetApp solutions deliver modern backup-and-recovery capabilities to keep your business data safe and available: On premises. at remote offices. and in the cloud.

Responsibilities:

Built the PL/SQL (Procedures, Functions, Triggers, and Packages) and Informatica processes to summarize the data to populate summary tables which will be used for generating reports with performance improvement.

Registration of new forms, creation of concurrent executable and concurrent programs for reports, opening descriptive flex fields was done.

Analyzed, developed, tuned, tested, debugged and documented processes using technologies SQL, PL/SQL, Informatica, UNIX, and Control M.

Global IT services and solutions company providing value propositions to the clients in the areas of Banking and Financial services (BFSI) to redefine and impact the core of their businesses.

Loading Incremental Data to fact and dimension tables.

Tuned the application with functional Indices, Temp tables, right partitioning, data in sequence storage and avoid nulls, converting views into snap shots/tables, daily analyzing tables, with clause, window functions and avoiding full table scans, hints and explain plan and monitoring database.

Environment: Oracle 10g, 11g, TOAD, SQL Server 2008, Forms&Reports6i, PL/SQL, UNIX, Informatica 8.x/9.x, UNIX Linux, Windows, SVN, Control M.

Contact this candidate