Resume

Sign in

Business Systems Analyst with SDLC, SQL

Location:
South Windsor, Connecticut, United States
Posted:
April 21, 2018

Contact this candidate

Resume:

Tanya Betancourt

*** **** ****** ***** ****: 860-***-****

South Windsor, CT 06074 ac47ki@r.postjobfree.com Cell: 203-***-****

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, Agile/ Scrum/Waterfall software development, Full SDLC, participate in JAD sessions, create UML artifacts

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/2008R2/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.

Experience

Infosys Ltd Hartford, CT 7/17- present

Business Analyst: HealthCare, Datawarehousing

Gathering, analyzing and documenting business requirements for data integration and operational enrichment

Create functional and technical specifications, create process flow, data flow diagrams

Creating data mapping documents and validating business rules with the business stakeholders( Claims and Member/Product teams)

Environment: DB2, Hadoop Data Lake, IBM Rational Tools, MS SQL Server 2016, SSIS, ETL,EDI

Analyze SQL, T- SQL Scripts, and stored procedures, create SQL queries using multiple tables, joins, user functions, variables, etc.

United Health Group, Hartford, CT 2/16- 11/2016

Business Systems Analyst/ Contractor, Clinical Systems Delivery, Optum Technology

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

Insurity, P&C Insurance Software & Data Services, Hartford, CT 2/15- 2/16

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.

Myers &Stauffer, LC, CT State DSS/DDS Rate System Software, Windsor, CT 6/14-1/15

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

Quickcomm Inc, Telecommunications Management, Newtown, CT 01/13-04/13

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 support tickets in a timely manner.

Housing Authority Insurance Group, Insurance, Cheshire, CT 08/11-07/12

Sr. Developer/Business Analyst

Analyzed, designed and coded, debugged, and unit tested Commercial P&C systems using PowerBuilder 11.5 and SQL Server 2008 R2.

Assisted in defect analysis 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.

Fairfield County Home Care LLC, Health Care Services, New Milford, CT 01/10-06/14

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.

Maintained GL and WC insurance for the business

Iroquois Pipeline Operating Company, Shelton, CT 10/08-12/09

Sr. Developer/ Business Analyst (Contract)

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

Scholastic Inc., Publishing, Danbury, CT 10/00- 10/08

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.

International Masters Publishers, Inc., Publishing, Stamford, CT 08/98 – 9/00

Programmer/ Business Analyst

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.

Education

State University, St. Petersburg, Russia

Economics

Sybase Learning Center, New York, NY

Training in PFC, Developing Object Oriented applications, Advanced Transact-SQL techniques.

ONLC Training Center, Danbury, CT Training in Implementing MS SQL Server 2008 and Business Intelligence Development and Maintenance.



Contact this candidate