Data Analyst /bi Developer Resume
Southboro, MA
SUMMARY:
- Experience in web, client /server programming, object oriented programming and database developing
- Well - organized, self-motivated, reliable, proven ability to handle variety of projects
TECHNICAL SKILLS:
Software: Visual Basic 4.0/5.0/6.0, .net, C#, Visual Studio, Visual InterDev, COM/DCOM, MTS, IIS, VB script, Java Script, Java, JSP, Visual FoxPro 5.0, PowerBuilder 5.0, ASP, HTML, XML/XSL, Perl, Crystal Reports 6-11, Cognos 8, PL/SQL, RDBMS products (Oracle, Sybase, ASE 11.5, MS SQL Server, Pervasive SQL 8.5/9.0, MS Access 2.0/7.0), Toad, Rapid SQL, ERwin, UML
PROFESSIONAL EXPERIENCE:
Confidential - Woburn, MA
Data Analyst /BI Developer
- Provide decision support thru reporting and data analysis of PDIP program. Server as liaison between data/information customers to provide requirement analysis and specification support for data need.
- Created reports in Crystal Reports studio 2008, Crystal Reports 11 (SAP) and Crystal Report XI including Business Objects for different groups and clients, using MS Server 2008
Confidential - Framingham, MA
Sr. BA/BI Reporting
- Design new and update existing reports for StarLIM and iLIMS including design ad hoc queries, temp tables, and views in Oracle databases. Execute test scripts for all reports.
- Reports created in Crystal Reports studio 2008 and Crystal Report XI including Business Objects for different groups and clients.
Confidential - Southboro, MA
BI Reporting
- Support technical operations of company's different departments solving problems with reports, database objects, connectivity, dashboard objects and others through SLM accruent site.
- Design and update new and existing reports for management and clients including Crystal Reports studio 2008, business objects, SQL Server 2005, .net environments.
Confidential - Marlboro, MA
BI Reporting
- Design new and update existing reports for clients and management of GS MRP- global shop for manufacturing resource planning including design ad hoc queries, temp tables, and views in SQL Server and Pervasive databases.
- Reports created in Crystal Reports studio 2008 including Business Objects for different departments such as Finance, Inventory, Purchase, Compliance, etc.
- Utilized Crystal Reports 2008, SQL Server 2008, Pervasive 10, Toad
Confidential - Boston, MA
Reporting Specialist/Developer
- Develop Crystal Reports, Business Objects, and Universes including stored procedures, temp tables, T-SQL scripts, and Data Warehouse and Web development environments in Clarity system for PPM (Partner Project Management).
- Utilized Crystal Reports 2008/11, SQL Server 2005/2008, Solomon db, Actuate reports
Confidential, Shrewsbury, MA
Developer Analyst /Reporting
- Participate in conversion CMS of Provider medical db to EAP Expert including validation data, running sql scripts, design and developing new and updating existing objects in SQL Server 2005 db.
- Create new and convert old reports and queries from old db to new CRM including Crystal Reports 11, Toad.
Confidential, Newton, MA
BI Developer/Reporting
Design, create, modify, update new and existing reports and queries through CRM Pivotal system and 2005 Utilized SQL Server database, Cognos 8 and Crystal Reports 10/11.
Confidential - Waltham, MA
BI Data Analyst/Reporting
- Design, develop, and deploy business intelligence solutions to facilitate business decision making including collaboration with end-users and managers.
- Provide data analysis and reporting services through ad hoc SQL based queries and reports using Crystal Reports, Hyperion, Cognos, Toad and developing db objects in INTAPPS, DataWarehouse, sales reps, finance and other databases including DB2, Oracle, SQL Server, Sybase.
- Utilized Crystal Reports 10, Cognos 8.4, Hyperion 8, DB2 8.5, Toad, IBM Control Center, SQL Express Studio.
Confidential, Cambridge, MA
Application Reporting Developer
- Provide developing and enhancement custom reports for clients and management team using Crystal Reports 10.0, SQL Server, and Siebel 8.0 database.
- Develop and build ad hoc reports including command objects and sub-reports and using T-sql to develop stored procedures, views, tables and other db objects in SQL Server and Siebel databases.
- Utilized Crystal Reports 10.0-11.0, SQL Server 2005, Siebel, and Visual Studio.
Confidential - Lexington, MA
Data Analyst/Reporting
- Provide scoping, creating, documenting and delivering custom reporting solutions to the clients and management of the through Soarian Clinical and Financial applications.
- Develop client requested ad hoc reports in Crystal 10 and 11 including design and develop stored procedures, tables, views, and SQL queries using T-SQL, SQL Server.
- Evaluate work effort involved in creating client reports and write technical specs for the reports including data warehouse modules (OLAP db model and fact cubes).
- Utilized Crystal Reports 10.0-11.0, SQL Server 2000/2005, Visual Studio, Access.
Confidential - Boston, MA
Application Developer
- Provide generation, preparation, and distribution of management and practice group level reports using a variety of software products including SQL Server 2000, Crystal Reports 9.0-11.0.
- Develop ad hoc system queries and reporting through stored procedures and parameters of SQL Server.
- Support budget process; monthly reporting and variance analysis.
- Utilized Crystal Reports 9.0 - 11.0, SQL Server 2000, Visual Studio, XML, and Access.
Confidential - Boston, MA
Software Developer
- Design and develop VB and large complex Crystal Reports applications to support product Confidential and feed data into financial reporting system.
- Analyze, design and develop database objects such as stored procedures, tables, scripts, etc. in SQL Server and Pervasive SQL 8.5 db including data analysis, mapping, business rules translation and export to various formats.
- Provide technical specifications for some db and reports projects having data from clients including import and reformat data from multiple sources into a 3rd party Financial Reporting system via Rapid SQL, .net, C#, VB.
- Utilized VB6.0, .net, C#, SQL Server 2000, Pervasive SQL 8.5, Crystal Reports 8.5 - 11.0, Active Reports.
Confidential - Marlboro, MA
VB/Crystal Reports Developer
- Develop UI in VB application and PW ( Confidential ) for wireless network of Pennsylvania Police Department as well as logic blocks in middle-tier components.
- Design Crystal Reports in real-time using SQL queries and stored procedures in SQL Server 2000 and Crystal Reports 11.0 including validation system requirements and VB components.
- Utilized VB6.0, SQL Server 2000, Crystal Reports 10.0/11.0, XML, XSL, ASP.
Confidential - Hopkinton, MA
Software Engineer
- Design, develop and support application supporting Confidential product configuration rules including adding, maintaining and extending the applications current functionality.
- Provide support for existing interfaces, reports and processes written in Oracle, SQL Server stored procedures and real-time Crystal Reports including developing test cases to validate system requirements and performance.
- Utilized VB6.0, SQL Server2000, Oracle9i, Crystal Reports9.5, TOAD, ASP, Visual Studio, .net, Active Reports.
Confidential - Cambridge, MA
Developer
- Develop user Confidential for company products across all platforms.
- Provide enhancements for common Confidential to connect with business systems including writing applets and servlets through Oracle components.
- Utilized ASP, COM (VB), XML, HTML/DHTML, Jscript, SQL Server, JSP, Java, J2EE, Oracle 8.0.
Confidential - Boston, MA
Software Developer
- Involve in development of various applications Confidential extensive multi-national global knowledge management ( Confidential ) system supporting all versions from Confidential 1.5 to Confidential 2.1.
- Develop, test and enhancements CV/Address Book application increasing number of clients from 3,000 to 10,000 and number of countries from 4 to 12.
- Utilized VB6.0, ASP3.1, VBS, JS, HTML/DHTML, COM/DCOM, Visual Studio, Oracle7/8, SQL Server, UML
Confidential - Salem, NH
Programmer/Analyst
- Provide Object-Oriented programming and implementation of financial/database applications.
- Design and develop new and innovative 3 Tier client/server applications for DCS-Defined Contribution Services, work with COM/DCOM, Active X components to provide business objects, develop and maintain database applications including design and implementation of custom screens and reports.
- Utilized VB 5.0/6.0, COM, Sybase 10, ASE 11.5, Visual FoxPro 5.0, Active X, Crystal Reports 6.0/7.0, UML
