Venkat Ramireddy

201-***-****

MSBI MSSQL Server and AWS Developer

ada5n2@r.postjobfree.com

Professional Summary

A MS-BI (SSIS, SSRS, and SSAS), SQL Server and AWS programmer having t 9 Years’ of IT experience in Application Development.

Have worked in multiple projects as BI Developer in Designing Database, ETL Packages and Reports in development and implementation stages of the Project according to client requirements.

Effective communication skills with excellent work ethics and a proactive team player with a positive attitude. Domain Knowledge of Legal, Finance and Health insurance.

Strong experience on T-SQL and query optimization, developing ETL strategies.

Excellent communication skills bridging Client Interaction and Team Management.

Strong analytical, problem troubleshooting/solving skills, self-starter.

Be able to convert/implement the design decisions into business functions and service definition.

Self motivated individual with strong analytical and problem-solving abilities, Proactive, Dedicated, enjoy learning modern technologies and willing to take on extra responsibilities to get work done.

Expert in automating SSRS report deployment process.

Carried production rollout of SSRS Reports and windows application at client location.

Certified as MCSA in SQL Server 2012 & Business Intelligence.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Adaptive to Cloud Strategies based on AWS (Amazon Web Services).

Technical knowledge on EC2, IAM, S3, VPC.

Excellent exposure on Provisioning Systems, Automated Build Platforms.

Practical usage of Amazon Glacier for archiving data.

Own the technical solution design, lead the technical architecture and implementation of data acquisition and integration projects

Knowledge on Writing Python Scripts and understanding Python OOP

Exceptional analytical, conceptual, and problem-solving abilities

Identify incomplete data, improve quality of data, and integrate data from several data sources

Monitor logs for better understanding the functioning of the system

Experienced in migrating database to AWS cloud ecosystem using Services like VPC, EC2, S3, EMR, RDS for Compute, Big Data Analytics and Storage

Designed and created databases, tables, views, store procedures and triggers.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. Rebuilding the indexes at regular intervals for better performance.

Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join.

Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.

Expert in migration of databases from Oracle and non-oracle sources to SQL databases using 2008 SSIS (SQL Server Integration Services).

Expert in creating several types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Extensive knowledge in designing reports using cascading parameters, Parameterized reports, report models for Adhoc reports using SQL server Reporting services (SSRS) based on requirements.

Experienced in performance tuning using SQL profiler identified slow running queries and optimized the queries to see that it will not affect the server performance.

Expert in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services (SSIS) with C#.

Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent

Educational Qualification

Master of Computer Application from Jawaharlal Nehru Technological University India.

Certified Microsoft SQL Server 2012 Developer (MCSE Exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012).

Software Proficiency

Languages

C#, T-SQL, Java and XML, PowerShell

Business Intelligence

SSIS, BIDS, SSRS and SSAS

Operating Systems

Version Control

Windows 2008, XP, MS-DOS

Team Foundation and Git

Framework Experience

Microsoft .NET

DBMS

SQL Server 2012/2008/2005, Data Modeler, DataBase Administrator, Database Developer

Applications & IDE

Visual Studio.NET, Business Intelligence Development Studio

Desktop tools

MS Excel, MS word, MS outlook, MS access.

Cloud

AWS

Professional Experience

Experience with Verisk Analytics Nov 2015 to till Date

Client: Verisk Analytics, NJ

Nov 2015 – Till Date

Project: JDE (Joint Development Entity)

Role: Developer2

JDE is an enterprise project at Verisk with objective of creating an analytical sand box for the enterprise that includes a data repository of key Verisk data assets that is linked and normalized for ease of Analytics and research. JDE will be used for internal R&D purpose to investigate and boot strong commercialization opportunities utilizing inter connected data from one or more sources from Verisk. JDE extract and data load from multiple business units. We have implemented an integrated Verisk Enterprise data model. The data from BU’s is transformed and loaded in to the integrated Verisk JDE Data Model. JDE perform Entity resolution across all data assets and links to the data in terms of Individual, Business, Assets, class and geography

Responsibilities:

Involve in full life-cycle implementation of a large data warehouse.

Consolidate and analyze all the data models that are required for building the data warehouse.

Develop SSIS packages, SQL Scripts for loading billions of data across various products and for data cleansing.

Assist architects in development of algorithms used to perform data matching

Developing algorithms to optimize the setting of every lever in a high throughput real-time decision system.

Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, UAT and Production Environments.

Actively giving supporting to business users in the day to day operations.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.

Re-write Batch scripts identified to be retained or updated in PowerShell

Designed, developed and maintained the SSRS reports

Maintained database performance by normalization, indexing, collecting statistics, etc

Independently develop queries to extract, manipulate and/or calculate information to fulfill data reporting requirements

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Managed SQL database user accounts, user logins, permissions, database and server roles

Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

Performed daily tasks including backup and restore by using SQL Server 2008R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Worked within a lean agile environment and continuous delivery, did pair programming with co- developers, regularly involved in estimation and planning.

T-SQL stored procedures with parameters and without parameters and complex SQL queries with custom coding for dynamic tables. Deployed and shared the reports with rules and permission

Work Experience as a member of AWS Build Team.

Setup and managed EBS Volumes and EIP to EC2 Instances.

Designed AMI images of EC2 Instances by employing AWS CLI and GUI.

Created and Managed User Accounts, Log Management, Shared Folders, Reporting, Group Policy Restrictions, etc.

Responsible for Troubleshoot various network problems, system problems like Core Dump Analysis.

Infrastructure Development on AWS by employing services such as EC2, RDS, Cloud Front, Cloud Watch, VPC, etc.

Worked with Management frameworks and Cloud Administration tools.

Environment: MSSQL 2008R2,C#, SSIS, SSAS,SSRS Visual Studio 2008

Client: AmeriHealth, Fort Washington, PA

Jun’14 – Nov2015

Project: LEAP (Lead Excellence, Adopt, Performance)

Role: Developer

Description: LEAP is a migration project from Mainframe system to EDW system. AmeriHealth contain multiple applications system i.e. Health roles, mainframe systems, IRS, LDW and Legacy systems and CMS Reporting those application data needs to integrate with EDW system

Projects Worked on: CMS and IRS1099

Responsibilities:

Involved in meetings with business Users and Analyst’s to gather the requirements.

Designed SSIS frame work as per business flow and share with offshore developers for implementing the functionality.

Involved in Monitoring and assigning the tasks to team members to meet the project deadlines.

Used to prepare deployment docs along with deployment check list while moving code changes to QA/UAT or PROD environments

Required to assist and coordinate with DBA team for smooth deployment.

Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).

Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.

Defined Check constraints, Business Rules, Indexes, and Views.

Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into a normalized database structure. Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2012.

Environment: MSSQL 2012, SSIS, SSRS, SSAS, Visual Studio 2008/2010, SharePoint

Experience with Accenture

Client: SHELL Group, London, UK

Dec’13 – Apr’14

Project: SHELL Work Flow Business

Role: Developer

Description:

In the current Einstein tool, there are pain points such as time taken by the tool to record performance metrics primarily due to how it’s designed as it needs continuous manual data input from users at multiple stages. Number of man hours currently spent is not best value obtained from the current staff. The reports generated by the tool (once a week and once a month) are dependent on the workflow data to be received. The longer that data takes to get entered, the longer the reports wait for that piece of information. Any change in the business process, needs a change in the reports. The sole developer of the tool does not have enough time to maintain the tool going forward. There might be data inaccuracies in the tool which needs to be investigated.

The Einstein Replacement tool should possibly eliminate the addressed pain points that most of the FOD users are facing in the current Einstein tool. This could be achieved by developing a single repository solution that will replace current Einstein for all the process area with an integration of the source system and produce a real-time metrics report. The new tool will also produce a real time leading indicator that show the real time metric report for the FOD users in all locations.

Responsibilities:

Developing SSRS Reports like Sub Reports, Linked Reports and Graphs

Designing Stored Proc and Functions.

Gathered user requirements, draft specs and developed SQL queries and SSRS Reports.

Developed client reports (rdl’s files) and integrated it into WPF application using report viewer control.

Configured reports in custom administrative portal.

Designed and developed Drill-down, Drill through, Summary, Transaction Print and Sub Reports using SSRS.

Scheduled reports to automatically generate bi-weekly report for Administrators of CMS Application.

Generated multi parameterized cascade reports, providing the ability to narrow down the selection criteria before executing reports, thus making them user friendly.

Provided MS SSRS 2008R2 training to the business and maintenance teams to develop their own ad-hoc reports.

Deployment in SharePoint environment

Involved in creating writing the scripts for creating tables, functions and views.

Involved in client interaction and reviews and actively participated in solving the issues.

Environment: MSSQL 2012, SSIS, SSRS Visual Studio 2010

Experience with Genpact INDIA

Client: Physician Health Partners, Denver, CO

Jan’13– Nov’13

Project: PHP (Health Care Insurance)

Role: Team Lead and Developer

Description:

PHP (Physician Health Partners) is an integrated team of physicians and healthcare professionals committed to supporting effective patient care throughout the healthcare continuum. PHP offers a range of services to help its primary care providers deliver high quality, cost-effective care for their patients. PHP also provides services directly to patients/members to help enhance their overall healthcare experience and outcomes.

Responsibilities:

Managed resources in onshore and offshore environment. Worked with XML transformations.

Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system. Worked on data modeling.

Applied knowledge of Normalization and De-Normalization techniques. Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).

Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).

Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.

Performance tuning of Stored Procedures and T-SQL Queries.

Created logins, users and configuring permissions and assigning roles to users.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into a normalized database structure. Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).

Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.

Implemented BCP/ETL Scripts for data transformation

Resolve SQL Job failures

Design and ensuring the Physical and Logical Model are in synch with every release

Optimize Data and Log management throughput and availability

Defined Check constraints, Business Rules, Indexes, and Views.

Environment: MSSQL 2012, SSIS, SSAS, Visual Studio 2008.

Experience with Polaris Software Labs

Client: CITI Group, Warren, NJ

Oct’10 - Decl’12

Project: GFTS Legal–Law Manager

Role: Senior Developer

Description: A Matter is a legal case in the court of law and LM is used to maintain Matter and its related info created by legal user (a lawyer of CITI or his/ staff). Matters are entered using different notebooks depending on the type of matters: Matter Notebook for Corporate and consumer users, EMEA Matter notebook for EMEA users, and CGMI matter notebook for ICG matters. All matters are also available in CGMI notebook. Matter is assigned to Entities Internal Entities such as Primary Manager, Secondary managers, Business Contact etc. (Stored on Matter Assignment tab of the matter notebooks) External entities such as Firm Provider (Law Firm working on the case), Opposing Firm (Stored in Counsel Tab of matter notebook) Primary Manager is mandatory for Matter Creation Gatekeeper is also assigned to a Matter if required. Every matter will have a cost center assigned to it to which the expense will be allocated to this matter. One single matter can have multiple cost centers.

LM interacts with other apps in offline mode except for AIMS where it is real time for invoicing, payments, entity information, etc. The status of the matter is updated manually by the end users.

Responsibilities:

Studied the current transactional database to understand the existing system and created the approach documents for the migration task.

Integrations between law managers to other applications.

Perform investigations and make appropriate suggestions on various services and to meet the development efforts.

Responsible for designing, coding, and testing the applications and programs of Business Intelligence Specialist system.

Designing and developing the SSIS Packages.

Created and managed schema objects such as tables, views, procedures, and functions.

Extensive experience in writing functional specifications, translating business requirements to technical specifications.

Implemented BCP/ETL Scripts for data transformation.

Development of data extract, transform and load (ETL) programs using Microsoft SQL Server, including T-SQL, DTS and SSIS.

Optimize Data and Log management throughput and availability.

Proactively monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.

Ensure all database environments (Development, Staging, QA and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.

Involved in Debugging and Deploying reports on the production server and analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.

Created SQL Agent Jobs for scheduling SSIS Packages, SSRS reports and alerts.

Configured and fine-tuned all the ETL (Extract, Transform and Load) workflows.

Identified slow running queries, optimized stored procedures, tested applications for performance and data integrity using SQL Profiler.

Understanding Business Specification document /Source map document for creating packages and Reports

Involved in migrating the data from their existing ERP system using SSIS into our project

Actively giving online support to implementation and support team deployed at client places.

Implemented Maintenance Plan task like backup task, shrink database task and rebuilt Indexes task.

Successfully installed MS SQL 2008R2 and configured SSRS reporting server.

Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).

Used SQL Server Reporting Services (SSRS) to generate reports.

Created various admin reports using SSRS that fetch the data from various data sources and display a summary report.

Enhanced existing SSRS reports in Meter History system.

Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.

Responsible for development of Procedures, Functions and database Triggers.

Designed Data was stored in MS SQL Server. Created indexes and analyzed its role for optimizations

Support migration and upgrade of Databases. Designed the dimensional data mart and developed SSIS packages to validate

Database Performance monitoring and tuning.

Backup and recovery of Databases.

Environment: MSSQL 2008R2/2012, SSIS, SSRS, SSAS, Visual Studio 2008/2010, SharePoint

Contact this candidate