SUMMARY

• 9 years of IT work experience n SQL and ETL
• Experienced in working for waterfall and agile methodologies
• Proficient in delivering out ETL solutions.
• Great communicator. Has been handling communication with teams in different geographic locations

TECHNICAL SKILLS

Development/Productivity Tools: ETL(MS - SSIS), Informatica (PowerCenter), Azure, SQL, PL/SQL, Tableau, SSAS, Curion, MS Visio, Visual basicDomain: MS Project, MS-Office 2000, @Risk, Anylogic, Six Sigma concepts, Data mining tool Rapidminer, IBM SPSS

Databases: Logistics, Hospitality, Billing, Quality Metrics and Insurance

Certifications: MS SQL Server 2000, MS SQL server 2008, DB2,MS Access

Certified Scrum Master: Microsoft Certified technology Specialist in Data warehouse

Awards: People Developer Award from Accenture

PROFESSIONAL EXPERIENCE

Confidential

IT Developer

Responsibilities:

• Work on Informatica job migration between servers. Debugging and problem resolution in the workflows.
• Came up with a test plan and worked on parameter files, shell scripts etc in QA server, found and fixed issues by modifying workflows single handedly and checked their working in the production server
• Maintain invoice data for Finance team which they use for book keeping purpose in backend (SQL Server tables) in addition to the OLAP cube built using MS-SSAS.
• Make ETL package to import data in to the database tables. Run queries to identify errors with data (for example, categories, sales representative new in the system etc). Communicate with Business to get the data fixed and then import the data. Also responsible for any enhancements related to existing OLAP cube and developing a new OLAP cube.
• Create new ETL solution from scratch i.e. from requirement gathering to package deployment
• Work on SQL job migrations between servers. Responsible for end point identification, configuration file changes, check if job was successful, fix errors if any
• Responsible for ETL-SSIS job upgrade to run on new SQL Server 2016, which included upgrading the SQL driver version in packages as well as configuration files, building and executing the packages from visual studio, fixing any errors and saving the package on server

Confidential

IT Developer

Responsibilities:

• Created automated packages on Business Intelligence tool SSIS that imports data, applies business logic and stores output files as per client specification
• Created OLAP cubes using Microsoft SSAS to create data marts for different teams that helps them verify the data easily without accessing database
• Worked with Azure blob storage & Tableau
• Worked on Stored procedures to implement repeatedly used SQL queries.

Confidential

Intern/ Team Lead

Responsibilities:

• Lead a team of 2 interns to solve business problems
• Created Problem statements
• Created Anylogic simulation models, to simulate the current and proposed situations to help management compare these systems without investing capital on changes on a real time
• Created documents for the tasks undertaken
• Well versed with using process mining tool; Disco; to map business processes which helped us learn about the roadblocks in the current established process

Confidential

Business Analyst, Developer & Team coordinator

Responsibilities:

• Took requirements/report requests from clients and worked on them
• Investigated the root cause of the issue
• Worked on SQL queries on Teradata, SQL database
• Resolved open work request through regular status checkpoint meeting with the team
• Created metrics report for the team to learn the resolution rates of work requests which helped identify areas of improvement and assess team performance
• Worked with diverse groups of people in distributed geographical locations, as the DB2 backend was in Malaysia, and reports of the query after execution was analyzed in Manila
• Met all the deadlines without any slippages

Confidential

Senior Software Engineer

Responsibilities:

• Created SSIS packages from scratch and also fixed a few old ones.
• Worked with deployment team to get the changes and packages deployed in production
• Created Requirement, Test and Deployment documents from small fixes to enhancements
• Used flowcharts, use-case and activity diagrams for “Detailed Design” documents using Visio tool
• Rewrote the application in ”Curion” to meet Client specific requirements
• Worked extensively on stored procedures and wrote a few dynamic stored procedures to accept parameter value and return the result on the go
• Trained new employees and created hands-on guides for their reference
• Extensively involved making sure clients daily reports were reaching clients on time

Confidential

Software Engineer

Responsibilities:

• Enhanced the Billing application written on Visual basic which read the resource efforts from MS Project workplans to Accenture internal workplans
• Used Visual basic for access to automate Project Key Performance Indicator excel sheets which helped in assessing a project’s health
• Created automated reminders using DTS packages to send mails to resources and their leads when the task they were involved with approached its deadline
• Created automated batch jobs to take backup of the SQL data on a monthly basis as a part of risk management
• Automated work progress report for teams, which reduced the manual effort of updating task sheet from 4 hours weekly to half an hour a week
• Trained new employees on daily job expectation
• Helped Project Managers with their work-plans, restoring them when they got corrupt
• Coordinated weekly with client team members in USA