TECHNICAL SKILLS:

Project Development Skills: Gathering Business Requirements/ Rules/Key Metrics; Analyzing Data Rules, and Data Structures; Analyzing and Creating Data Base Structures; Visio Workflows; Creating Use Cases; Creating QA and UAT Test Scripts; Working with Custom Software; Documentation of Business, Functional and non - functional Requirements; Creating Power Point Presentations; Use SharePoint, Axure RP Pro 7.0, Agile/ Scrum/Waterfall software development, Full SDLC

Data Analysis: Data Profiling, Data Mining, Analyzing and Creating Database Tables, Creating complex SQL queries. ETL of Data, working with various data sources Excel and flat files, XML files, legacy systems.

Business Intelligence: Data Warehousing, Data Mapping Source to Target, Reporting Functionality Mapping, Reports Creation, Modification and Migration, Data Integration, COGNOS Impromptu- 7, BIDS 2008, BI Query, Crystal Reports XI.

Database Platforms: MS SQL Server 2000/2005/2008 R2/2012, MS Access, Sybase 10-12 .5, Oracle 11g Development Tools PowerBuilder 4.0- 12.5, PFC, MS Visual Studio 20008/2010, TFS, DTS/SSIS, ETL, VSS, DB Artisan, DB Visualizer, TOAD, SOAP UI

Programming: SQL, T-SQL, PowerScript, PFC, stored procedures/queries/triggers, VBA for Excel

Software: SQL Server Management Studio, HP PPM, HP ALM, Advanced MS Excel, Visio, CITRIX, Remedy, EDI, Subversion, ODBC, MS Visual Studio/BIDS/TFS, MS PowerPoint, Quickbooks, HTML/XML protocol, Sharepoint, Axure RP Pro 7.0, Balsamiq Mockups 3

Soft skills: Provide excellent customer service to internal and external customers, effective collaboration and communication skills.

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Business Systems Analyst/ Contractor

• Examining and clarifying business requirements with Business resources
• Responsible for solution design by working interactively with Architect, Development and QA resources via group work sessions in on-shore/off-shore environment. SOA/MOM
• Support the QA, UAT and Release phases of the project via defect analysis, change maintenance, documentation, etc.
• Working with multiple disciplines and on varied deliverables leveraging effective communication, multitasking and organizational skills
• Agile/Waterfall software development
• Full SDLC
• Maintain project related documents and artifacts using MS SharePoint

Sr. Database Analyst/Engineer

• Analyzing, designing, and developing cross platform database solutions based on business requirements, working in distributed environments with numerous servers and databases. SQL Server 2008 R2 and 2012 platforms, Visual Studio, TFS, Legacy systems (Access, VB).
• Performing daily project management functions, focusing on meeting business objectives on time within a rapidly changing work environment.
• Analyzing, monitoring issues and performing issue resolution to ensure Service Level Agreement commitments are met for application and data delivery.
• Developing and analyzing views, triggers, stored procedures, and functions using SQL.
• Performing data analysis for design requirements of data loads.
• Analyzing various proprietary tools/ utilities for requirements and design of data integration solutions.
• Use HP PPM for workflow management.
• Comfortable working with employees at all levels onsite and remote in gathering requirements.
• Use MS SharePoint to maintain documantation

Sr. IT Business Analyst Consultant/Contractor

• Extensively worked with business users to gather requirements, conveying business and functional needs and rules in documentation and verbal communications to the development team.
• Worked with project leads to develop requirements work plans, identify task dependencies, develop estimates and determine resource skill requirements.
• Created Data Dictionary for the Rate System owned by CT DSS/DDS
• Created systems specifications and user manuals for various enterprise systems.
• Analyzed, created ad hoc reports and data extracts using MS SQL Server Management Studio, writing T-SQL scripts and stored procedures against detailed requirements.
• Performed data mapping, data analysis and report reconciliation.
• Created wireframes/diagrams, business requirements documentation for capture of business requirements.
• Managed daily transfer of files to DSS using MS SSIS packages and other tools.
• Administered setting up new users and modifying existing users’ permissions to access various screens/ features in Rate System.
• Developed enhancements to the Rate System using PowerBuilder 12.5 and MS SQL Server 2008.
• Worked with remote IT team on issues analysis and resolution.
• Provided production support to on-site and off-site business users.
• Modify Excel spreadsheets using Excel VBA/Macros.
• Agile/Waterfall Software development, Full SDLC

Reporting Business Analyst (Contractor)

• Gathered business requirements, analyzed source systems, defined underlying data sources and transformation requirements in designing data models for the client data warehouse.
• Prepared functional and technical specifications for various external client reports and processes.
• Performed systems/data analysis for a Data reporting team in a global telecommunications company.
• Prepared “as-is” and “to-be” system process diagrams, data mapping documents, business rules documents.
• Designed, wrote stored procedures for ETL process
• Created complex queries and reports using MS SQL Server 2008 R2 and Excel 2010 and custom .NET applications.
• Performed trouble shooting and resolution of Remedy/Salesforce support tickets in a timely manner.

Sr. Developer/Business Analyst

• Analyzed, designed and coded, and debugged, and unit tested systems using PowerBuilder 11.5 and SQL Server 2008 R2.
• Assisted in defect analysis and resolution.
• Developed and optimized complex multi-level MS SQL stored procedures and triggers.
• Designed, coded and optimize SSIS packages using MS BIDS.
• Coded and utilized complex SQL queries for data validation and modification.
• Created tables, indexes and views in MS SQL Server 2008, enhancing current data warehouse structures.

Owner/Manager

• Managed all accounting, payroll, invoicing, marketing and IT operations for licensed home health care agency using Quick Books, MS Excel, and MS SQL Server 2008.
• Recruited, trained and supervised staff of 6 to 10 health care aides.
• Marketed in home health care services to up to 12 families.
• Created operation procedures for compliance of all state and federal regulations and statures.

Sr. Developer/ Business Analyst

• Analyzed, designed and developed systems for the marketing and commercial operations department.
• Enhanced and developed new modules for marketing and finance applications using PowerBuilder 11 front-end with a back-end Sybase/MS SQL Server 2005 data warehouse.
• Performed analysis, design, and coding, debugging, testing and production deployment.
• Simultaneously supported multiple initiatives.
• Participated in database migration from Sybase 12.5 to MS SQL Server 2005
• Agile/Waterfall software development, full SDLC

Sr. Developer/Business Analyst

• Performed business analysis, developed programs, for publishing and direct marketing systems.
• Extensively worked with business users to gather requirements, conveying business and functional requirements in documentation and verbal communications to the development team.
• Ensured the requirements are unambiguous and understandable by both business users and solution delivery teams.
• Worked with stakeholders to prioritize requirements effectively based on business value, risks and constraints.
• Collaborated with project leads to determine how requirements will be approached and managed for a particular project.
• Developed marketing analysis and financial applications using PowerBuilder 10.5 and Excel/VBA for client facing front end, with development of Sybase 12.5 and DB 2 database objects for back-end storage, utilizing PFC libraries.
• Created systems specifications and user manuals for various enterprise systems
• Created formal SDLC documents, obtaining appropriate signoffs from business users and stakeholders of applications.
• Ensured compliance with SOX mandates through implementation of monitoring processes.

Programmer/ Business Analyst

Responsibilities:

• Performed PowerBuilder/Sybase programming and analysis for direct marketing company.
• Participated in all phases of conceptual and physical design and development of marketing and purchasing applications.
• Elicited, analyzed, specified and communicated business, system and implementation requirements.
• Coded, designing, testing and debugging of user interface screens.
• Created and optimize complex queries, stored procedures and triggers.
• Created nested and composite reports.
• Worked closely with end users in providing user support and training.