Summary

Motivated and creative business process improvement specialist and Agile Project Manager with a strong background implementing and maintaining SQL Server databases using T-SQL, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server native tools, SSIS, SSAS, SSRS in multiple server environments.

Technologies
Systems:ASP.NET,Windows Server 2003/2008, XP/Vista/7, Linux, MS Project, MS Visio, MS Virtual PC, MS Virtual Server, Visual Studio 2005/2008, MS Office Suite, ERP, CRM
Databases:Access, Denali, MDX, OLAP, OLTP, SQL Server 2005/2008R2, SSIS, SSRS, SSAS
Languages:C#, JavaScript, HTML, SQL, T-SQL, XML

Skills: Active Directory, Administrative Tasks Automation, Agile, Backup/Restore, Consulting,Data Analysis, Data Cleansing, Data Warehousing, Database Management, Disaster Recovery, Disk management, Electronics, Encryption, ERP/CRM, ETL, Failover, IIS,MS Dynamics Great Plains, MS Project, Multidimensional SQL Server Analysis Services Solutions, Network Connectivity, Network Infrastructure, Office Suite, Performance Tuning, Performance Tuning, PMI PMBOK, PowerPivot,Product Lifecycles, Project Management Query Optimization, Replication, Report Generation, Scrum Trained, Security (TDE), SharePoint, Software Development Life Cycle (SDLC), Solution testing, Stored Procedures, TCP/IP, Telecom experience, T-SQL, Waterfall

Experience

Confidential,05/2012 – Present
Dallas, TX
BI Developer - SSRS Specialist

• Configured MS SQL Server 2008 R2 Reporting Services including: Report Server, Report Manager and integrated with SharePoint.
• Migrated reports from COGNOS to SSRS.
• Applied Agile Methodology for Rapid Software Development in all BI Reporting and Security project.
• Analyzed and wrote new T-SQL queries to improve performance and designed complex drill down matrix and tabular reports.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Contributed vital technical business ideas during Scrum meetings and performed other duties as assigned by the CIO.

Confidential,12/2011 – 03/2012
Dallas, TX
SQL Report Writer / SQL Server Business Intelligence Developer

• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user training and training materials; provide technical support as necessary.
• Led the integration efforts for merging BI platforms with enterprise systems and applications.
• Designed, code, test, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.

Confidential,2/2011 – 11/2011
Jacksonville, FL
SQL Server 2008 R2 Business Intelligence Developer

• Contributed to team effort of designing numerous simple to complex T-SQL statements, stored procedures with parameters to query Sales Force database according to business requirements.
• Evaluated table relationships to determine the most efficient query designs to return requested results.
• Designed impressive SSRS reporting solutions according to user specifications to bring meaning to the data and solve complex business requirements using maps, spark lines, data bars, drill downs, sub reports, indicators, and gauges.
• Leveraged SSIS Extraction, Transformation and Loading tools with Flat Files, XML, Excel, ODBC, DB2, SQL, Oracle sources and Databases
• Created SSAS Cubes from Data Warehouse sources; utilized statistical analysis methods and MDX calculations to generate data needed for End-users and for use in Reporting Services.
• Configured Reporting Services Configuration Manager and Report Manager and deployed reports for End-User access
• Created new databases, database backups/restores, and migrated existing tables into the newly created databases using Restore Database T-SQL syntax.

Confidential,12/2010 – 5/2011 Milwaukee, WI
Technical Project Consultant

• Provided system analysis and implemented innovative business IT solutions; consulted in the e-business operations, supply-chain management and information technology services; performed research and data collection and conducted statistical analysis.

Confidential, 4/2010 - 12/2010
Milwaukee, WI
SQL Server 2008 BI Developer/ASP.NET

• Employed best practices in designing numerous simple to complex reports in SSRS involving data imported from relational, multidimensional and XML-based data sources using SSIS and analyzed in SSAS cubes per business requirements while ensuring optimal performance
• Implemented several new enhancements in SSRS such as drill downs, drill through, data bars, and maps
• Developed and maintained the applications by utilizing ASP.NET
• Developed Web site administration and user management system
• Responsible for the creation of the user defined applications, database classes, procedures and user controls
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS.

Confidential,9/2007 - 3/2010
Milwaukee, WI
Technical Specialist Lead (Level II)

• Created a SQL Server Database for tracking and managing of system errors before and during Application roll-outs, which led to increase in up time and productivity for the entire AT&T UVERSE division; Ran SSIS packages to generate strategic customer data
• Designed technical training materials for the IPTV technicians and customers to resolve connectivity problem on a first call basis
• Controlled the quality of service and amount of rework performed; managed agents to stay on tasks at hand
• Provided leadership to technical product support agents on how to meet and exceed client expectations
• Coordinated and lead all daily team meetings and brainstorming sessions; provided leadership in report creation
• Exceeded customer service expectations 20 months in a row; Finished 2008 with 112% of plan estimates, and sold 2600 AT&T services in the first 3 quarters of 2009 through direct sales and upgrades
• Increased AT&T’s growth by securing new partners, consulting engagements and by delivering new projects
• Added to AT&T's organizational process assets and increased revenue by 20% by developing ideas that led to integration with Apple's iPhone.

Confidential,12/2004 – 8/2008
Milwaukee, WI
Mortgage Orientation Analyst (Part Time)

• Made sales calls to current clients and potential first time home buyers.
• Prepared paper work for income and credit checks.
• Made appointments for title searches and final closings.
• Gave community discourses about importance of home ownership.

Confidential,12/2007 - 10/2008
Milwaukee, WI
Computer Trainer

• Coordinated and tutored Mathematics and technical writing to high school students.
• Provided computer training to students
• Was in charge of special needs class for students falling behind in Mathematics and Science; Led the research for better ways of improving test scores
• Collaborated with management and students daily to measure and improve test scores for the students; Performed analysis and recommended necessary system upgrade for the classrooms.

Confidential,3/2003 - 12/2007
Milwaukee, WI
Project Manager

• Coordinated multiple related projects directed toward strategic business objectives.
• Wrote T-SQL queries and utilized best practices in designing complex reports in Crystal Reports and Microsoft Reporting Services.
• Provided Logistics, budgeting and developed the business case with emphasis on ROI
• Provided leadership and support for WBS creation.
• Provided management support to Project Managers.
• Helped at the Project Management Office and provided daily briefing at project team meetings about the progress and newly identified risks for the project; Saved 3 months ($20K) on an 18 month project for the installation of Microsoft Dynamics Great Plains Accounting System by researching alternate versions and vendors.
• Conducted exit interviews and archived lesson learned as company process assets.
• Developed and delivered training sessions for OSHA and HIPPA which helped reduce work place accidents by almost 100%.

Confidential,1/2000 - 3/2003
Springfield, MO
Account Manager

• Assumed responsibility by assisting customers with long distance and T1 fast internet accounts, reduced reworks, increased customer base, increased profit margins, and Led team meetings.
• Provided daily support to Canadian clients and Entered customer information into CRM software.
• Worked with business owners and executive-level decision makers using multi-contact selling approach.
• Added more than 300 clients to MCI’s client base by providing multinational support in English and French
• Generated 30% of business through client referrals compared to the company standard of 10%; Recognized leader in the office and frequently called upon to provide trainings on technical products.
  

Educations, Training & Certifications

Education:
Master of Science in Business Administration

• Emphasis in Global Business Policy and Strategy
  Master Certificate in Project Management
  Bachelor of Science in Business Administration
• Emphasis in Strategic Management of Information Technology
  IT Network Specialist-Associate in Applied Science
  Received Certification -AT&T: Internet Data Center Knowledge Test (IDCKT)

PROFESSIONAL AFFILIATIONS:

Project Management Institute (PMI) – Member
North Texas SQL Server User Group