SUMMARY:

• Microsoft Certified Business Intelligence Developer with 5 years of work experience in developing Business Intelligence applications and enterprise Data Warehouses at various phases of SDLC.
• Extensive experience on developing Business Intelligence applications with SSISand SSRS.
• Worked in teams on software development and best practices for developing BI applications.
• Experience in Web Services using XML
• Experience in writing complex SQL queries involving multiple tables inner and outer joins
• Experience in Performance Tuning and Optimization of queries and stored procedures
• Excellent interpersonal and communication skills, creative, research - minded, technically competent and result-oriented with problem solving and leadership skills.
• Highly motivated, self-starter that is also passionate about technology. Assesses and addresses a client's business needs and use right tools and frameworks to build effective solutions.

WORK EXPERIENCE:

Confidential

SQL SSRS\SSIS ETL Developer

Responsibilities:

• Have developed and maintained T - SQL Stored Procedures, User Defined Functions and Data Models according to the business requirements.
• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Created and developed database objects such as tables, indexes, views, stored procedures, User Defined Functions (UDFs), triggers, and T-SQL code with proper grants to all the users and roles using SSMS 2008.
• Documented all database objects, procedures, views, functions & packages for future s.
• Build the SSIS packages to load the Data into Staging.
• Implemented complex SQL queries using joins, sub queries and correlated sub queries.
• Created SSIS Packages to perform filtering operations. Migrating data from the OLTP system and multiple excel files to SQL server.
• Extensively work in designing & deploying SSIS packages for transferring data from heterogeneous data to and from SQL Server.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Involved in monitoring and troubleshooting complex packages by using data viewers, debugging and maintenance of ETL packages and its optimization using SQL server best practices.
• Created packages to migrate data from different data sources to data warehouse.
• Created reports using complex T-SQL queries, user defined functions, stored procedures and views and defined the report layout and identified datasets for the report generation.
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports using Reporting Service for the business requirement.
• Processed and generated reports for the end business users on a daily, weekly, and monthly basis.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into servers using SQL server integration services (SSIS).
• Troubleshoot T-SQL, SSIS and SSRS errors and performance issues and address them as required.
• Organized and communicated with clients via face-to-face meetings, conference calls

Confidential

Pharmacy Technician

Responsibilities:

• Make outbound calls to Humana members
• Educate memberson alternative medications and opportunities for cost savings
• Helping our members to maximize their benefits and get the most from their Humana insurance
• Drives health awareness with patients through Rx and targeted quarterly campaigns

Confidential

Software/Production Support

Responsibilities:

• Update 24 or more incidents per day Escalations follow up Point of contact for client and customer escalations Review incidents and escalations
• Provides case status updates to Customer and Retail Solutions personnel. Ensure customer satisfaction by advising customers on preventive measures, appropriate solutions and configurations which may impact product performance. 24/7 operation - 8 working hours shift
• Troubleshoot and perform root cause analysis of reported incidents when they relate to desktop computer and peripherals
• Provide Event Management support including
• Daily monitoring / checks
• Logging of noted issues
• Troubleshoot or assist in troubleshooting of data center related issues
• The selected candidate will have strong communication skills and look forward to interacting with customer and Retail Solutions division personnel including:
• Support Center Team members
• Retail Solutions division engineering staff
• Management and Administrative
• Provide case status updates to Customer and Retail Solutions personnel
• Develop or assist in development of documentation and standard operating procedures and customer serviceguidelines relating to IT support of Retail Solutions support systems via SQL server.
• Phone Support receiving Customer and Retail Solutions personnel support calls
• Managing Customer and Retail Solutions personnel support calls including:
• Logging and support through trouble shooting or advising
• Logging and escalating or routing call as required

Confidential

IT Specialist Sr

Responsibilities:

• Provide local IT support for Programmer/Analyst that targets the administrative business. Creates reports in Microsoft SSRS, writes MSSQL stored procedures (SQL 2008/SQL 2016).
• Can understand and convert VBA with MS Access/MS Excel to MSSQL. Capable of programming with Visual Studio 2017 in C# (Winformsor WPF).
• Has a working knowledge of XML/XSL. Able to build MSSQL SSIS packages.
• An understanding of Visual Basic 6 (no programming involved).
• An understanding of Java/Tomcat would be a plus (no programming involved). LabView/Matlaba plus.
• Verbal communications, Able to work in a team environment, Document processes Installing, designing, developing, performance tuning and query optimization in Microsoft Database Server (MSSQL) Installing, designing and developing in SQL Server Reporting Services (SSRS).
• Installing, designing and developing in SQL Server Integration Services (SSIS). Installing, designing and developing in SQL Analysis Services (SSAS). Creation of VB 6 and MS Access Applications