Data Ssis

VINEELA KONDAM

Email: *******.**********@*****.***

Mobile: 848-***-****

PROFESSIONAL SUMMARY:

Total 6+ years of IT experience in Database Design, Development and Business Intelligence tools (SSIS, SSRS, SSAS) of Microsoft SQL Server 2012/2014/2016 in Development, Test and Production Environment.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and having good knowledge on SQL Server Analysis Services (SSAS) and Power BI.

Experience working with both Agile methodology and Waterfall model.

Excellent in SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).

Proficiency at Tasks, Containers, Sources, Destinations and Data Transformations like Derived Column, Conditional Split, Union all, Merge, Lookup and Merge Join Transformations to load data into Data Warehouse.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Expert in creating Parameterized Reports.

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.

Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment

Expertise in writing Sub queries, Joins, set operations and stored procedures.

Having experience in creating Cluster index, Non-Cluster index and Column store index on tables for performance tuning.

Proficient in writing SQL, have written numerous custom SQL queries to validate reports.

Having knowledge on creating Blueprints/demos in power BI

Thorough Knowledge on Data Warehouse concepts like Star Schema, Snowflake, Dimension and Fact Tables.

TECHNICAL SKILLS:

ETL Tools

SQL Server Integration Services (SSIS)

BI & OLAP Tools

SQL Server Reporting Services (SSRS), Power BI, SSAS-Tabular Model

Databases

SQL Server 2012/2014/2016, Oracle 9i/10g/11g

Environment

Windows Server 2008, 2012.

WORK EXPERIENCE

Advantasure(Virginia) March2020 to till date

MSBI Developer

Advantasure is a Medicare company with healthcare clients to simplify their operations and accelerate their business success. Powered by our broad expertise and a comprehensive suite of product and service solutions, it helps health plans effectively navigate the complexity of healthcare. For clients, the results include a healthier bottom line for their business, and better health outcomes and experiences for their members. With knowledgeable representatives in locations across the country and serves a wide range of government healthcare programs in the Medicare and Commercial ACA markets.

Roles & Responsibilities:

Experience in gathering and documenting business requirements for analysis reports. Participating in requirements meeting and data mapping sessions to understand business needs.

Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer.

Worked on internal project to develop a performance Data warehouse.

Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.

Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.

Participated in creating reports that deliver data based on stored procedures.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Developed Multi-dimensional Objects using MS Analysis Services.

Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.

Designed and deployed various complex reports using MS Reporting Services.

Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports and Parameterized reports.

Analyzed reports and fixed bugs in stored procedures.

Designed and implemented stored procedures and triggers for automating tasks.

Involved in Trouble Shooting Complex Reports.

Created Large Number of Report Models for users to create their own reports.

Fine-tuned SQL queries for maximum efficiency and performance.

Configured the report viewing security for various users at various levels using Report Manager.

Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.

Environment: Microsoft SQL Server 2012, Microsoft Excel 2010, Power Pivot, Team Foundation Server (TFS), Windows 2008.

Health Care (INDIA) May 2014 to June-2016

SQL, SSIS Developer

It is a healing at home, provides hospital-quality healthcare in the comfort of your home. The company provide doctors, nurses, and physiotherapists for home visits. It also facilitates lab tests at home and medical equipment rentals, making health care more accessible to patients.

These solutions enable healthcare providers to gain insights into their own performance through a variety of metrics and KPIs that deal with finance, operations, clinical care, and other areas of operation. Using the information loaded into their own CRM application to improve performance, reduce costs, and identify non-compliant areas.

Roles & Responsibilities:

Involved in complete analysis of business requirement and understanding the functional workflow of their own CRM implementation.

Participated in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment.

Created data warehouse architecture to support new patient survey data, campaign data and leads converted into patient’s data.

Created SSIS packages to load data into Database using Various SSIS Tasks like Execute SQL Task, data flow task, Send Email task, Conditional Split, Derived Column, Lookup Transformations, Merge Join, Sort, Union All, Derived Column, Conditional Split, Data Conversion, Slowly Changing Dimension with Multiple Data Flow tasks.

Deployed SSIS project to SSISDB and created environment variables.

Created and Scheduled SQL Agent Jobs to run SSIS packages automatically.

Implemented fuzzy lookup to load the geographical information of patient.

Migrating existing tableau reports to SSRS reports

Identify and develop KPIs to support new benchmarking initiatives.

Created operational reports based on user requirement.

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

Created SSRS dashboards like patient lead conversion and drill down and drill through reports using SSRS.

Created ADHOC reports.

Environment: SQL Server Integration Services (SSIS), SSDT 2015, SQL Server 2014, SSRS.

Smart-ISO (India)

ANALYST JULY 2011 – May 2014

Smart ISO is ERP system whose purpose is for organizations to gain and maintain the ISO Certifications. This system handles the end-to-end process to attain the certification level for the organization and then enabling best practices, risk management and training process to maintain and build upon the existing certification level.

EHS role was to build the Training Management and Risk management piece of the ERP suite.

Training Management process which included Course Set-up, Participants competence and Candidate history maintenance.

Risk management included the risks to the attained certifications based upon the changing ecosystem within the organization and the associated assessment to contain the risk.

Roles & Responsibilities:

Engage client to gather software requirements/ business rules, and ensure alignment with development teams.

Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user case, user stories, work flows/process diagrams, data flow/data model diagrams.

Evaluate risks related to requirements implementation, testing processes, project communications, and training.

Identify and reconcile errors in client data to ensure accurate business requirements.

Draft and maintain business requirements and align them with functional and technical requirements.

Bringing new ideas and Process Improvement and facilitate monthly meetings with clients to document requirements and explore potential solutions.

Training Management:

Course Setup which includes course, tutor and locations setup

Participants competence included setup positions against organization, allocate courses, participants linking to course

Candidate data maintenance and Documentation of the complete Business workflow for transitioning the system over to customer for selling to perspective consumers.

EDUCATION

Bachelor of Technology in Electronics and Communication Engineering from Jawaharlal Nehru technological University, May 2011.

Contact this candidate