We provide IT Staff Augmentation Services!

Sr. Bi Developer/report Writer Resume

SUMMARY:

  • Self - motivated and experienced Project manager/Software developer/Business Systems Analyst with excellent interpersonal, analytical, problem solving and communication skills.
  • Experienced with requirements elicitation, analysis and documentation; business process analysis, systems design, coding and testing.
  • Have extensive experience with Crystal reports and Business Objects, including universe design; SQL Server Analysis and reporting services as well as Cognos reporting
  • Skilled in writing complex stored procedures, triggers and DTS/ SSIS packages and has experience with both database development and administration.
  • Substantial experience dealing with both internal and customer/partner-facing projects, and working with both technical and non-technical groups including software vendors.
  • Have experience with extracting data from different sources, transforming it and loading into either production databases or data warehouses.
  • Did occasional presentations to Baltimore city upper management.
  • Managed IT projects involving multiple internal departments and external vendor/partners. Oversaw the work of two System Administrators/trainers

PROGRAMMING LANGUAGES AND SOFTWARE PROFICIENCY:

  • HTML, JavaScript and CSS
  • C#
  • Oracle 9i
  • Toad for Mysql and Oracle
  • Transact-SQL
  • PHP
  • Java J2EE, EJB, JSP and Servlets
  • Visual SourceSafe
  • MSSQL server 7 - 2012, Oracle 9i, Sybase and MySQL up to version 5
  • Microsoft SQL server analysis services (SSAS)
  • Microsoft SQL server Reporting services up to 2008 R2 (SSRS)
  • Microsoft SQL Server Integration services (SSIS)
  • Cognos reporting up to V.8

EXPERIENCE:

Confidential

Sr. BI Developer/Report writer

Responsibilities:

  • Responsible for reporting requirements gathering, development and deployment of Power BI and SSRS reports.
  • Project Portfolio data analysis, I have also been responsible for developing a mufti-dimensional model for project portfolio and figuring out how to tie other data sets such as funding allocation to projects in that data model.
  • I am also responsible for training internal IT resources and help them adopt new BI tools such as SSRS and Power BI from the old Crystal reports platform.
  • Uses SSIS packages for integrating datasets from multiple data sources. Some vendor-hosted with on-premise.

Confidential

Responsibilities:

  • Installed web-based point of sale system and designed an Analytics database to get insight into which products are selling, how long they are staying on the shelf and the profitability of each product category.
  • Set up a new web-based accounting system to help transition from paper-based accounting system.
  • Developed a website to track the price movements of securities owned by Confidential . We get the watch lists send to us as email attachments and we have scheduled scripts to parse through the files and inset stock data into database tables.

Confidential

Sr Application Developer

Responsibilities:

  • I designed and developed data warehouses and packages to Extract, Transform and Load data from multiple data sources into the data warehouses.
  • Data consolidation and storage for optimal retrieval using Business intelligence and/or reporting tools.
  • I designed Analytical databases and pre-aggregated data for easy data retrieval and analysis.
  • I developed reports and dashboards for users at different organizational levels, ranging from field technicians to middle managers and Baltimore City’s top executives.
  • I occasionally conducted training for both technical developers and software end-users.

Confidential

Technical Consultant

Responsibilities:

  • Did the initial product deployments including data model and BI tools for Higher education institutions.
  • Tools I worked with on a daily basis are SQL server 2008 R2 - 2012, SSAS, SSIS, SSRS, Pyramid Analytics, ProClarity and SharePoint PerformancePoint. Modules worked on include Student Admissions and Enrollment, Finance and Human Resources. This involved setting up the data model to pull data in from ERP solutions such as Banner and PeopleSoft.
  • Customized the base relational and OLAP data models to fit unique client needs.
  • Handled technical client support needs for clients that have not transitioned into the support and maintenance phase and acts as first line of technical support for functional consultants that are on client sites.

Confidential

Sr Application Developer

Responsibilities:

  • I managed the technical (IT) aspect of Baltimore’s 311(Non-emergency communications) operations including liaising with city agencies and different vendors of software products that integrate with Baltimore’s 311 System.
  • Advised Citistat on best IT business practices, and how the City agencies can leverage on available technologies as well as provide actionable information on whether agencies are deploying resources more efficiently.
  • Delivered a solution that enabled Citistat analysts to tap into the city's water billing data; after automating a process to pull the data out of the legacy mainframe system into a data warehouse for analysis and reporting.
  • My position at the City was about 50 percent project management (planning, eliciting, analyzing and prioritizing user requirements; liaising with software vendors on required software modifications, and following through to ensure timely delivery of required solutions). This also involved mentoring/training call center supervisors on the use of available technologies (mostly reporting and analytic tools). The other 50 percent was more hands-on (revising existing business practices and recommending more efficient ways of doing things, cleaning and performing data integrity checks, querying different databases to ensure that interfaces between different systems are working as they should; extracting, cleaning/transforming and loading data from different systems into a decision support platform for analysis and reporting; testing deliverables for quality control and developing user guides before changes are implemented in the production environment.
  • I designed and scheduled performance and statistical reports for the city’s top managers and administrators, using Cognos and/or SSRS.
  • I spent a good chunk of my time writing and running stored procedures and SQL queries for data consistency checks, diagnosing and cleaning up data issues and oversee the work of two Systems Administrators/Trainers.
  • Train Citistat and other agency analysts on the use of the city’s analytic and reporting tools.
  • I Analyzed performance metrics upon which different city agencies’ performance was measured, diagnosed and fix reporting issues.
  • Among major accomplishments with the city are; the implementation of the city’s Mobile Application, diagnosed and fully repaired an application interface that malfunctioned for years.
  • I constantly analyzed existing practices to identify and document things that could be automated and the best ways to do it.
  • Served as a liaison between internal database administrators, end-users and some of the software vendors’ technical staff.
  • I designed SSIS and DTS packages to pull and clean data from multiple systems into our decision support and reporting platform.

Confidential

Business Systems Analyst/Consultant

Responsibilities:

  • Managed the technical aspects of a successful data cleanup and migration from one ERP solution (producer licensing) to another (SBS). The process involved talking to employees that were familiar with business processes, reading and modifying program code to conform to existing or desired business rules.
  • Worked on data cleanup project for company licensing, liaising with software developers, end-users and the Confidential to understand how applications, data storage infrastructure were configured in order to clean and turn the data into meaningful and usable information.
  • Performed gap analysis on the existing system. I worked with a team of developers onsite and third party technical resources to identify the gap between what the application and data structures were supposed to be versus the prevailing condition; and figured out the best way to close the gap and validate business rules before migrating the data to a newer platform.
  • Elicited, analyzed, documented, communicated and validated requirements for changes to business process, policies and information systems.
  • I am a self-starter; I identified, planned and executed own projects; sometimes borrowed competent resources from other projects.
  • I worked with both technical and non-technical groups to establish business requirements, to gather requirements, identify missing producer licensing data and data inconsistencies.
  • Wrote database stored procedures to clean dirty/inconsistent data before migrating to a new ERP system
  • Troubleshoot and fixed producer data exchange interfaces between Confidential and its partners and/or third-party vendors.
  • Performs ETL functions using a combination ftp and staging tables, stored procedures and database triggers.

Confidential, Baltimore, MD

Business Systems Analyst

Responsibilities:

  • Dealt with 14 different vendors to establish sales data sharing and reporting procedures.
  • Slashed vendor relationship management costs, by analyzing sales data and identifying relationships that were worth keeping vs the ones that drove costs up without bringing in enough revenue.
  • Most of the business logic was coded in stored procedures for both processing speed and code reusability.
  • Worked closely with the sales directors and managers on establishing reporting requirements and methods of data delivery.
  • Designed sales data collection database, coded stored procedures, triggers and DTS packages to import data from different sources, then designed and automated reporting of the collected data to sales teams, territory managers and directors in order to facilitate accurate compensation to sales people based on the revenue they brought in.
  • Performed ETL functions using a combination of ftp and SQL Server DTS packages to load data into a Data warehouse.
  • Produced monthly sales reports from data warehouse
  • Troubleshooting and fixing faulty reports
  • Responsible for contingency and strategic planning of the vendor sales/reimbursement component.

Confidential, Elkridge, MD

Business Systems Analyst

Responsibilities:

  • Collected and documented user requirements, then designed databases, coded queries and configured the Hansen ERP solution to fit the user permitting and licensing specifications. Most of the coding was done in stored procedures and most processing took place at the database level in order to enforce data integrity.
  • Responsible for Business Objects XI report design and deployment
  • Troubleshooting and fixing faulty reports.
  • Coded java middleware on several in-house systems
  • Facilitated end-user training after software configuration and deployment.
  • Coordinated with other analysts and the divisional director to ensure timely delivery of multiple project milestones.
  • Performed ETL functions using a combination of ftp and SQL Server DTS packages. With some clients, we used a combination of ftp, staging tables, stored procedures and triggers.
  • Other responsibilities included: implementing Hansen ERP solution at Caroline county (MD), coding SQL queries, triggers and stored procedures for the Cecil county project and complete implementation of the elevator licensing module at Fairfax county (VA).

Confidential, Baltimore, MD

Programmer Analyst

Responsibilities:

  • Worked as a primary IT resource for the producer licensing system (keeping track of all insurance brokers in the state of Maryland) and developed additional components of the system, including public adjuster and motor vehicle rental insurance licensing.
  • Acted as a liaison between application developers and database developers/administrators.
  • Troubleshooting and fixing faulty reports
  • Led and participated in projects led by other developers, such as the development of market conduct.
  • Made extensive use of java middleware coding, Crystal reports 9 and 10, but also coded HTML and JSP pages. Spent majority of time coding stored procedures, triggers on Sybase database server 12.

Confidential, Windhoek, Namibia

Programmer Analyst

Responsibilities:

  • Worked as primary IT resource for the municipal finance system, tasked with a complete redesign of the procurement (Asset management) component of the finance system.
  • Led the development of the bus register system, keeping track of municipal bus routes, schedules, drivers and the number of passengers on each bus on any given route at a given time.
  • Troubleshooting and fixing faulty reports
  • Other projects included: participating in projects led by other developers, such as the redesign and coding of municipal billing system and the water and electricity distribution systems.
  • Performed ETL functions using a combination of ftp and SQL Server DTS packages; while a combination of Progress Database functions and staging tables were used for extracting, transforming and loading data into different progress databases.

Hire Now