SUMMARY

• Over all 9 years of strong IT experience in the field of Business/Data Analysis, SQL Server and BI, Abinitio Development
• Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing.
• Extensive knowledge in T - SQL queries (DDL and DML).
• Experienced in creating Tables, Views, Indexes, Stored procedures, User defined functions and other SQL joins and query writing.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS
• Experience in enhancing and deploying the SSIS Packages, SSRS Reports from development server to production server
• Excellent in developing most complex reports like Drill down, Drill through, Matrix, and Pie charts in SSRS and Expert in fine tuning the reports.
• Good Exposure in creation and running Autosys and Cron jobs.
• Involved in preparing design documents for ETL projects
• Good Exposure in creation and running Autosys jobs.
• Used Abinitio tool to Extract data from flat files, database tables, transform it to required format, apply business logic and load it into data warehouse.
• Developed wrapper scripts, Ab Initio graphs and UNIX shell scripts.
• Extensively used Air commands to import and export objects and sandboxes, Creation of tag,

TECHNICAL SKILLS

• UNIX SHELL SCRIPTING
• ORACLE SQL
• SQL Server Reporting Service 2005/2008/2013
• SQL Server Analysis Services 2005/2008/2013
• MS SQL Server Integration Service 2005/2008/2013
• MS Access
• C++ERWIN 4.0/4.1/4.2
• Windows 9x/NT/2000/XP/Server 2003
• T-SQL
• PL-SQL
• HTML
• Ab Initio 1.13
• BRE (Business Rule Engine)
• Data Profiler
• Cron scheduling tool
• Autosys tool
• Toad
• Informatica
• Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

Business Data Analyst/SSRS Developer

Responsibilities:

• Involved in designing and implementing database applications using MS SQL Server 2008/ 2012 and Business Intelligence (BI) tools to support transactions and business decision-making
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008
• Deploying SSIS packages from various sources like Management Studio, file systems etc
• Monitored performance and optimized SQL queries for maximum efficiency
• Responsible for creating reports based on the requirements using SSRS
• Advanced extensible reporting skills, developed SSRS reports & generated them on SQL Server 2005
• Used Subscriptions and Snapshots to set up Push based Report Delivery
• Responsible for scheduling the subscription reports with the subscription report wizard
• Designed and implemented SQL Server database objects (stored procedures, functions, views and complex T-SQL/queries) to support data integration (SSIS), reporting and various business processes

Confidential

SQL Server BI Developer

Responsibilities:

• Assist with the production operation of proprietary systems, ensuring schedules are set and system resources are used effectively.
• Create database objects - tables, views, and functions and develop procedures for implementing application functionality on database side.
• Data analysis and reporting of health plan information trends to answer business inquires.
• Monitor performance and optimize SQL queries for maximum efficiency.
• Load data from various sources like flat files; excel sheets to SQL Server database using SSIS Package.
• Created SSIS packagesto load monthly CCP data into the database.
• Filter data received from insurance companies and create new monthly patients list for call center department.
• Responsible for creating Summary reports, Sub reports, drill down reports, and matrix reports.
• Defining and developing of service catalog for system operations.
• Usedcursors, dynamic SQLto implement thebulk load.
• Createdviewsfor speeding up the response of SQL queries.
• Created SQL Server agent job for daily data load.
• Created various triggers and alerts for successful or unsuccessful completion of scheduled Jobs.
• Handled trouble tickets and issues posted by call center department.
• Created documentation as required.

Confidential

Abinitio Developer, BO Developer

Responsibilities:

• Analyzing the existing process for the current application data coming from different product processors.
• Worked on the design document/Solution Documents.
• Worked with Ab Initio Join, Lookup, Reformat, Sort, FBE, Replicate, Write Excel, Mail
• Component, Dedup Sort to remove duplicates, Partition and Departition components.
• Involved in loading the flat files received from source system into Warehouse table and transform and load into Mart Table and finally unload the data from Mart and generates the Billing file (which as Volume or Customer information) to the clients.
• Development of graphs and wrapper scripts for the project.
• Developed generic graph which creates lookup files as per the parameter passed.
• Developed SLA script which looks for the file which needs to be received from source system, if the file is not received a mail alert will be generated to source system that the source feed/file has missed the timing.
• Converted cron jobs into Autosys jobs.
• Prepared JILs and uploaded in Development environment and tested.
• Interaction with Quality support team to explain about the application which needs to be tested as per the requirement.
• Unit testing and integration testing.
• Prepared Deployment plan steps to migrate code into different environments.
• Prepared Solution document for the enhancements done in the existing application running in production environment.
• Contacting the existing CITIMIS application team members and coordinating with them to gather all possible information on the process.
• Analyzing the existing process for the current CITIMIS application Volume data and the new volume generated in production in pre-production environment.
• Worked on the design document/Solution Documents.
• Development of graphs and wrapper scripts for the project.
• Developed complicated graph which calculates the billing information based on the region and loads the data into Mart table.
• Developed generic graph which unloads data from Mart table and generates billing data based on different regions, in which region is passed as parameter to the graph.
• Developed generic graph which creates lookup files as per the parameter passed.
• Involved in performance tuning of the graphs.
• Developed graphs which unload data from mart table and transform to generate a report and send the report to client using send mail component.
• Created and uploaded autosys jobs in development environment for scheduling the graphs.
• Interaction with Quality support team to explain about the application which needs to be tested as per the requirement.
• Unit testing and integration testing, Interaction with User Acceptance Testing Team to run the graphs in UAT environment.
• Interaction with Production support team to migrating the code to Production environment.
• Prepared Deployment plan steps to migrate code into different environments.
• Designed and built Ab graphs for unloading data from different source systems
• Involved in preparing unit test cases and executing them.
• Involved in UAT Support & Enhancement’s
• Extensively used EME for version control, Created sandbox for check in and checkout process.
• Preparing JILS and uploading in DEV Environment, and tested the jobs through JILS
• Involved in Migration from DEV to SIT and UAT Environment.
• Communicating with AI Support Team for any GDE related issues.
• Implemented the EDW (Enterprise Data Warehouse) project from scratch.
• Designed and build Ab graphs for unloading data from diff source systems
• Generated Ab components and xfr from Abinitio BRE
• Involved in preparing unit test cases and executing them
• Extensively worked on Plan
• Involved in UAT Support & Enhancement’s
• Extensively used EME for version control, Created sandbox for check in and checkout process.