• l Professional individual with 16 years of IT experience in manufacture, insurance, mortgage/banking, sales marketing industries with both technical and business analyst experience reviewing and analyzing the effectiveness and efficiency of existing systems and developing strategies for improving or further leveraging the systems which require liaison between business client and IT departments. Demonstrate the ability tmanage multiple projects with tireless energy and dedication.
• l Extensive experience in data analysis, data quality, data migration, extraction, transformation, load, data integration, data enrichment, data warehousing, data modeling, designing, coding, reporting, testing and supporting next-generation database solutions on client/server platforms.
• l Expertise in building business intelligence and corporate performance management solutions including dashboards and mobile dashboards QlikView/LogiXML/Tableau/SSRS/Nevron , score cards, ad-hoc query, interactive reporting, and analysis reports with drill through, drill down.
• l Strong experience as a Business Liaison/Business Analyst Responsible for gathering requirements, gap analysis, coordinating business requirements discussion with business and technical teams, prioritizing issues and tasks, ensuring technical team delivers applications according tbusiness requirements within deadline and with quality. Monitor technical team performance and estimations on critical issue resolution and project delivery.
• l Strong experience with SDLC and Agile Approach tproject work and delivery. Utilize Waterfall-Agile approach tgetting projects completed quickly with documentation.
• l Consistently recognized for technical troubleshooting skills used trapidly and cost-effectively resolve challenging technical data issues.
• l Exceptional analytical problem solver with great communication skills capable tsupport customers in and technical teams internal and offshore India .
• l Quickly learn and master new technology equally successful in both team and self-directed settings and proficient in a range of computer systems, languages, tools and testing methodologies.
• Database/Business Intelligence Experience

Technology Summary

IT Experience

Confidential

Business Intelligence Consultant,

Provide Business Intelligence reporting solutions tinternal and external clients.

Duties included:

• l Utilized Logi Analytics LogiXML tools, JavaScript, VBScript, HTML, and CSS tdevelop and deliver the presentation layer of the solution as outlined in the statement of work from various clients.
• Created advanced interactive reports and charts, drill-down and drill-through reporting, real time dashboards, mobile dashboards, disclosure, and base views for advanced statistical analysis.
• Developed Analysis and OLAP Cube Grids for use by clients tanalysis their data.
• Developed prototypes for prospects using LogiXML Studio, HTML, DHTML, JavaScript, and .NET.
• l Utilized SQL Server and MySQL tdevelop queries, stored procedures, and indexed tables for faster delivery of data in the presentation layer.
• Wrote MDX queries as part of creating dashboard reporting for clients with data warehouses.
• l Utilized Microsoft IIS, Apache, and Tomcat web servers tdeliver .NET and JAVA web applications.
• l Analyzed data for reporting and dashboard creation.
• l Meet with various customers tgather reporting and data requirements and turn those requirements intLogiXML and QlikView web applications.
• l Defined site navigation and created interaction models for both internal and external clients.
• l Worked independently or within a small team with a focus on helping clients formulate proper business concepts, interface design, and content presentation.

Confidential

Contractor Database Developer/Business Intelligence,

Implement server and software upgrades and continuous improvements tManufacturing Execution Systems MES . Responsibilities include following an Agile, Software Development Lifecycle SDLC , and emulating reusable Component-Based Designs within a database. Domain includes disaster recovery and performance standards and audit procedures, new application testing, training, and creating Microsoft SQL queries, SSIS SQL Server Integration System packages, SSRS SQL Server Reporting Services reports and stored procedures. Recommending and implementing an efficient and reliable infrastructure tmaximize transactional efficiency when collecting data and warehouse techniques for reporting performance. Understand and support the KRS architecture and software and support the continued evolution of the system throughout Kaisers' plants. Duties included:

• l Developed solutions using MS-SQL Server, Transact SQL T-SQL , SSIS, SSRS Nevron Charts , and SSAS
• l Utilized RedGate, Team Foundation Server and Seapine Test Track ttest and track defects and database changes and queries. Setup Team Foundation Server and Redgate Source Control ttrack changes tthe database, tables, stored procedure, functions, and views.
• l Developed PEEKS application thelp plant operator perform their daily task by providing work order and recipe information.
• l Created SQL objects tsupport data warehouse/data mart infrastructure
• l Practiced agile software development in a collaborative team environment tinclude documentation of proposed business story, design approach and plan for testing for peer review at strategic development phases
• l Created data models and manage tasks and projects in support of software application development
• l Coordinated implementation of new software and accompanying processes with other departments
• l Tracked software test results and report status tmanagement
• l Created and validated factory knowledge reports and underlying data quality tsupport the incremental spiral development model
• l Deployed factory floor interfaces tpresent and record machine and operator input
• l Synchronized lessons learned and software components between plant deployments
• l Identified continuous improvement opportunities through site visits that will have measurable business impact within the manufacturing process
• l Defined opportunities for application development and functional extensibility
• l Recommended new applications and platforms, support the hardware and software infrastructure of the Kaiser Recipe System
• l Proposed and implemented database enhancements tsupport process knowledge
• l Optimized software configuration and establish proactive automated performance metrics and validation reports tidentify potential N-Tier discrepancy or malfunction and opportunities for improvement
• l Utilized skills ttroubleshoot and propose creative yet simple solutions
• l Identified best practices taddress operational risk, fault tolerance, security and disaster recovery solutions
• l Established, debug, demonstrated, and mistake-proof database administration, recovery and audit procedures for new and existing software applications
• l Created technical specification and test plan documentation.

Confidential

Contractor BI Report Developer,

• Provide development, system analysis, technical support, reporting, and peer troubleshooting assistance thelp improve Mid-Atlantic's decision making, optimize performance, and achieve reporting requirements. Work with team of CIO, Operations Manager, Analysts tbuild highly performing database system and business intelligence reporting:
• l Developed reports, forms, and dashboard using LogiXML, HTML, CSS, JavaScript, and SQL Server 2008 database.
• l Provide support of daily SQL Server jobs and troubleshoot issues with data.
• l Analyze complex source system data. Prove calculations/algorithms.
• l Critically evaluate information gathered from multiple sources and reconcile potential conflicts of data/calculations.
• l Create technical specification and test plan documentation.

Confidential

Contractor BI Data Warehouse/Report Developer,

• Support Virginia Department of Health, Office of Information Management OIM Data Warehouse team tprovide development, system analysis, technical support, reporting, and peer troubleshooting assistance thelp improve VDH decision-making, optimize performance, and achieve reporting requirements. Work with team of analysts, developers, managers, and business resources tbuild highly performing system and business intelligence reporting:
• l Developed reports and dashboard using LogiXML and Oracle 11i database.
• l Analyze complex source system data. Prove calculations/algorithms.
• l Developed complex ETL processes in Oracle 11i TOAD and WhereScape Red as well as dimensional modeling architecture conducive treporting.
• l Developed ETL tpull data from multiple sources intthe data warehouse.
• l Critically evaluate information gathered from multiple sources and reconcile potential conflicts of data/calculations.
• l Create technical specification and test plan documentation.

Confidential

Contractor Data Warehouse Developer II

• Reporting tthe Director of Information Management, design, develop, and implement business driven information system solutions in a timely and efficient manner using data warehouse dimensional modeling techniques, corporate intranet technologies, SQL coding and end-user reporting tools. My responsibilities include but are not limited tthe following:
• l Contributed tthe design, development, customer support and other data management team projects using Microsoft's Business Intelligence toolset SSIS, SSRS, SSAS .
• l Take business requirements for new and enhanced data marts and implement the code changes intthe ETL process using SSIS.
• l Support and enhance the existing Dimensional Model ensuring integrity of the data in the model and the data marts.
• l Troubleshoot and correct issues with existing applications in the data warehouse environment.
• l Support scheduled ETL processes and ensure efficiency and accuracy of outcome.
• l Identify new technologies or technological improvements tinclude in the application timprove usability, stability and maintainability.
• l Assist and lead design changes and enhancements of the data warehouse and end-user reporting environment.
• l Developed SQL queries and/or procedures and functions for complex data requests.
• l Worked with Web developer on programming data solutions intthe corporate intranet.
• l Lead/Mentor DW Developer I and Reporting Analysts and acting as technical lead assigning tasks tData Management staff as required and providing input for staff reviews.
• Support WCPrism Workmen's Compensation Project:
• l Documented SSIS Packages, tables, stored procedures, functions, and business rules.
• l Create VisiData Models show relationship between fact tables and tables used thold WCPrism data.
• l Automated the SSIS Packages for the medical claims file creation.
• l Added Claim Adjuster information tthe outbound claims files generated in SSIS.
• l Communicated with ISCompany and cross-functional teams within Builders tunderstand business rules and resolve prior issue with WCPrism processes.

Confidential

Database Engineering III,

• Support efforts tcreate a new data warehouse and new flexible reporting capabilities for the Department of Defense Army Food Management Information System AFMIS .
• l Senior ETL SSIS/SSRS Developer/DBA/Analyst for the new Data Warehouse Project. Responsible for reverse-engineering the existing business system requirements for AFMIS Dashboard Reporting in order tcreate new OLAP Data Warehouse and flexible Dashboard Reporting.
• l Develop ETL SSIS packages tmigrate data intstaging area initial and created SSIS packages for incremental loads utilizing SQL Server 2008 Change Data Capture tools tperform loads tdimension and fact tables instead of using Slowly Changing Dimension because CDC performance is faster and clearly identifies the inserts, updates, deletes that took place on the data in transaction logs without having tuse the lookup transformation with SQL Server 2008 tidentify new and changed records.
• l Created data diagrams and models tmap the relationships between tables utilizing SQL Server 2008 and Visio. Designed the star schema relation models for the new data warehouse.
• l Created auditing tables, stored procedures and SSIS processes ttrack package information, table name, insert, update, and delete record counts, capture errors critical and data for the SSIS process used tload data staging and intfact and dimension tables. Developed exception/error handlers tprevent issues with data being written tthe new data warehouse within SQL SERVER SSIS.
• l Created complex queries and functions tde-normalized data flatten tables tpopulate granular fact and dimensional tables for SSAS data warehouse and cube creation which allows for easier reporting in using star schema. Created SSRS reports tprovide drill-down, up, and through capabilities.
• l Utilizing Kimball and waterfall-agile process tcomplete all tasks with documentation of all data models, star schema relations, and ETL processes.
• l Participating in planning, analysis, and implementation of solutions in support of business objectives. Facilitated meetings tdefine business requirements, key strategic goals, and flexible reporting needs from the government functional project leads.
• l Document requirements, assist in clarifying discrepancies in requirements, and assist in obtaining appropriate approvals. Utilized SharePoint and One Note torganize meeting minutes and requirements and status of project.
• l Assisting in testing activities for maintenance, project assignments by identifying testing scope and scenarios, preparing test plans and scripts, capture metrics for all data extraction, transformation, load runs, results monitoring, feedback and sign-offs and issues tracking and resolution

Confidential

Database Analyst 4 Associate Vice President,

• Primarily provided database development and data reporting for Mortgage Marketing functions of House-Hold Lending marketing efforts. Manage Cross Sell data for the creation of monthly reporting, analytics, and client incentive payouts.
• Involved in supporting SunTrust Mortgage short and long range system planning and report development. Worked with Cross Sell Analytical Team and Project Management tensure effective and timely database support of all critical and ad-hoc marketing efforts.
• Gathered business requirements and performed gap analysis on the processes used for reporting.
• Utilizing Mortgage data, provided metrics on the primary relationships established between clients and SunTrust. Responsible for creating algorithms tcalculate the incentive payouts for clients whmeet specific criteria and have more than one booked product with SunTrust. Responsible for providing monthly booked business reports tup-level management tenable SunTrust tmeasure the success of the bank's marketing efforts.
• l Utilized SQL SERVER 2000/2005/2008 DTS/ETL/SSIS/SSRS tmanage and create Mortgage Marketing data warehouses, extracts, and provide ad-hoc reporting. Migrated SQL SERVER 2000 DTS packages tSQL Server 2008 SSIS packages. Created and scheduled DTS and SSIS packages tstreamline reoccurring ETL and reporting. Utilized script task tformat and control data written tExcel files.
• l Utilized script task VB.NET component of SQL Server 2008 and activeX VBScript component of SQL Server 2000 tcontrol the format and pivot of data on Excel spreadsheets.
• l Validated calculations against SAS dataset pulled from Oracle.
• l Utilized SAS 9.2 and SAS EG 4 tanalysis Mortgage client data suitable treceive marketing information on SunTrust target products. Developed SAS code tbuild extracts using data from Mortgage Marketing Database SQL Server 2000/2008 and UNIX Oracle Server robust databases with statements such as RSUBMIT, ENDRSUBMIT, PROC Download/Upload, and PROC SQL.
• l Performed database maintenance and monitoring of scheduled jobs. Re-wrote SQL code, which simplified and increased performance of DTS/SSIS/Stored Procedures used textract and report Mortgage data. Developed and implemented Mortgage Marketing databases, tables, views, stored procedures for future bank products.
• l Documented the Database tables, views, stored procedures, and DTS/SSIS packages processes.

Confidential

Senior Database Analyst/Direct Marketing Analyst,

• l Provided production database development support for the company's direct marketing campaign initiatives. Primary responsibilities included creating direct marketing extracts and reporting campaigns across multiple business lines and distribution channels.
• l Provided geographic and demographic metrics tbusiness clients for deciles of direct mail audience and further analysis.
• l Performed data mining, data warehousing, and data processing for clients Liberty Mutual Insurance Citrix.
• l Developed and designed SQL SERVER 2005/2008 marketing database and wrote SAS analysis programs tacquire and warehouse customer information used testablish customer profiles, identify potential markets, target customers and support new sales.
• l Utilized SAS and SQL Server 2008 T-SQL, DTS, ETL, and SSIS code taggregate and manipulate large data sets tcreate mail lists and/or campaign reports.
• l Analyzed post merge reporting tdetermine optimal mailing strategy including recommendations concerning postal optimization and regulations, list segmentation and data hygiene. Assigned matrix data for simple as well as complex direct marketing campaigns.
• l Converted existing DBF data intSQL Server using Data Transformation Services DTS , VBScript. Converted existing FoxPrjobs intVB.NET applications and SQL Server DTS, SSIS packages.
• l Fulfilled customer segmentation and analysis requests in a deadline driven environment.
• l Standardized file transfer format for submission toutside company for NCOA processing.
• l Utilized DATAFLUX application tperforming standardization, CASS certification, parsing, match coding data, and merge purge of data ETL tand from SQL Server.
• l Responsible for ensuring all Marketing data is process through DATAFLUX Data Quality processes.
• l Responsible for updating DATAFLUX Management Studiand DATAFLUX Server with mandatory patches and upgrades on development and production machines.
• l Maintained integrity controls and integrity of client's consumer information.
• l Led data migration tasks for migrating Liberty Mutual Marketing database from a local ta global platform. Created database crosswalk mapping tdocument data transformation for the source database tthe target database.

Confidential

Business Technical Analyst,

• l Provided Tier I VI technical support for 2200 Field Sales Force end users and 40 super users of any existing and new Mobile Sales applications how-tquestions and critical issues.
• l Facilitated and trained Help Desk and Super Users on the Mobile Sales application business rules and functionality. Created installation documentation, Help Desk scripts, and training material for each upgrade/enhancement. Create a CHM help file for the Mobile Sales application functional.
• l Responsible for various projects in life cycle phases, from gathering business requirements, writing specifications, and coding through deployment, testing, debugging, documentation, and maintenance.
• l Worked with business stakeholders, technical teams, and cross-functional units tidentify business needs and discuss solutions.
• l Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
• l Responsible for the designing and development of Mobile Sales applications, which receives data by synchronization from a SAP CRM Middleware client/server system.
• l Utilized Visual Studi6 and Visual Studi2005 tcreate Mobile Sales applications.
• l Utilized SQL Server tdevelop store procedures, triggers, views for reading and writing data tdata that will be synchronized tSAP CRM Middleware system consolidated database terabyte database .
• l Trained developers on how twrite better SQL Statement, how tuse more powerful features like table variables parameters , and how tavoid cursors. Trained developers on how twrite better queries toptimize their applications and become junior database administrators.
• l Managed and supported 2200 1 GB Microsoft SQL Server database issues on sales personnel laptops.
• l Managed a 2 terabyte SAP CRM Middleware CDB consolidated database .
• l Wrote T-SQL batch scripts tindex and tune SQL Server databases.
• l Rewrote and tuned long-running SQL queries tcut execution time, ease database load and improve scalability.
• l Responsible for restoring data on sales representative's laptop by syncing a full copy of the sales personnel data from SAP CRM Middleware consolidated database on tthe laptop.
• l Troubleshot and resolved bugs in .NET applications integrated tthe same SQL Server database utilized by Mobile Sales applications tensure optimal development and reporting environment.
• l Responsible for the development of complex Excel/VBA spreadsheets and Crystal Reports treport volume data and prices. Integrated the reports within the Mobile Sales applications.
• l Developed, troubleshot, and maintained the SQL Server databases, SAP CRM Middleware systems.
• l Responsible for the demonstrations, training end users, presentations and reports of the projects.
• l Utilized SMS, Microsoft MSI packages tdeploy all new applications and upgrades texisting applications.

Confidential

Associate Technical Analyst,

• l Developed, analyzed, and supported Direct Marketing System and Mass Mobilization System applications tgenerate consumer information which is given tgraphic vendors tcreate and send out direct mailing coupons and sweepstakes entry forms tloyal customers.
• l Utilized Mainframe OS/390, UNIX AIX, IBM DB2 database, and COBOL/JCL.
• l Responsible for performing as a DBA for IBM DB2 UNIX database in support of Direct Marketing and Mass Mobilization direct marketing and campaign analysis.
• l Created direct marketing mailings for various campaign audiences utilizing Mainframe and JCL.
• l Developed, analyzed, and supported Direct Marketing System and Mass Mobilization System applications tgenerate consumer information which is given tgraphic vendors tcreate and send out direct mailing coupons and sweepstakes entry forms tloyal customers.
• l Responsible for Merge-Purge instructions tour print service bureau including setup of Technical Specifications, NCOA and other list hygiene, Segment Merge Priorities, tests, post-merge splits, nths, and re-uses.
• l Handle of large datasets, table joins and suppressions in the millions in SQL SERVER SSIS and SAS. Utilize Mainframe OS/390 IBM DB2 Database, UNIX, and SAS for ETL flat file import, data manipulation, formatting, assigning, extracting.
• l Database and mail file processing using DMA Pander, CASS Certification, NCOA, SERP, Tele Match, Merge Purge de-duplication system .
• l Wrote applications tvalidate consumer addresses using GROUP1 Software Code1, List Code, and Geo. Code, and Merge Purge and tload legal cigarette tax information intthe mainframe systems.
• l Developed many legal compliance and government id reports for Corporate Affairs and Legal.
• l Created multiple statistical reports utilizing SAS programming for adult smoker's mass publication of loyalty coupons by demographic information and geographical locations. Created multiple statistical reports treport taxes for all states each quarter or each time law are approved traise taxes in various states.
• l Data modeling and created database using ERWIN.
• l Wrote SQL queries, cursors, triggers, stored procedures using QMF and T-SQL. Created views and tables for specific cigarette state tax and government id information for various locations, customer demographics, and for specific adult customers.
• l DBA grant the Senior Marketing Team access tspecific database views for report marketing statistical data on consumer purchases.
• l Utilized UNIX IBM DB2 and Mainframe IBM DB2 QMF tools tindex databases tenable faster data retrieval of data intBRIpivot reports. Create various UNIX scripts for database updates, indexing, and batch jobs.
• l Created complex joined SQL statements and store procedures used tprovide pivotal ad hoc reports
• l Utilized BRIQuery Reporting tools connectivity tthe UNIX IBM DB2 database for some customer demographics, government id, age verification tCorporate Affairs and Legal Teams.
• l Maintained system applications of the Direct Marketing and Mass Mobilization systems. Functioned as a DBA and SQL programmer of UNIX IBM DB2 Marketing databases. Downloaded/FTP data weekly from the Mainframe tbe inserted intthe UNIX IBM DB2 database.
• l Performed indexing and weekly backups of the database.
• l Facilitate super user training on BRIQuery Reporting tools.
• l Utilized SAS Base for OS/390 tperform campaign, coupon, and loyalty analysis. Develop histograms, PROC Freq, PROC PLOT, PROC STDEV, PROC Means reports tthe business clients.