SUMMARY:

Detail - oriented BI Developer with experience in diverse industries, including entertainment & communications, health insurance, healthcare provider, biotech, Federal/State regulations, and finance. Energetic self starter and strong, independent worker. Recognized for effectively analyzing data and procedures to generate new ideas that improve efficiency and creative design. Expertise in Oracle and SQL Server.

TECHNICAL SKILLS:

• C#, JQuery / JavaScript / XML, T-SQL
• Extensive experience working with databases in Oracle 8i / 9g and SQL Server / R, creating complex stored procedures for ETL data load (tuning / indexing), and developing reports with SSRS / R
• Data Warehousing using Microsoft or Oracle BI tools (OLTP / OLAP DB)
• Building data model for ETL process in SQL Server for Enterprise Data Warehouse
• Designing Map using SSRS for Executive Dashboard (geospatial)
• Creating SharePoint PPS report and integrate it with SSRS (SharePoint 2007 or above)
• SSIS Packages
• SSAS Cube Design and MDX queries.
• SharePoint Designer 2007, SharePoint administration task, Red Gate SQL tools
• Knowledge of SSAS, C# (console application), XML, XQuery (Query XML), XSLT, XPath (Navigate XML)
• TFS and Agile and SDLC

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Developer

Responsibilities:

• Design Physical and Logical database design and diagram using E-R Data Architecture Modeling for analyzing data integrity and database structure (entity relationship diagram).
• Create data migration including data scripting, auditing migration script, data validation, error handling, QA testing in FMIS database.
• The coding of stored procedures, user functions, Table Functions, views in FMIS database.
• Design or modify SQL Server Reporting Services reports (SSRS) from scratch
• SQL Server Integration Services (SSIS) ETL packages / processes and addition to data mapping and database and table logical/physical design in FMIS database.

Confidential, Washington, DC

Data Engineer

Responsibilities:

• To provide support and maintenance for existing SQL Server Databases, ASP.Net, WCF SOA applications, Reporting Service Administration, Integration Services packages that are being used throughout the enterprise system.
• The coding of stored procedures, user functions, SQL Server Reporting Services reports (SSRS) and SQL Server Integration Services (SSIS) packages / processes and addition to data mapping and database /table design.
• Act as DBA to maintain semiannual password change in the entire databases and applications, managing user database access and roles, schedule Database Recovery (DR), bi-weekly auditing databases changes, and maintain documentations.
• Provide suggestions for performance improvements for SSRS, SSIS, databases, and applications.
• Work with Data Analysts to reverse engineer existing complex ETL, ASP.net, and MS Access solutions

Confidential, White Marsh, MD

Senior Database Developer

Responsibilities:

• To provide SQL development support to the Data Analyst Team by designing and building, ETL processes from account and customer management software to reporting system.
• The coding of stored procedures, user functions, SQL Server Reporting Services reports (SSRS) and SQL Server Integration Services (SSIS) packages / processes and addition to data mapping and database /table design.
• Work with Data Analyst team and DBA to build T-SQL, SSRS and /or SSIS solutions in order to automate existing MS Access and MS Excel reports.
• Review and interpret ongoing business report requirements, research required data and build appropriate reporting deliverables.
• Analyze existing SQL queries for performance improvements.
• Work with Data Analysts to reverse engineer existing complex MS Access solutions
• Design and build ETL processes.

Confidential, Columbia, MD

SQL Developer

Responsibilities:

• Designs, develops, and deploys new reports for all corporate divisions
• Repair reports when they have been reported as broken
• Works with database analysts when report issues have been determined to be data related.
• Functions as part of an assigned project team for approved initiatives.
• Develops enhancements to existing reports as requested.
• Performs initial testing of reports and makes modifications when necessary
• Hands off work to Quality Assurance as required
• Participates in discussions with the customer along with assigned Business Analyst to clearly understand reporting needs. Works with customers directly in the absence of an available business analyst.
• Follows up with customers to assure that needs have been met.
• Creates SSRS page with directory structure for reports
• Creating the complex stored procedures, user defined functions and SQL queries/scripts to validate completeness, integrity and accuracy of data. To include table for handling error
• Use MDX queries to create reports in SSRS.

Confidential, PA

SSIS/ETL Developer

Responsibilities:

• Design and Development of SQL Server packages using SQL Server Integration Services to perform ETL Operations.
• Continued to develop ETL process for phase III deployment:
• Responsible for deployment of packages in production and providing the support.
• Migrating SSIS packages from development stage to quality analysis (testing) and to production.
• Creating the complex stored procedures, user defined functions and SQL queries/scripts to validate completeness, integrity and accuracy of data. To include table for handling error data and data validation.
• Development of custom SSIS components using C# to provide the required transformations.
• Setup logging environment to track the status of the events like error raise, task fail so on.
• Performance tuning of SQL Server Database by creating necessary indexes, partitioning, tuning of Stored Procedures and user defined functions.
• Scheduling and alerting jobs using SQL Server Agent.
• Developing XSLT scripts in order to transform the XML data source and XPATH.
• Developing XSD script to validate the XML message using the DTD schema.

Confidential, Columbia, MD

SSRS/SSIS/ETL Developer

Responsibilities:

• Converted and standardized all SRS R2, resulting in
• Consistency in formatting of all reports with specified formats and conventions.
• Strictly using procedures, rpt schema, and TFS.
• Adding map capabilities with custom built region, district, and territory.
• Built custom cross-platforms .NET application for Executive Dashboard (MVC 3.0, C#, high-chart, java scripts and AJAX dependencies, Nuggets, OSM map, Geo JSON, ADOMD.net, MDX queries, OLAP data mart) that
• Had the capability to present dashboard in any browsers or machines / devices while they are connected to intranet or VPN.
• Designed charts and map interactions under HTML5 capabilities.
• Ensured data accuracy between sources to end-user point of view.
• Supported data enhancements that included modifying ETL process, procedures, SSAS calculated fields, etc.
• Created ETL process with complex stored procedures for daily loading data into Enterprise Data Warehouse, including
• Gathering business requirements.
• Creating Data Modeler for logical schemas.
• Building database, tables, views, and indexes based on approved data model schema.
• Analyzing tables to establish knowledge of data for accurate retrieval for data extractions.
• Creating stored procedures for data extractions and loads data into new Data Warehouse database from OLTP databases.
• Creating SSIS Execute SQL Task to run procedures above and Analysis Services Processing task to process data from Data Warehouse to SSAS cube.
• Developed SSIS packages to execute stored procedures for ETL process.
• Analyzed tables to establish knowledge of data for accurate retrieval and use in ETL extractions.
• Resolved data reporting issues and data quality issues to ensure complete, thorough and accurate reports that meet our business needs.
• Presented Lab Dashboards and Executive Metrics in charts and graphs with clear visibility in a way that was most meaningful and accurate.
• Worked with TFS and to keep track of changes made SSRS / SSIS files and share work between other developers.

Confidential, Milwaukee, WI

Information Analyst

Responsibilities:

• Converted existing reports in SSRS 2005 to SSRS 2008 with new database data mapping, creating based stored procedures (dynamic) as “parents” for all other stored procedures used by individual report stored procedures.
• Identified similar reports, greatly reducing the number of reports in production server (from over 3 ).
• Centralized storing procedures, resulting in optimization of data accuracy.
• Supported normal reporting by modifying existing reports, creating new reports and modifying stored procedures for enhancement and data accuracy.

Confidential, El Segundo, CA

Regional Report Analyst

Responsibilities:

• Building upon the success of the West Region Reporting Website, continued to centralize reporting processes, including
• Developing a reporting library that included standardized queries / stored procedures for most common requests.
• Documenting standard processes and common reporting methodology.
• Developing a migration plan and then implementing forced movement of end-users toward website by gradually shutting down other reporting sites, and report file in shared drive locations.
• Increased the use of dynamic reporting tools to provide end-users with a more flexible reporting environment.
• Improved development in SSRS reporting services.
• Sought out opportunities to provide more effective / sophisticated reporting tools for advanced reporting users (“analysts”) across region.
• Assessed and recommend improvements in structure or ACP, SMS, and Net Gain databases.
• Documented each database.
• Implemented change control process.
• Working closely with other team members, developed leadership and effective delegation for individual development.
• Completed projects with positive impact on the business, including
• Creating and modifying stored procedures.
• Analyzing and converting legacy DTS packages into SSIS packages.
• Optimizing daily / weekly / monthly / quarterly ad-hoc queries, reducing the CPU cost processing time.
• Developed database designs to account for long-term growth.

Confidential, Los Angeles, CA

Analyst / Programmer

Responsibilities:

• Created / managed ETL process for Data Warehousing from Oracle to SQL Server and ensured procedures were updated as changes in databases occurred.
• Developed and maintained DTS / SSIS packages, including rerunning the job when it failed.
• Supported departments that had special needs in reports by creating / designing databases, tables, indexes, views for data marts.
• Created SSRS reports, including managing user privilege for accessibility and user subscriptions based on territory and / or roles.
• Managed and troubleshot user queries for power users in custom-built ASP applications (similar to SharePoint) where power users have capabilities to generate their own reports (drag and drop OOP) from available data marts.
• Worked directly with other departments in supporting and improving their information needs.
• Trained users with new reports capabilities or standardize their reports.