SUMMARY

• About 11 years of combined experience on Database Administration, Business Intelligence Development (SSRS, SSIS, SSAS), and Database Development along with Project Management and web based application development
• Complete understanding of software development life cycle
• Experienced to define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders
• Experienced to communicate effectively about project expectations to team members and stakeholders in a timely manner
• Experienced to evaluate change requests, provide impact analysis, cost and effort estimates
• Experienced with scrum methodology
• Excellent analytical, problem solving, communication, organizational, and interpersonal skills
• Good understanding of Systems and Software Standards and Requirements, Software Process Definition, Software Maintenance, Software Design and Architecture, Software Verification and Validation, Software Measurement, Software Project Management, Professional, Ethical and Legal Issues for Software Engineers etc

TECHNICAL SKILLS

Database: Sql Server 2005/2008/2008 R2/2012/2014

Reporting/Data Analysis Skills: Sql Server 2005/ 2008/ 2008/2012 R2 Reporting, Cubes, Excel Reporting

ERP System: Microsoft Dynamics AX, Great Plain

Data Warehousing Skill: Sql Server 2005/ 2008/ 2008 R2 Integration Service

Database programming skills: Sql, T - Sql, Stored Procedures, Functions, Triggers, Schema, Views

DBA tools and utilities: Performance Monitor, Database Engine Tuning Advisor SQL Profiler, Query Analyzer, performance dashboard reports, upgrade advisor, SQL Server Configuration Manager, Surface-area configuration, Object Explorer, SQL Server Agent, Resource Governor, Performance Data Collector etc

Web Skills: C#, ASP.Net 2.0, VB6.0, ADO.NET, XML, C,C++, JavaScript, HTML, DHTML, XHTML, XML, XSLT, XPath, XSD, DTD, CSS

GUI: Sql Server management studio 2005/2008/ 2008 R2, Visual Studio.Net, Visual Studio 2005/2008, Visual basic 6.0

Web Design, Testing and Analysis Tools: Macromedia Flash, Dream Weaver, Macromedia Director MX 2004, Photoshop 7.0, Fiddler, firebug, Yslow, IE Cookie View, Internet Explorer developer toolbar, Microsoft web application stress tool, win merge, Cook top, Google analytics reporting, DART, commission junction.

PROFESSIONAL EXPERIENCE

Confidential

DBA

Responsibilities:

• Install, maintain and upgrade SQL Server tools, and patches.
• Allocate system storage and plan future storage requirements for the database environment.
• Enroll users and maintain system security.
• Ensure compliance with License agreements.
• Control and monitor user access to the database environment.
• Monitor and optimize the performance of the database and ERP and Warehouse Management Systems. Analyze systems and recommend system improvements or corrections.
• Plan for backup and recovery of database information.
• Maintain archived data on appropriate storage devices.
• Backup and restore the databases, to include review of current processes, defining requirements, making recommendations, and implementing new processes, as required.
• Perform all maintenance duties on a regular basis.
• Formalize a plan and write up troubleshooting procedures. Update system procedures as appropriate.
• Maintain accurate and current knowledge of IT integration and industry trends.
• Maintain expert knowledge of SQL Server and Oracle Databases.
• Maintain working knowledge of ERP Application modules in all business areas.
• Ability to analyze changes and enhancements to software and determine the impact on existing production, systems, system design, programming standards and operating procedures.
• Periodic Importing, Exporting, Updating, Inserting, and Deleting of data to support the business's needs
• Planning and implementing service packs and version releases of new database software.
• Maintaining up to date accurate Entity Relation diagrams of all databases within areas of ERP, Datamarts, etc; and maintaining how each area relates to one another through interfaces and application customizations
• Participate in the development or modification to new or existing systems.
• Recommend new systems software and hardware to provide data processing solutions.
• Provide guidance on Data Warehousing, Mining and reporting.

Confidential

SSRS Developer

Responsibilities:

• Upgraded reports from SSRS 2005 to SSRS 2008 R2.
• Reviewed reporting environment which had many inaccurate, inefficient, inconsistent, and redundant reports. Defined, fixed, merged, and replaced those reports with accurate, efficient, fast, and user friendly reports.
• Consolidated more than 300 SSRS reports into 100 effective reports.
• Worked on loading source code onto code repository called TFS.
• Reviewed NEC phone system reports and replaced 25+ NEC reports to 5 different SSRS reports.
• Worked with business team to define logic for reports.
• Production support of SSRS.
• Trained on Talend.

Confidential

Reports Developer and Analyst

Responsibilities:

• BI solution for students system
• Gathered student’s information from different systems called Vocado, RGM(mainframe), RGM web(Dot Net),Smart(MS Access),Fame(MS Access),Placement(Visual Basic),and Job lead (MS Access ) using SSIS. Created jobs to these packages, created SSAS Cube for management team, created SSRS reports to submit to accreditation agencies like Naccas, BPPE Data sources were XML for Vocado, Unformatted Text file for RGM, Sql server for RGM web, excel file for Smart, excel file for Fame, sql server for Placement, and MS Access for Job lead
• Eliminated weekly manual reports going to 64 schools, 11 regions and management team with reports created from this process
• Clinic Sales Bonus Process
• Wrote stored procedures to extract, transform, and load data into data warehouse from 16 different servers of POS system. POS system was handled by third-party called Guest Vision.
• Wrote SSIS package to download backup file from FTP server of central POS system and restore to a database
• Developed SSIS package to upload an excel file provided by Budgeting department every month
• Gathered data from above three steps and created a SSRS report for management
• Survey Monkey Reports
• Developed a SSIS Package to load csv file downloaded from survey monkey website into datawarehouse
• Developed few SSRS reports on students instructors survey
• Designed a database for job lead application
• Developed Students Employment Trend Report from placement system
• Created Employee hired and terminated reports from Microsoft Dynamics GP
• Created an analysis service cube for payroll from Microsoft Dynamics GP
• Implemented Security on Data level of reports which is not provided by Microsoft
• Assisted Management team to extract reports from budgeting application called forecaster

Confidential

DBA(contractor)

Responsibilities:

• Act as a production support DBA
• Gather requirements, design, develop and support SSRS Reports
• Analyze existing SSRS reports and improve their performance, design
• Understand user’s need by looking into their excel reports created by them manually and convert them to SSRS report
• Convert access reports into SSRS reports
• Manage subscriptions, distribution of reports
• Resolve Microsoft Dynamics AX 3.0 issues
• Assist users with Microsoft Dynamics AX 3.0

Confidential

DBA / Reporting Analyst

Responsibilities:

• Act as a production support Database Administrator
• Design, develop, and maintain data warehouse
• Design, develop, distribute, and support reporting service projects
• Support database applications throughout dev/test/prod life cycle
• Perform Installation and configuration of new database environments
• Perform performance tuning, query optimization, index design and tuning
• Write and debug complex stored procedures, T-SQL scripts, troubleshoot various database issues and T-SQL queries
• Maintain and monitor database backups and archives of backup files
• Conduct daily database server health checks for backups, jobs, mirroring, replication etc
• Monitor production database servers for load and performance tuning bottlenecks
• Analyze and approve database schema and procedure changes from dev to staging to production environments
• Coordinate with the Network Administer & Developers to ensure the data security & availability and meet the necessity of database refresh in development/staging environment.
• Act as the first technical contact for any query/database performance issues and assist developers and business power users in query requests and enhancements.
• Implements security according to defined standards.

Confidential

DBA/Reports developer

Responsibilities:

• Handle reports administration like subscriptions, caching, execution, history, security, parameters, distribution, setting up caching etc
• Configure reporting manager for different development and test server
• Update test reporting manager with production report server database
• Check OS Event Logs and Sql Server logs for unusual events
• Verify that backup jobs have been run and can be restored successfully
• Monitor disk space, locking /blocking issues, monitor the performance of server
• Create alerts for critical errors, restore the production backup file in test and development server, monitor temp dB, transaction log files, handle logins, user accounts, appropriate permissions, handle password policy, enable/ disable services in different environment as per the need, create linked servers, maintain jobs, setup database for auto create statistics, auto update statistics, auto shrink, auto growth etc