Tanya Betancourt
*** ********** ***** ****: 860-***-****
South Windsor, CT 06074 ac8jie@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, JIRA, Rational Tools
Healthcare Knowledge: Claims Life Cycle, Accumulators, Healthcare Payer, Provider and Member data
Soft skills: Provide excellent customer service to internal and external customers, effective collaboration and communication skills.
Experience
Infosys Ltd Hartford, CT 7/17- 11/18
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
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.