PROFESSIONAL SUMMARY:

• Motivated and results - driver BI developer with a proven track record in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics related projects. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.
• Extensive professional experience in design, development, implementation and support of mission-critical BI applications.
• Experienced in developing, implementing, documenting, monitoring and maintain the data warehouse extracts, transformations and ETL process in various industries like Financial, Heath Care, Retail, etc.
• Delivered BI reporting solutions in Qlikview, QlikSense, Reporting Services (SSRS), Power BI and MicroStrategy.
• Experience across entire MS BI suite of products including SQL Server, SSIS, SSRS, SSAS, and Power BI from prototyping to deployment.
• Experience with all phases of software development life cycle (SDLC) and Agile methodologies.
• Worked in small and large projects. Believe in team work. Have delivered as a team member, team lead and as independent consultant. Excellent communications and leadership skills.

TECHNICAL SKILLS:

Tools: MS SQL Server 2005/2008/2012/2016, MS SQL Services (SSIS), Analysis Services (SSAS), MS Visual Studio 2005/2008/2010/2015, Informatica 8.6.1, DB Visualizer 9.2, MySQL, Access, Automation Anywhere Enterprise Client 7.1, Teradata, Pragmatic Workbench, Visio, MS Project, Oracle 11g, MS Office 2013/ 365

Development Skills: SQL, MDX, C#, VC++, C++, Java, Visual Basic, .Net, HTML, ASP, MAPI, COM, CORBA, JSON, UML

BI Reporting Tools: Qlikview 10/11, QlikSense 1.1, NPrinting, Qlikview Server, SSRS, Power BI, Crystal Reports Data Quality and Standards Data/Business/Systems Analysis Agile Methodology

PROFESSIONAL EXPERIENCE:

Sr. BI Reporting / Applications Developer

Confidential, Dallas, TX

• Providing quality and availability of single family home rental data, lifecycle risk analytics, KPIs, and predictive performance modeling in the rental housing industry.
• Worked with individual business departments to achieve their department’s objectives effectively, monitor strategic information analytics and communicate reporting requirements while exploring systems solutions for the company’s IPO.
• Developed, maintained, tested, documented, and research application solutions for rental home applications by providing automation of reports and analytics data.
• Managed, mentored and oversaw one of our reporting off-shore teams on the completion of projects.
• Duties include: application and report design; developing, maintaining, and analyzing data to understand the business process; developed, built and implemented SSRS reports and dashboards using Qlikview, QlikSense, and Power BI; helped in the creation of cubes, dimensions and business critical KPIs using (and learning) SSAS; created and maintain ETL packages using SSIS to extract data from different systems; created, maintained SQL scripts and MDX queries for the analysis and extraction of reports; coding, testing, training and impletion of custom applications; on-going documentation of all phases of software development; played a supporting role in comprehensive IT, IT Disaster recovery, and security policies.
• Utilizing Qlikview (10/11), QlikSense 1.1, Qlikview Server, NPrinting, SQL Server (2012/2016), MDX, Tabular, SSIS,SSRS, SSAS, Power BI, MS Visual Studio 2015, Pragmatic Workbench, DB Visualizer 9.2, JSON, Visio, MS Office (2013/365).

Solutions Consultant

Confidential - Plano, TX

• PayPal - BI Reporting: analysis, design, development and deployment.
• Designed a business dimensional data model to improve the timeliness and accuracy to PayPal’s working capital reporting to achieve each department’s objectives effectively.
• Worked with the company to design, develop, and test a suite of Qlikview UI reports to track critical company operations. By providing information to effectively compare performance of products, as well as analytical reports to receive maximum revenue.
• Duties include: design, acquisition of resources, coding, testing and impletion of the application; analyzing data that is use to insure the information is correct. Mentored other developers and users on features and abilities of Qlikview. Utilizing Qlikview 11, Qlik Sense 1.1, Qlikview Server, NPrinting, SQL.
• Consolidated Health Plans - Information Delivery System / BI Reporting: design, development and deployment.
• Designed and implemented data mart that allows the company to report and analyze data across several dimensions. The data mart was implemented using a star schema. As well as complete the infrastructure set-up of Qlikview applications in their data center.
• Worked with CHP to design, develop, and test 31 Qlikview UI reports. Which will provide data to effectively compare performance, revenue and non-revenue, as well as analytical reports in order to receive the maximum revenue reimbursement from the state.
• Duties include: design, acquisition of resources, coding, testing and impletion of the application; analyzing data that is use to insure the information is correct for each department. Utilizing Qlikview 11, Qlikview Server, NPrinting, SQL.
• Haliburton - Sales Analysis and Reporting System: design, development and deployment.
• Worked with the company to design, develop, and tested a Qlikview UI to show their Sales application. Which will provide summary to detail level sale data analysis through an easy-to-use, robust and flexible interface capable of handling multiple levels of user expertise and requirements, data to effectively compare performance, cost and gain a valuable perspective on oil sales using several dimensions.
• Designed and implemented data mart that allows the company to report and analyze data. Business analysis that included logical integration across multiple business data sources and functional areas. The data mart was implemented using a star schema.
• Duties include: design, acquisition of resources, coding, testing and impletion of the application; analyzing data that is use to insure the information is correct for each department. Utilizing Qlikview 11, Qlikview Server, NPrinting, SQL, Oracle.
• Metrocare - Sales Analysis and Reporting System: design, development and deployment.
• Worked with health care company to design, develop, and tested a Qlikview UI to show their Sales application. Which will provide data to effectively compare performance, cost and gain a valuable perspective on employees’ overall health.
• Duties include: design, acquisition of resources, coding, testing and impletion of the application; analyzing data that is use to insure the information is correct for each department. Utilizing Qlikview 11, Qlikview Publisher, Qlikview Server, NPrinting, SQL.

Sr. BI Reporting / Applications Developer

Confidential - Dallas, TX

• Providing quality and availability of residential energy data, lifecycle risk analytics, and predictive performance modeling in the energy industry.
• Worked with energy business clients to monitor strategic information analytics and communicate reporting requirements while exploring systems solutions.
• Developed, maintained, tested, and research application solutions for different energy applications that provide an automation of reports and analytics data.
• Establish and maintained written documentation of the energy applications and reports.
• Worked with individual clients in departments to achieve their department’s objectives effectively.
• Duties included: application design, acquisition of dependent resources; coding, testing, training and impletion of the application; build and maintain SQL scripts, indexes, and complex queries for analysis and extraction; developing and implementing reporting, ETLs and data solutions; on-going documentation of all phases of the development; analyzing data that is used to insure the information is correct; develop and maintain an understanding of the business processes.
• Utilizing Qlikview (10/11), QlikSense 1.1, Qlikview Server, Qlikview Publisher, NPrinting, SQL Server (2008), VB, Visual Basic Access (VBA), SSIS, SSRS, MS Visual Studio (2008), MySQL, Oracle 11g, Access, MS Office, Visio, Informatica 8.6.1, Automation Anywhere Enterprise Client 7.1

Applications Developer / Analyst

Confidential - Westlake, TX

• Providing quality and availability of residential mortgage data, lifecycle risk analytics, and predictive performance modeling in the mortgage industry.
• Worked with mortgage business clients to monitor strategic information analytics and communicate reporting requirements while exploring systems solutions.
• Developed, maintained, tested, and research application solutions for different mortgage applications that provide automation of reports and analytics data.
• Worked with individual clients in different departments to achieve their goals effectively, all while working my way towards a lead role by managing developers.
• Supported ETL processes for large-scale data warehouses; and conducted ETL troubleshooting and performance tuning.
• Establish and maintain written documentation of the mortgage applications.
• Duties included: application design, acquisition of dependent resources; coding, testing, training and impletion of the application; on-going documentation of all phases of the development; plan, design, and implement application database code objects, such as stored procedures and view; writing complex queries and SQL scripts; developing and supporting analysis solutions; data transformation, and reports; analyzing data that is used to insure the information is correct; develop and maintain an understanding of the business processes.
• Utilizing Visual Basic, Visual Basic Access (VBA), .NET 2.0, SSIS Packages, SQL (2000/2005/2008 ), SSAS, MySQL, Teradata, MS Access, Excel, MS Visual Studio (2005/2008/2010 ), Enterprise Data Warehouse, DB2, JAVA, Agile Methodologies, Learning and training doing Powerbuilder, ETL, MS Visio

Sr. Actuarial Systems Analyst / Developer

Confidential, Richardson, TX

• Provided timely, cost-effective actionable information to the actuarial functions of product development, pricing, reserving, and financial reporting and source gain/loss.
• Worked with underwriting claims to monitor strategic initiatives and communicate reporting requirements while exploring systems solutions.
• Developed, maintained, tested, and research application solutions for a self-service reporting applications that provides automation of reports and allows users to create their own reports based on criteria they entered.
• Establish and maintain written documentation of the health care insurance reporting applications.
• Duties included: application design, application design; acquisition of dependent resources; coding, testing and impletion of the application; on-going documentation of all phases of the development; analyzing data that is use to insure the information is correct.
• Utilizing Visual Basic, .NET 2.0, Learning and training doing C# and ASP, SQL (2000/2005), Teradata, MS Project, Excel, Crystal Reports, MS Visual Studio (2005/2008), DTS / SSIS Packages, SSRS, Enterprise Data Warehouse, Cognos, and Lotus Notes.

Programmer / Analyst

Confidential - Dallas, TX

• Developed, maintained, tested, and research application solutions for providing automation of health care and dental care insurance administration.
• Establish and maintained written documentation of the health care insurance applications while working with individual clients to achieve their department’s objectives effectively.
• Duties included: application design; acquisition of dependent resources; coding, testing and impletion of the application; and on-going documentation of all phases of the development process.
• Utilizing Visual Basic, Visual Basic, Access, DB2, SQL, and Source Safe.

Programmer / Analyst

Confidential - Richardson, TX

• Developed, maintained, tested, and research application solutions for providing tax preparation software to insurance companies.
• Establish and maintained written documentation of test procedures for tax returns while working with individual clients to achieve their department’s objectives effectively.
• Duties included: application design; acquisition of dependent resources; coding, testing and impletion of the application; and on-going documentation of all phases of the development process.
• Utilizing VC++, MFC, Visual Basic, SQL, Crystal Reports, and Source Safe.

Consultant

Confidential - Dallas, TX

• Working temporary jobs in and out of the computer field through employment agencies.
• Taking care of my dad who was in bad health at the time.
• Utilizing VC++, MFC, Visual Basic, SQL, Crystal Reports, and Source Safe.

Software Engineer

Confidential - Richardson, TX

• Demonstrated ability to function effectively with clients hands on to solve real world problems, as well as work independently to achieve organizational objectives.
• Developed, maintained, and tested automation machine production applications for the semiconductor industry. Applications that control the movements of robots (or machines) through user interfaces.
• Developed, maintained, and tested an industrial video conferencing and video messaging application. By receiving an application that was very unstable and delivered a stable system that is being mass marketed.
• Utilizing VC++, MFC, object-oriented analysis and design techniques, MAPI, COM, Active X, UML, and Source Safe.

Software Engineer

Confidential - Richardson, TX

• Responsible for developing, designing, and debugging parts of a Y2K and 32 to 64 bit migration application in a Windows NT / 98 / 95 environment. The Migration application searches for problems in the code which allows the user to make changes to fix the problem areas. Producing new code that the user can compile and use in their development environment.
• Started out for three months as a tester learning the tool and helping get their testing group going while establishing and maintaining written documentation of test procedures.
• Utilizing VC++, C++, Access, Lotus Notes.

Software Engineer

Confidential - Richardson, TX

• Responsible for the full life cycle development of a telecommunications Operating Support System application in a Windows NT environment while working directly with the clients on fulfilling their requirements. The Inventory module of the application was responsible for tracking inventory, wire centers, cables and desktop applications. The Assignment module of the application was responsible for tracking what equipment was used at several locations. Provided documentation during each phase of the development. Also, provided support to users during the implementation of the application.
• Utilizing VC++, C++, and object-oriented analysis and design techniques, CORBA, Persistence PowerTier C++ and Java with MFC. Learning and using Java the last three months there to move the modules from VC++ / C++ to Java / J++ Builder.