SUMMARY

• Technically sophisticated and business - savvy management professional with a pioneering career reflecting strong leadership qualifications.
• Experienced in enterprise system planning, architecture, design and development design cycle.
• Extensive experience in database design, data modeling and data warehousing with Confidential, SQL Server, and redshift.
• Self-motivated team player with excellent communication skills.
• Superior record of delivering simultaneous large-scale, mission critical projects on time and under budget.

TECHNICAL SKILLS

Languages: Java, Visual Basic, ASP, PL/SQL, UNIX, ASP.Net

Hardware/Software: Microsoft Windows, Microsoft Office 2003 and XP, Windows NT Workstation, Microsoft FrontPage, ASP, Visio, XML, Microsoft Project, Confidential Developer 2000, Crystal Reports 9.0,SQL Query Builder

Databases: SQL Server 2005, Confidential 10.0, Mongo, Redshift

PROFESSIONAL EXPERIENCE

Confidential, Florida

Lead Developer - Data Warehouse

Responsibilities:

• Developed a high performance, scalable data architecture solution that incorporates a matrix of technology to relate architectural decision to business needs.
• Analyzed and defined detailed MDM processes, tasks, data flows, and dependencies.
• Produced database code (SQL, stored procedures) solutions in order to meet the business requirement.
• Identified issues and developed procedures for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in data warehouse.
• Built and published customized interactive reports and dashboards, report scheduling with Tableau Server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and user filters.
• Built dashboards for measures with forecast, trend line and reference lines.
• Created a lot of custom reports for the accounting system using complex stored procedures and crystal report.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Involved in analysis of source systems, business requirements and identification of business rules and creating low-level specifications for ETL.
• Developed, unit tested and supported various testing phase for the ETL processes.
• Extracted data from various source systems like XML, CSV, mongo, SQL Server, Salesforce, Accounting, etc.
• Created SQL jobs to extract data from legacy SQL Server to Reporting SQL server.
• Developed documentation for all ETL processes.
• Database Administration for SQL Server.
• Monitoring space in Red shift and also using vacuum command in reducing the space in red shift.

Environment: Tableau, etLeap, MongoDB, RedShift, AWS, Agile, SSRS, SSIS, Crystal Report, SQL Server, MS Office Tools, Text editing tools, JIRA, Confluence, C#.

Confidential, Florida

Director of Development

Responsibilities:

• Directed design and development of Student’s Self Service Financial Aid system.
• This enabled student complete their financial aid process by themselves from start to finish.
• The students were also able to complete their forms online thus reducing the cost of collecting documents drastically.
• Managed team of developers and business analyst in working on financial aid and Finance projects.
• Also, managed team of developers and QA’s offshore.
• Delivered over $2 million in cost savings through system automation and improvements.
• Implemented Scrum methodology in development of all projects.
• Oversee analysis and development for Marketing, Admissions and Financial Aid and Finance projects.
• Streamlined, standardized and documented various processes in the organization.
• Implemented Six Sigma methodologies in the execution of projects.
• Effectively mange requirements gathering process and project planning activities.
• Ensured that deadlines, quality standards, and client expectations are met.
• Understand Stakeholders requirements for analyzing data and provided them the reports they have requested.
• Managed the development of the product in partnership with Campus Management (CMC) using Scrum methodology.
• This was developing and automating the Financial Aid portion of their application.

Confidential, Miami, Florida

Technical Lead/Development Manager

Responsibilities:

• Implemented a reporting portal which provides cradle to grave reporting to the clients.
• This portal provides the VDN the call came in, the skill/split it gets routed through a vector command, the agent who receives the call, the disposition that the agent selects in the application.
• This is also a great tool for our clients to know how many calls came in the switch (Calls Offered) and how many calls were actually answered (ACDCALLS).
• Implemented the NICE recording software in order to record the application and voice of our agents while on the call.
• This recording tool has greatly helped us in training, monitoring and improving the quality of our agents.
• Random recorded calls are selected by our call center supervisors and reviewed.
• Implemented one of the most robust CRM applications for one of our clients.
• This application has been developed in Java and four web logic servers are available for this application.
• The request from the application can go to one of the servers.
• The customer information, in the application, gets populated by the ANI coming from the switch.
• The ANI in our case is the customer’s home phone number.
• The application has also the ability to search for a customer manually.
• The application also displays the details of the call history by a particular customer.
• Ensured that deadlines, quality standards, and client expectations are met.
• Coordinated teams from telecom, quality, design, training, tooling and purchasing.
• Manage requirements gathering process and project planning activities.
• Served as a liaison between staff and clients, earning their confidence with reliable follow-through and clear communications.
• Gather and document functional and technical requirements for application enhancements and modifications.
• Facilitate requirements gathering sessions among business line management and assist in defining processes to streamline business activities.
• Create Use Cases and additional project artifacts to support requirements and processes. Present requirements and manage lifecycle of requirements set.
• Worked extensively in data warehousing, data mining, crystal reports, Confidential procedures, SQL procedures, DTS, java, VB, ASP and SQR.
• Create data models and supporting table structures to normalize database.
• Communicate project plans and tasks to team members for daily activities. Develop and implement processes for requirements lifecycle.

Confidential, California

Programmer Analyst

Responsibilities:

• Worked in developing systems like Personnel Information System, Material Requirements Planning, Customer Servicing system and Car Rental system.
• Developed many PL/SQL procedures and packages for the system.
• Developed menus to access to different forms.
• Used Property classes to set common properties of items thus reducing lot of development time and Visual attributes for standardization of forms.
• List of values were associated with various record groups to display all the lists.
• Record groups were used to increase performance. Used Reports 2.5 to generate reports for the system

Environment: Oracle7.1 with Developer 2000, Forms 4.5, REPORTS 2.5, SQL, PL/SQL on UNIX, Windows NT