SUMMARY

• Systems Analyst with seasoned experience in business analytics, design and development of data models and databases, and effective acquisition, integration, management and communication of data.
• Data analyst with experience in machine learning, exploratory data analysis, developing data models, and statistical inference.
• Proficient in leading the technical design of projects and managing project resources
• Proficient in understanding and diagnosing business problems, understanding integrated systems and applications as well as data architectures to create valuable business intelligence
• Demonstrates expert understanding of data management, analytics, data integration, and/or database design, data modeling, defining data elements, acquiring, integrating, and mining data to support business analysis and decision support.
• Works independently and provides guidance within technical area, applying in - depth knowledge of multiple technologies, as appropriate.
• Understands architectural issues, and factors them into decisions and recommendations.
• Provides leadership in their area of technical specialization.

TECHNICAL SKILLS

• Microsoft SQL Server 2012, 2010, 2005, 2000, 7.0, 6.5
• Oracle 11g
• IBM DB2 v7.1, 8.1
• Microsoft Visual Studio 2010, 2005, 2008
• Eclipse for JAVA
• Microsoft SSRS 2012
• Tableau 6.0
• MicroStrategy 10
• R Programming
• Transact-SQL
• PL/SQL
• C#
• VB.NET
• PHP
• JAVA
• HTML
• COBOL
• NetSuite
• Salesforce.com
• SAP ERP (Enterprise Resource Planning)
• Embarcadero Technologies
• Rational ClearCase and ClearQuest
• Quest Central and Spotlight
• ERWin
• IDERA SQL Diagnostic Manager
• Red Gate SQL Compare
• EMC Replication Manager
• Perforce
• R Programming

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Manager

Responsibilities:

• Key owner and champion of NetSuite and Salesforce within the organization.
• Lead effort with business teams to understand business processes, requirements and key performance indicators and translate this information into NetSuite and Salesforce functional specifications.
• Drive detailed requirements gathering, workflow capture and process analysis. Data gathering to include brainstorming, document analysis, interviews, observation, prototyping and workshops.
• Develop business cases and project priorities.
• Provides ongoing recommendations, documentation, training and updates to end user on NetSuite and Salesforce best practices
• Develop and execute project plans for process changes, software updates and other related efforts.
• Manage configuration changes to fields, workflows, roles permissions, page layouts, custom object, customer record types, reports and dashboards.
• Fully document existing and new customization and workflows
• Develop, launch and manage in-depth KPI’s, dashboards and reports for all team functions at both management and individual level.
• Maintain proper system access for all users and roles.
• Communicate effectively with stakeholders regarding project status and delivery time frames

Confidential

Data Engineering Manager

Responsibilities:

• Transforms business requirements into logical data models and preliminary physical data models.
• Applies data analysis, data modeling, and quality assurance techniques to establish, modify, and maintain data structures and associated components.
• Mines data to derive insights for the business and support critical business decision making.
• Contributes to the identification of data design options to meet business requirements for large and complex initiatives spanning multiple applications.
• Maintains a consistent view of enterprise data definitions and vocabularies to ensure consistency in process and quality.
• Interprets object and data models to create appropriate data design and design constraints.
• Develops and maintains conceptual, logical, and physical data models to meet business requirements.
• Publishes data models and supporting documentation to make data models available to project teams and I.S. groups.
• Leads development of ETL and/or SOA data integration, data management (MDM), and business intelligence/analytics solutions.
• Promotes the reuse of existing data objects and entities across the enterprise to reduce cost and meet business requirements.
• Participates in the feasibility analysis for new systems/applications.
• Monitors and manages application, and database performance, troubleshooting and application, errors, indexing, or other problems.
• Implements change management/change control processes.

Confidential

Senior Systems Analyst - Business Intelligence

Responsibilities:

• Develop deep functional knowledge and experience in multiple business domains supporting Business Intelligence and Data Analytics
• Work with functional business units to understand their business processes, KPs, and organizational structure
• Determine operational objectives by studying business functions; gathering information; evaluating output requirements and formats
• Identify and formulate business solutions and then document them as business requirements in an enterprise requirements document
• Engineer and build prototypes, data models, and proof-of-concept models
• Architecture & Design: Interview and gather client requirements to translate into detailed project plans that meet budgets and deadlines
• Programming/development: Assist the programmers and developers through designing, coding, testing, deploying, maintaining, and supporting client initiatives
• Administration: Manage infrastructure development that will enhance the scalability of the organization, allowing the proper systems and processes to be integrated with the business’ best practices ensuring consistency and stability
• Code Library: Manage and grow code library and development framework for agile application design and development
• Collaborate with the QA teams and business partners to create and execute system test plans and user acceptance testing
• Help administrators, department managers, super-users and end-users to effectively and efficiently utilize Data Warehouse, Enterprise Reports and dashboards
• Assist with functional migration to the Data Warehouse such as data conversion, data cleansing, de-duplication, and data maintenance efforts

Senior Business Intelligence Engineer

Responsibilities:

• Contribute substantially in the Data Warehouse development lifecycle from business requirements to development of logical design, translation to physical design, ETL code development and testing using SQL Server 2005 Business Intelligence Development tools - Integration Services, Analysis Services & Reporting Services
• Contribute substantially in the business analysis for Reporting requirements and the definition of the report functional specifications based on business needs
• Hands on involvement in the report development effort based on functional specifications and deliver high quality reports, dashboards and analytics to meet the needs of various business units such as Operations, Sales, Customer Service, Finance, and Executives
• Participate in the maintenance and monitoring of the Enterprise Data Warehouse System on production and development servers
• Hands-on involvement in report query optimization such as Index design, planning, analysis, and tuning
• Collaborate with the QA team to create and execute system test plans and user-acceptance testing
• Undertake the technical review of SQL code with peers and design review with end-user audience
• Participate in the evaluation and selection of development tools, infrastructure software and hardware to meet Data Warehouse needs
• Participate in data modeling, design & implementation and all activities related to data cleansing, data quality and data consolidation
• Cross train and mentor junior Data Modelers & other report developers in efficient DW design & report development techniques

Database Engineer

Responsibilities:

• Participate in the development of database-related software development, system architecture, design, and development of database schemas
• Contribute substantially in design & development of schema objects, technical review of SQL code with peers as well as design review with end-user audience
• Manage database system and SQL profiling activities based on poorly performing use cases. Re-factor poorly performing SQL when necessary
• Manage the deployment of database code to QA & Production, managing database source code & scripts and updating & maintaining data models
• Collaborate with the QA team to create and execute system test plans and user-acceptance testing
• Undertake installation, maintenance, upgrade, tuning, design, and troubleshooting of OLTP and OLAP applications
• Manage key database Operational activities such as maintenance of databases including database object & index management, security, backup & recovery, database upgrades, automated monitoring of systems and performance tuning
• Manage system and application tuning activities including tuning SQL queries and database/system performance for OLTP and DSS applications
• Evaluate and select development tools, infrastructure software and hardware to meet OLTP application & database needs
• Documented key operational activities, IT infrastructure topology, and Production database environment
• Provide 24x7 on-call support

Confidential

Senior Systems Analyst, Database Administration and Development

Responsibilities:

• Administered database performance tuning and optimization
• Managed database security
• Managed database backup and restore processes for disaster recovery
• Managed and performed database change requests and upgrades
• Programmed and tested shell scripts for process automation
• Served as liaison between developers and database support group
• Analyzed and performed logical and physical database design
• Documented database procedures and processes

Confidential

Database Administrator

Responsibilities:

• Administered database performance tuning and optimization
• Created and managed database automated jobs
• Installed, administered, and managed database clustering and replication
• Managed data migration activities
• Managed database security
• Managed database backup and restore processes for disaster recovery
• Performed troubleshooting and implemented database patches and fixes
• Programmed stored procedures and ad hoc queries using SQL

Confidential

Database Administrator and Architect

Responsibilities:

• Administered database performance tuning and optimization
• Managed database security and disaster recovery processes
• Managed and performed database change requests and upgrades
• Analyzed and performed logical and physical database design