Power Bi Sql Server
Resume:
TANYA D. PICKENS
**** *********** **., **********, ** 60564
********@*******.***
PROFESSIONAL SUMMARY
Experienced Software/Applications Developer. Accomplished, innovative IT professional with comprehensive multi-industry experience. Strong understanding of relational database concepts. Proven talent in Database Analysis, Database Development, Reporting, and common Administration tasks with Visual Studio, Reporting Services (SSRS), and Integration Services (SSIS). Skilled in Microsoft Azure Cloud data warehouse solutions, Data Lake, SQL Server Business Intelligence tools, Power BI, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), GIT, JIRA, Microsoft Visual SourceSafe (VSS), Data Warehousing and ETL processes. Accomplished Lotus Notes/Domino software/web development utilizing such skills as Lotus Notes @functions, LotusScript and Domino Administration. Adaptable and detail-oriented performer in difficult and high-pressure situations. Thrives in a diverse and global workplace. Consistently lauded for communication, technical writing and teamwork.
AREAS OF COMPETENCIES
Programming Languages/Software
T-SQL (queries, stored procedures, and triggers), Microsoft Azure Cloud, Databricks, Data Lake, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI, Power BI Paginated Reports, Excel Power View/Power Pivot Reporting, Hue, Toad, Online Analytical Processing (OLAP), Lotus Notes/Domino Application Development (Lotus Notes @functions & LotusScript), Lotus Notes/Domino Administration, VBA, QuickPlace, Sametime, SharePoint, Visual Basic, Javascript, .NET 2.0 & 3.5, C++, HTML, COBOL I & II, Micro Focus COBOL, JCL, CICS, Assembler, RPG, Oracle PL/SQL, Basic
Databases & Object Oriented Programming
SQL Server 2005/2008/2008R2/2012/2014/2016, T-SQL, OLAP, OLTP, Lotus Notes, MS Access, SharePoint, DB2, Oracle, RBASE, SPUFI, LotusScript, Javascript, .NET 2.0 & 3.5, Java
Operating Systems & WAN/LAN & Hardware
Domino, Windows, UNIX, AS400, CMS, DOS, PS/2, OS-MVS, TSO-ISPF, TCP/IP, Domino Server, Client Server, IBM3090, IBM9000, IBM PC's
Miscellaneous
Microsoft Teams, Business Intelligence Development Studio (BIDS), Visual Studio 2005, 2008, 2010, 2015, 2017, & 2019, GIT, JIRA, MS Word, MS Excel, QlikView, Tableau, Visual Studio .Net 2003, Windows Server 2003, MS Visual SourceSafe, Domino System Administration, Internet Information Services (IIS) 6.0, BEA Aqualogic web infrastructure, LEI, QuickPlace, TeamStudio, Sametime, Systems Development Life Cycle (CASE), Lotus Accelerated Value Method (AVM), VBA, MS Project, MS Powerpoint, Photoshop, Panvelet, File-aid, Abend-aid
PROFESSIONAL EXPERIENCE
Molina Healthcare – Oakbrook, IL August 2019 – Present
•Sr. Analyst, Healthcare Analytics
•Performs research and analysis of complex healthcare claims data, pharmacy data, and lab data regarding network utilization and cost containment information.
•Evaluates, writes, and presents healthcare utilization and cost containment reports and makes recommendations based on relevant findings.
•Develops ad-hoc reports using Microsoft Azure, Databricks, SQL programming, SQL Server Reporting Services (SSRS), Executive Dashboard, Hue, Toad, and other analytic / programming tools as needed.
•Generates and distributes standard reports on schedule using SQL, Excel, Power BI, Power BI Paginated Reports and other reporting software.
•Creates new databases and reporting tools for monitoring, tracking and trending based on project specifications.
•Collects and documents report / programming requirements from requestors to ensure appropriate creation of reports and analyses. Uses peer-to-peer review process and end-user consultation to reduce report writing errors and rework.
•Responsible for timely completion of projects, including timeline development and maintenance; coordinates activities and data collection with requesting internal departments or external requestors.
•Identifies and completes report enhancements/fixes; modify reports in response to approved change requests; retain old and new report design for audit trail purposes using GIT.
•Analyzes data sets and trends for anomalies, outliers, trend changes and opportunities, using statistical tools and techniques to determine significance and relevance.
•Creates comprehensive workflows for the production and distribution of assigned reports; document reporting processes and procedures.
•Assists with research, development and completion of special projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.
•Maintains SharePoint Sites as needed.
•SQL Server 2017 and Visual Studio 2017.
•Microsoft Azure and HUE
National General Insurance Company – Chicago, IL April 2019 – August 2019
•Sr. BI Developer
•Defined and managed the full development lifecycle.
•Designed and delivered reports using SQL Server Reporting Services (SSRS), MS Access, MS Excel, MS Power BI, and Qlikview.
•Designed and delivered enterprise data warehouse analytics using SQL Server Analysis Services (SSAS).
•Designed and delivered large-scale, high-performance data transformation and storage systems using SQL Server Integration Services (SSIS).
•SQL programming using T-SQL to create stored procedures and basic queries.
•Lead consultants in various project work streams.
•Acted as a project manager to keep projects moving towards completion.
•Translated business requirements into technical architectures.
•SQL Server 2019.
•Visual Studio 2019.
ADDISON GROUP – Schaumburg, IL September 2016 – March 2019
•SQL / BI Developer
Client: Komatsu America Corp. – Rolling Meadows, IL
•Developed BI and reporting solutions on the Microsoft SQL Server/BI reporting stack (SSIS, SSRS, and SSAS) and Power BI in the Microsoft Azure Cloud environment.
•Developed customized reports in SSRS and database programming in SQL Server with stored procedures and T-SQL in the Microsoft Azure Cloud environment.
•Created Power BI dashboards and reports using tabular datasets.
•Production support and project development work.
•Helped develop strategic technical direction within the business intelligence function.
•Performed other duties related to projects such as creating analysis documentation, gathering requirements, creating requirements and design documentation.
•Provided support to a core business intelligence and reporting technical team for ETL, BI and database solutions.
•Worked with users on gathering business requirements, designing enterprise solutions and implementing solutions for end-to-end development.
•Recommended, developed, and enforced IT and database standards, guidelines, and procedures in order to facilitate quality assurance and document data requirements for database design.
•Created detailed technical specifications and ETL documentation, comply to internal standards and guidelines, provide post-implementation production support by performing problem analysis and resolution as needed.
•SQL / SSRS Developer
Client: Platinum Home Mortgage – Rolling Meadows, IL
•Participated in the report and dashboard development of complex data initiatives, including gathering of business requirements, technical specifications, prototyping, and implementation.
•Developed reporting code and reports to support company reporting, operation, and analytic needs.
•Collaborated with other business entities for new reporting requests.
•Built effective working relationships with all functional areas.
•Contributed to the design and implementation of new applications as well as enhancements within company website and existing custom applications.
•Participated and processed direct mail extracts in accordance to the business needs.
•Helped engineer new ways to simplify and improve processes.
•SQL Server 2016.
•Visual Studio 2017.
•SQL Developer
Client: Epsilon – West Chicago, IL
•Developed scalable and reliable data warehousing solutions using Microsoft T-SQL and SSIS.
•Built and maintained platforms that provided traditional data warehousing, BI, datamarts, and email marketing solutions.
•Created online analytical processing (OLAP) cubes using SQL Services Analysis Services (SSAS) to manipulate and analyze data from SQL and Oracle databases.
•Began development on a database used for driving marketing campaigns.
•Developed unit testing and performed developer testing of code changes.
•Performed peer reviews and code walk through.
•Documented new development.
•SQL Server version 2016
•Visual Studio version 2015.
•SQL / BI Developer
Client: Komatsu America Corp. – Rolling Meadows, IL
•Developed BI and reporting solutions on the Microsoft SQL Server/BI reporting stack (SSIS, SSRS, and SSAS).
•Developed customized reports in SSRS.
•Analyzed and gathered data to be used in Tableau.
•Developed database programming in SQL Server with stored procedures and T-SQL.
•Delivered and maintained comprehensive SSRS reporting and user access through SharePoint.
•Developed and supported reporting in Crystal, MS Excel, MS Word, and PDF formats.
•Performed production support and project development work.
•Helped develop strategic technical direction within the business intelligence function.
•Performed other duties related to projects such as creating analysis documentation, gathering requirements, creating requirements and design documentation.
•Provided support to a core business intelligence and reporting technical team for ETL, BI and database solutions
•Worked with users on gathering business requirements, designing enterprise solutions and implementing solutions for end-to-end development.
•Recommended, developed, and enforced IT and database standards, guidelines, and procedures in order to facilitate quality assurance and document data requirements for database design.
•Developed detailed technical specifications and ETL documentation, comply to internal standards and guidelines.
•Provided post-implementation production support by performing problem analysis and resolution as needed.
•SQL Server version 2014 & 2016
•Visual Studio version 2015.
APEX SYSTEMS – Chicago, IL December 2015 – September 2016
•SQL Developer
Client: Athletico – Oak Brook, IL
•Was responsible for the management and support of custom developed reporting systems.
•Supported the integration of management reporting systems, SSRS and QlikView.
•Supported and managed back-end data infrastructure such as data warehouse and report server databases.
•Provided SQL Server database design, development and administration (SSRS, SSIS, SSAS) duties.
•Provided SQL programming using T-SQL to create stored procedures and basic queries.
•SQL Server version 2014.
•Visual Studio version 2015.
ADDISON GROUP – Schaumburg, IL December 2014 – December 2015
•BI Developer
Client: MB Financial – Chicago, IL
•Contributed to the design and implementation of Business Intelligence vision including data governance, data usage, and control processes.
•Assisted in governing and managing BI hierarchies, change control, issue tracking, prioritization of work to be interfaced to EDW, lead EDW UAT testing, etc.
•Had direct responsibility for managing governance and control processes.
•Developed and maintained reports, models or databases to support individual and the enterprise’s routine and ad hoc data and analytical needs.
•Provided guidance and training on use of tools, modeling, reporting and key data components in core, related databases, and the enterprise data warehouse.
•Had responsibility for leading training and communication programs.
•Served as primary analyst on Loan reporting, examples include OCC data analytics, concentration reporting, and Large Borrower reporting
•Supported regular and ad hoc requests from business and support areas using SSRS.
•Managed tracking and resolution of data quality, technical and other issues.
•Complied with all Bank policies/procedures and all applicable federal and state laws and regulations.
•“LIVED” the Bank’s Mission Statement and “PRACTICED” the Bank’s Corporate Strategy.
•SQL Server version 2014.
•SQL / BI Developer
Client: ArjoHuntleigh – Addison, IL
•Supported BI Manager with reporting process using MS Access and SQL Server.
•Led SQL Server Report (SSRS) writing to ensure the timely delivery of data to the business stakeholders.
•Analyzed and gathered data to be used in Tableau.
•Continuously improved the MS SQL Server Data Warehouse solutions.
•Created and maintained SQL Server reports as well as complex queries necessary to complete monthly financial reporting.
•Analyzed, designed, developed, implemented and maintained technical solutions through the use of SSIS and T-SQL.
•Provided ETL development using SQL Server Integration Services (SSIS).
•Used SQL Services Analysis Services (SSAS) to create online analytical processing (OLAP) cubes to structure data from multiple data sources for manipulating and analyzing.
•Supported, maintained and debugged the technical aspects of the MS Access, MS Excel and Visual Basic consolidation processes.
•Served as a subject matter expert on system data structures and the queries required to access information for effective reporting.
•Assisted the Manager of Business Intelligence with implementation of the core financial Data Warehouses.
•Supported the migration of legacy Microsoft Office toolsets to new Microsoft SQL Server.
•Worked with users to gather accurate source data queries for integration to the data warehouse and define effective web based SQL Server Reports and Analytical Cubes.
•Assisted with end-user acceptance testing of the new toolsets.
•Provided training and on-going support to the Business Units in regards to writing reports and accessing data.
•SQL Server version 2014 and Visual Studio version 2010.
TRUE GROUP – Oakbrook, IL January 2013 – December 2014
•SQL Programmer Analyst
Client: Abercrombie & Kent – Downers Grove, IL
•Was responsible for supporting users' application, database and reporting needs while ensuring timely and accurate delivery.
•Wrote and optimized T-SQL, stored procedures, functions and views.
•Analyzed, designed, developed, implemented and maintained technical solutions through the use of SSIS/DTS Packages and T-SQL.
•Provided ETL development using 2008 R2 SQL Server Integration Services (SSIS).
•Delivered reporting solutions using MS Excel and SQL Reporting Services (SSRS).
•Used MS Import and Export Wizard.
•Assisted in creating technical solutions to satisfy business requirements through database and application design and development.
•Created and maintained technical documentation to support new and existing systems.
•Assisted Database Administrators in the preparation, set-up, and maintenance of hardware/software systems.
•Worked with third-party hardware and software vendors.
•Participated in application design discussions and the change management process.
•Applied a high standard of customer service when interacting with all levels of staff.
•Assisted with other special projects or related duties as assigned.
•Demonstrated organizational skills.
•Demonstrate excellent oral and written communication skills.
MMD SERVICES – Chicago, IL February 2012 – December 2012
•SSRS / SQL Developer
Client: Sanford – Oakbrook, IL
•Used SQL Server 2005 technology.
•Developed and delivered dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS) in Visual Studio 2005.
•Designed, implemented, verified, debugged, optimized and maintained SQL Server database objects (database design, table design, stored procedures, views, functions, scripts, etc.) and processes for application, reporting and interface modules.
•ETL development using 2005 SQL Server Integration Services (SSIS) Import and Export Wizard.
•Used Microsoft Visual SourceSafe (VSS) as source control software.
•Performed analysis and unit testing of Antivia XWIS with Xcelsius dashboards.
•Wrote technical design documents related to schema and stored procedures.
•Performed business analyst duties to gather report requirements.
SMARTSOURCE – St. Charles, IL July 2010 – February 2012
•Business Analyst / SSRS & SQL Developer
Client: Insight – Bloomingdale, IL
•Used SQL Server 2008 technology.
•Delivered comprehensive BI through MS solutions including VBA, MS Excel, MS Access, and Microsoft Office SharePoint Server (MOSS).
•Developed and delivered dynamic reporting solutions using SQL Server 2008 & 2008 R2 Reporting Services (SSRS).
•Developed reports using SSRS in SQL Server Management Studio (BIDS).
•Wrote SQL stored procedures, queries and analysis.
•Developed and modified production software using C# and VB.NET (.Net 3.5 Framework) technologies.
•Created and enhanced CMS system using a VB.Net front end with SQL Server backend.
•Wrote technical design documents related to schema and stored procedures
•Designed, implemented, verified, debugged, optimized and maintained SQL Server database objects (database design, table design, stored procedures, views, functions, scripts, etc.) and processes for application, reporting and interface modules.
•Designed, coded, and tested SSRS components including user interface, stored procedures, queries and tables.
•Created ad-hoc queries from SQL Server databases for custom reporting needs.
•Performed business analyst duties to gather report requirements.
AJILON CONSULTING – Rosemont, IL April 2008 – November 2008
•Application Migration Developer
Client: Bank of America – Chicago, IL
Lotus Notes Experience
•Used Lotus Notes/Domino version 6.
•Developed and enhanced Lotus Notes/Domino client applications using LotusScript.
•Used Sametime and TeamStudio.
•Provided knowledge for existing Lotus Notes power user base.
•Dealt with the current LaSalle Lotus Notes population to maintain applications until they were ported to SharePoint.
•Participated in analyzing and designing the Image-Enabled Notes add-in for Lotus Notes.
.NET Experience
•Converted Lotus Notes applications into intranet ASP.NET 3.5 Web applications written in C# and VB.NET with SQL Server 2000 on the backend.
•Performed business and system analysis, designed applications and database structure, and converted existing data into SQL Server.
•Created Web Forms using ASP.NET, C#, VB.NET, XML, HTML, CSS, JavaScript.
•Used Crystal Reports to create reports based on SQL Server database.
SharePoint and other skills
•Provided advice on Windows SharePoint Services to a team building and maintaining one of the company’s culture sites on Windows SharePoint Services.
•Dealt with the current LaSalle Lotus Notes population to maintain applications until they were ported to SharePoint.
•Used solid oral and written communication skills.
CIBER – Oakbrook Terrace, IL June 2007 - April 2008
•Web Portal Developer
Client: Cook County / Bureau of Technology
•Participated in the design of the technical architecture of Web Portal Application Project.
•Used SQL Server 2005 technology.
•Used Aqualogic web infrastructure suite of tools.
•Worked with the team and customers to drive features and specifications, architecture design, implementation, and other software development responsibilities.
TEKSYSTEMS – Downers Grove, IL March 2007 - May 2007
•Lotus Notes Developer
Client: Ineos Silicas
•Used Lotus Notes/Domino version 6.
•Developed and enhanced Lotus Notes/Domino client application using @functions and LotusScript.
•Performed business analyst duties to gather application requirements.
•Managed project scope.
•Used oral and written communication skills.
•Provided daily updates on application progress.
SPHERION – Chicago, IL May 2006 - February 2007
•Applications Developer
Client: Federal Reserve Bank of Chicago
•Used Lotus Notes/Domino version 6.5.3.
•Developed, supported, and enhanced Lotus Notes client applications using @functions and LotusScript.
•Developed, supported, and enhanced Domino web applications using HTML, JavaScript, Java, Visual Basic and
LotusScript.
•Used Crystal Reporting tool.
•Used SQL skills for accessing back-end data.
•Used MS SQL Server 2005 skills for T-SQL development.
•Used TOAD to access and create Oracle applications
•Used Ajax programming skills.
•Used Moody’s software for risk analysis purposes.
•Worked with team on disaster recovery for all our software application processes.
•Provided periodic updates on application progress.
•Worked with user groups to gather application requirements.
EDUCATION/TRAINING/CERTIFICATION
Keller Graduate School of Management – Addison, IL Graduation: August 2014
Master of Business Administration with IT concentration
DeVry University – Addison, IL Graduation: August 2012
Bachelor of Science in Technical Management
Southern Illinois University – Carbondale, IL Graduation: December 1995
Computer Information Processing
TRAINING 2009 – 2010
ITIL Six Sigma Green Belt
SharePoint Project Management
CERTIFICATIONS
HTML Certification Lotus Notes Lotus Certified Professional, (CLP)
Contact this candidate