SUMMARY

• Eight - plus years of experience in solution development, testing and debugging, supporting application and implementation as software and application developer and analyst.
• Experienced with application life cycle support - provide wide range support to enhance and develop application solutions, plan, test, and implement and migration of upgraded and new solutions, assist end-users on new implementations, create and manage BRDs
• Experienced with multiple database management application system - SQL Server, Oracle, Teradata, MySQL, Sybase, and Toad
• Experienced in developing BI application including data analytics and reporting - Qlikview, SSRS, SSAS, SAS, and Tableau
• Experienced in analyzing requirements, coding and scripting, testing, and debugging with Object Oriented Programming Languages - C#, C++, Java, Visual Basic, Python
• Experienced with application development platform and source control system - Visual Studio, VSTS and TFS, Qlikview Desktop and Server Application System, Nprinting Client and Administrative Application System, MS Business Intelligence Development Studio, and Oracle Developer Suite
• Experienced with ETL development with SSIS - Design and develop data transfer packages with SSIS, develop and integrate business data model with ETL packages, configure and control ETL tasks programmatically, and administer ETL tasks with SSIS
• Develop and manage visual/analytical report with QlikView - develop script, enhance functionality with macro and Set Analysis, develop and implement STAR and Snowflake Schema based data model, test data integrity and develop reports with furnished data model, and administer reports, access, and configuration on Qlikview Management Console comprising Access Point, IIS, and Windows System and Service configuration on WMS platform
• Experienced developing data analytics process and SSAS - develop datamart to create model for analytical cubes, manipulate cubes with MDX, shape data into dimensions per business requirements, transform data into STAR and Snowflake model, develop cube model - MOLAP, ROLAP, HOLAP, apply model for visual and analytical reports - dashboard, Ad hoc report
• Design and develop report with SSRS - manipulate data warehouse data, datamart cubes, import data from Sharepoint and BizTalk, format data per requirements, develop variables and parameters, integrate Stored Procedures, develop and apply expressions, develop and format user interface for dashboard and front end implementation, publish and administer report with Report Management Console
• Proficient to analyze data using complex SQL queries to manipulate data and generate custom reports from large databases and data warehouses, enhance data services by creating Indexes, Stored Procedure, Triggers, and Views
• Experience developing visual data analytic with Tableau and SAS - develop and maintain dashboard reports, report parameters, and resources integrated with underlying database systems of SQL Server and Teradata.
• Have experience with web service application interfaces compatible to RESTful API, WCF, and SOAP
• Experience developing multiple repository access and configuration within data driven architecture including .Net framework, C#, ADO.Net, SQL Server, ASP.Net, WPF
• Experienced with system scripting with UNIX, KORN Shell, Power Shell, Windows Batch, and MSDOS
• Experience developing and testing client API configured within J2EE, MySQL, PHP, XML, SOAP, UDDI, WSDL and data mapping over RESTful API
• Proficient on strong analytical skills to debug and resolve systems issues on production environment
• Experienced with developing and testing to maintain SDLC and implement manage quality of application with best practices of industry standard - develop test plan, create, update, and assist with BRD and technical documentation, interact with automation test framework - Test Complete, Quality Center, QTP (Mercury QTP - ALM suite)
• Experienced with creating, implementing, and maintaining test cases with various strategies including functional, stress, sanity, integration, security, and usability tests based on UAT, Visual, White box, and Black box test concepts
• Experienced with test methodologies including Agile, Waterfall, and RAD.
• Excellent in demonstrating competencies on communications, perform system analysis, problem solving, business acumen, creative and innovative thinking, high integrity, team player, collaborative and accountable
• Experience providing technical assistance to large and critical enterprise and n-tier systems with 24x7 revenue generating operations

TECHNICAL SKILLS

Software & Office Utilities: MS Excel, Word, PowerPoint, JIRA, QC, SP

Operating Systems: Windows Server 2003/2008, Windows XP/7, UNIX/Linux

RDBMS: SQL Server 2005/2008/ 2012, Oracle 9i/10g/11g, MySQL 5, Sybase ASE 11

Middleware/Data Services: XML, SOAP, Web services, ADO.Net, WCF, LINQ, HTML, JSP

Development/Programming: Transact-SQL, PL/SQL, C#, C++, Java, Visual Studio 2005, 2008, 2012, VBA, Power Shell, Korn Shell, DOS, Java, SSIS 2005/2008/2012, SSRS 2008/2012, Tableau 7.0, Crystal Reports 10.2/10.5/13, Talend 5.1, Informatica, TOAD, Rapid SQL 6.5/7.2, Oracle SQL Developer, SQL Server Management Studio, SQL Anywhere, MySQL, MS Visio, MS Excel, SQL Server Business Intelligence Development Studio, JIRA, Quality Center, SOAP UI, Excel 2003/2007/2010, MS Access 2003/2007/2010, SAS 9, Microsoft BizTalk Server 2003, 2010, SharePoint Server 2007, Microsoft Host Integration Server, .Net Framework 3.0/3.5/4.0, J2EE, MVC, WPF, Selenium, Eclipse, Qlikview Desktop Edition 11.2-plus, Qlikview Server Edition, Nprinting

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

Senior SQL/QlikView/SSRS Developer

Responsibilities:

• Develop chain of ad hoc reports and dashboard - develop solution for ad hoc reports based on SSRS and dashboard for Qlikview.
• Extract data from multiple resources with SSIS, transform and load data into small data mart - develop data model and populate data mart for ad hoc and analytical reports.
• Create View, Procedures, Trigger - develop database objects to automate data manipulation process to load data into Views and data mart.
• Create Qlikview resources for POC dashboard for end-client presentation – build data model for dashboard, QVD extract, transform data into report model, develop dashboard interfaces, in corporate report data into dashboard.
• Create ad hoc deliverable reports with SSRS – in corporate data mart data into reporting interface, create custom solution for end user to export report output.
• Collaborate with end user – provide demo and analyze solution process with mocking model, interact with business analysts, project manager, and business owners.
• Create and maintain documentation – denote all steps of development for future usage, share demonstrate business analyst of solution usability.

Confidential, Rochelle Park, NJ

Senior QlikView Developer

Responsibilities:

• Develop and maintain full application life cycle – create and manage BRDs, enhance existing data model, develop new data model for newer client solution, plan, test, and integrate new and existing solutions to production servers, provide installation and migrations support for major company-wide system implementation, assist end-users with UAT and validation, support wide range application support.
• Develop data extract procedure and integrate into QlikView system from various data sources including SQL Server.
• Test and validate data source files from mainframe.
• Update and enhance existing QlikView documents based on user requirements – implement change for front end and backend.
• Develop business objects in SQL Server database to integrate for enhanced functionalities – batch process, scheduling, and workflow management.
• Migrate historical reports to current model.
• Develop dimensions and measures with QlikView scripts.
• Create and deploy XML triggers, report generation, and distribution with QMC and NPrinting.
• Analyze existing data sources and develop data processing model for extracting and loading data into data mart using SSIS, SharePoint, SQL Server, SalesForce, WebFocus, FTP to integrate data for reporting purposes.
• Develop and deploy custom dashboard using Qlikview designer.
• Develop STAR/SNOWFLAKE model – design extract to manipulate data from data warehouse into QVD (Qlikview extract files), perform visual validation using Qlikview E-R diagram, and manage data model for dashboard
• Develop multiple Qlikview reports with QVWs for retail reporting system – write script, control data flow, design user interface, test and validate reports against KPIs, dashboard template with various graphical features including gauge, bar charts, pivot models, and interchanging models
• Deploy and manage Qlikview reports with Qlikview Server tools – configure and manage Qlikview Management Console, configure Qlikview Access Point, and schedule tasks
• Develop automation task to deliver Qlikview reports with NPrinting – create batch tasks, create and configure report parameters, test, and deploy reports for email transfer to group users and publishing reports to Qlikview Access Point location.
• Maintain report services and functionalities with macro.
• Developed logical and physical data models with ERWIN to integrated model to preface design.
• Troubleshoot report delivery process and correction of process to manage deployment on time.
• Administer IIS for QMC and QAP integrated issues with end user objects.
• Administer SSIS packages integrated with Qlikview solutions.
• Integrate Qlikview based new tools and solutions – Qlikmap, QV script generator, Q-Eye, and MS Office products.
• Administer and manage dashboards and reports with QMC, customize governance dashboard, extensions, and generate system reporter to monitor user interaction and enhance performance.
• Enhance and manage ETL package used for data feed to QlikView system – use SSIS to build, manage, and administer ETL packages.
• Perform data validation and resolve data related issues including missing data, analyze data synchronization per requirements for business reports
• Develop complex queries for scripting, triggers, functions, procedures, and views used from data sources including SQL Server.
• Troubleshoot and resolve data related issues and failures from ETL jobs – develop procedure, documentation, test, and validate.
• Maintain control version for business rules and control information updates.
• Manage and response to on-call support, hold important roles and responsibilities.

Confidential, Dearborn, MI

Report Analyst/Developer

Responsibilities:

• Analyze existing data sources and develop data processing model for extracting and loading data into data mart using SSIS, SharePoint, SQL Server, SalesForce, WebFocus, FTP to integrate data for reporting purposes.
• Developed logical and physical data models with ERWIN to integrated model to preface design.
• Developed Stored Procedure, Views, UDFs, and enhanced existing T-SQL scripts to integrate within ETL packages for optimized functionalities.
• Extensively used T-SQL for query enhancements for Join, create Sub-queries to satisfy new requirements for daily and ad hoc reports.
• Created Triggers for performance optimization.
• Scheduled automated jobs for ETL automation, created alerts to manage failure and provide real-time solution.
• Created SSIS packages to extract, transform, and load data into data warehouses using various flow tasks – scripting, SQL task, Bulk Insert Task, File System, XML, and automated messaging with Send Mail task
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Designed and developed custom interfaces for reporting based on WPF protocols, analyzed, suggested, and updated requirements for better performance.
• Created various reports – Listing, Tabular, Matrix, and custom reports for presentation by integrating to PowerPoint.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Design, develop and test Report Layout with Report Designer on SSRS, enhance report designer with custom build form, custom object library, and, create and develop custom template.
• Develop custom business object and integrate with Report Viewer on SSRS for business analytical report.
• Developed integration and configuration solution for SharePoint integration.
• Administered SharePoint profiling to manage metadata,
• Implemented document sets on SharePoint to manage content types, and process conversion from PDF to InfoPath Forms Library.
• Developed and configured MVC based graphical user interface for dashboard and interactive report for Business Plan Review
• Created Business Logic Layer & Data Access Layers to implement the MVC architecture.
• Implemented Routing, URl, Security, Action Filter techniques for application development.

Confidential, Secaucus, NJ

Senior Technical Analyst/Programmer

Responsibilities:

• Research, analyze, debug, and monitor healthcare related claims on web and desktop clients including SharePoint, ASP.Net, WCF, WPF, SQL Server, Sybase, Web HTTP services, FTP for multiple services related to data integration, messaging, and client API.
• Design, create, and update data model per business requirements, implement new model into business system and data services including front office, ETL, and reports, develop and enhance system codes.
• Provide data services on various issues including integration services, payroll segment, reporting services.
• Provide development support for application life cycle – implement new and enhanced solutions, test and validations, provide support for installation and migration, design and implement new data models and enhance existing models, update and manage BRDs.
• Develop, test, and implement data integration process using SSIS to migrate and integrate data for data warehousing and reporting purposes – develop and implement wide range parameter for optimized and on-going data integration process, develop, test, and implement DTSX and upgrade DTS packages for data integration enhancement support, develop custom solutions and implement to MS .NET Framework for enhancing performance.
• Develop, test, and implement reporting solutions with SSRS – develop Stored Procedures and Views, integration of database programmable objects to reporting functionality, design user interface for front end and dashboard collaboration, develop and implement master dashboards, develop and implement solutions for ad hoc report deliverables.
• Generate various reports including W2, Healthcare Census data, Eligibility reports, Audit reports, and healthcare notification reports with pivot, dashboard, and list-view formats using SSRS reporting services.
• Developed, tested, and debugged QlikView applications report for POC system – create master dashboard, deploy, and manage reports.
• Develop STAR/SNOWFLAKE model – design extract to manipulate data from data warehouse into QVD (Qlikview extract files), perform visual validation using Qlikview E-R diagram, and manage data model for dashboard
• Develop multiple Qlikview reports with QVWs for POC reporting system – write script, control data flow, design user interface, test and validate reports against KPIs, dashboard template with various graphical features including gauge, bar charts, pivot models, and interchanging models
• Deploy and manage Qlikview reports with Qlikview Server tools – configure and manage Qlikview Management Console, configure Qlikview Access Point, and schedule tasks
• Develop automation task to deliver Qlikview reports with NPrinting – create batch tasks, create and configure report parameters, test, and deploy reports for email transfer to group users and publishing reports to Qlikview Access Point location.
• Developed and supported MS suite based application support - Manipulate C#, and VB codes for enhancements, develop WCF based interface to call multiple reference data used for reporting and integrating with HTML, XML, and SOAP protocols, develop, test, and implement custom reporting interfaces based on ASP.Net technology and integrating web services including SOAP, XML, WCF, and WPF, develop and implement MVC based front end and back end APIs to support WPF forms, WCF reference calls, ASP.Net based views.
• Develop and support business solutions including EDI processing system – created schema for integrating data into BizTalk server for EDI data processing, developed and implemented data adapters for multiples client interface to transmit data from end-to-end for reporting purposes from raw EDI data to data transmission with end clients – PeopleSoft, Siebel, SAP, Oracle E-BusnessSuite, MS Dynamics CRM modules based CRM apps, developed, tested interface for functional enhancements with SSIS and BizTalk server, perform EDI data processing tasks based on HIPAA supported protocol.
• Provide application support on Healthcare business solutions – create and validate manual test scripts for UAT and functional testing for production move, web-communication, data migration, and reporting segments, end-to-end support for Annual Enrollment implementation for new rules and logics, monitor communication process, follow up with client-based claims, and, provide reporting supports including ad hoc reports
• Perform report implementation with developing and testing dashboards with SSRS, developing guide-plans and strategic documentation, maintain report parameters and business objects, administer real-time support and control report runs with SQL Server DBMS system.
• Develop and maintain complex scripts to test and validate complex business rules, implement to production environment, and provide ongoing support.
• Develop complex queries and Stored Procedures to support batch process for multiple client requests based functionalities.

Confidential, Boston, MA

Software Automation Engineer/Programmer

Responsibilities:

• Manipulate Java, C#, and VB codes for enhancements.
• Configured SharePoint 2010 Farm for development environment.
• Created web application, site collections & subsites.
• Implemented SharePoint Search based on metadata based on content type, document location; and tested FAST Search in test environment.
• Create automation test scripts to test web services for functional testing, verify application interfaces, and debug application faults.
• Administer bug fixing, resolution criteria, provide feedback to all-levels of escalations
• Research and analyze issues per BRDs and system Calc integration process, and, document for training purposes.
• Administer and manage processing workflow – audit application process, setup and manage system configuration, test and implement automation solution, and provide assistance with deploy application.
• Perform weekly and monthly maintenance – backup and restore database objects, query tuning, optimize performance.
• Create database performance report – develop and manage application performance report, perform audits, and updates as required.
• Develop and implement MVC based front end and back end APIs to support WPF forms, WCF reference calls, ASP.Net based views.
• Develop and implement MVC on JSP API/View, mapping criteria and implementation, MySQL back end, parameter client call action, and JSP form support.
• Extracting, transforming and loading data from multiple sources into QlikView applications.
• Developing, testing, and debugging QlikView applications.
• Create nPrinting processes for report distribution.
• Configured and published reports using QlikView publisher job.
• Developed data object modules, mapped data, tested and validated Dashboard report with Tableau.
• Enhanced existing dashboard reports, updated and recoded report modules using Tableau developer interface.
• Developed, tested, and integrated MDI interfaces with Custom Control Libraries and Class Libraries.
• Installed and configured SQL Server 2008 R2 for Integration and Reporting Services.
• Enhanced test framework to test and implement .Net Framework related protocols integrated with single-wave web service application.
• Perform automation testing on web application, web services, security verification and validation, and CRM objects.
• Create and validate data integration services for BizTalk CRM process.
• Develop, test, and deploy ETL solutions – develop data model, transform data per data model, develop data warehouse and manage data objects.
• Create call reference API for multiple business objects to integrate with SOAP API, ASP.Net view
• Create complex queries and Stored Procedure to tune up data, testing data services for sanity testing.
• Implement new model into business system and data services including front office, ETL, and reports, develop and enhance system codes.
• Continual performance of research and development for production support.

Confidential, Uniondale, NY

Systems Analyst

Responsibilities:

• Identify, design, and prototype potential solutions for projects and enhancements in the discovery phase with continuous improvement items, and technical perspectives.
• Perform implementation of solutions and create documentation for traceability matrix.
• Developed and managed dynamic ASP.NET web application to shadow prototypes for client reporting interfaces for various clients.
• Installed and configured SQL Server 2008 for data services integration purposes.
• Installed and configured SharePoint Server 2010 in virtual development and staging environment.
• Manage and enhance ETL package for Infomatica tasks for development maintenance and troubleshooting for escalated issues.
• Performed Full and Differential backups of content database, and pre-upgrade checks; installed all upgrade pre-requisites.
• Gather requirements for new data model, review and provide solution to implementation for synchronizing model into business architecture for risk analysis and future trading system.
• Develop and test financial analytical reports on multiple clients with QlikView and SSRS for various clients.
• Create business objects and develop modules, business reference to map data set for QlikView Dashboard reports.
• Design reports forms, create business objects, develop attributes to map objects for high-end analytical report using SSRS applied for business expo.
• Implement new data model into business system and data services including front office, ETL, and reports, develop and enhance system codes.
• Configure code-suite environment, develop, test, and debug functional codes for different release.
• Developed custom control objects and implemented with application applied for business and trade interfaces.
• Developed, tested, and implemented report forms with custom elements using WPF.
• Create and perform data services testing with SQL Server Integration System, SharePoint services.
• Provide assistance to BRM (Business Relationship Management) in all run management activities including monitoring activities, ensuring issues are being properly addressed and solved, processes are correctly followed in tracking incidents to problems, addressing and expediting the handling of inter engine issues, and ensure the proper handling of Critical Situation events and calls.
• Support BRMs and Tech Leads to offload detailed work related to relationship management, technical solutions of early projects, initiatives, maintenance and run.
• Perform functional and UAT testing – black box or code test, Unit test, create test plan and test cases, create bug reports, manage fix and solutions in SDLC.
• Create test prototypes to test existing application for .NET interoperability including SQL Server, Microsoft BizTalk Server, internal code modification with C# and VB, Microsoft Host Integration Server, Microsoft Windows Server, Microsoft .Net Framework, and WPF.
• Provide assessments to the off shore maintenance teams on correctness and impact of design/implementation based on information produced by maintenance team.
• Perform application support – response to escalated service request, investigation on complex issues by thorough inspection of code, provide assistance with code merge and release plans by conducting code reviews.
• Perform team support - providing guidance on intra and inter systemfunctionalities and lead resources as required, provide problem and solution input based on technical analysis and feasibility.

Confidential, Cedarhurst, NY

Programmer Analyst

Responsibilities:

• Develop and establish quality assurance measures and testing standards for new applications, products, and/or enhancements to existing applications throughout their development/product lifecycles.
• Analyze documentation and technical specifications of any new application under deployment or consideration to determine its intended functionality.
• Create and execute test plans, test cases and test scenarios that will determine optimal application performance according to specifications.
• Implement new model into business system and data services including front office, ETL, and reports, develop and enhance system codes.
• Create test cases for stress testing, load testing, and regression testing of applications as required.
• Perform documentation on trading operational functionalities, scope changes, and implementation.
• Perform test on data acquisition with multiple data sources, ETL packages, and FTP and data warehousing processes.
• Configure code-suite environment, develop, test, and debug functional codes for different release.
• Manipulate Java, C#, and VB codes for enhancements.
• Perform failure analysis, create and log defects, and track defects.
• Create data integration packages on Microsoft BizTalk, tested and validated packages against multiple platform including SQL Server, Oracle, and DB2.
• Consequently communicate with developer on resolution and improvements
• Ensure that testing activities allow applications to meet business requirements and systems goals, fulfill end-user requirements, and identify existing or potential issues.
• Identify/work with development on the creation of test data needed for execution.
• Communicate test progress, test results, and other relevant information to project stakeholders and management.
• Conduct test case reviews to ensure scenarios accurately capture business functionality, utilize Quality Center for Test Case Creation, Test execution and to record, report and track defects.

Confidential, Flushing, NY

System Engineer

Responsibilities:

• Worked directly with Quality Assurance, Product Management, Marketing, Sales, Professional Services to develop use cases and task plans for system development and implementation.
• Designed the Data Model for the project to determine what data objects such as tables, stored procedures and Jobs were required in order to store the GPS data in the database.
• Used DTS to export and import necessary data amongst the databases.
• Developed User Interface using ASP.NET, C#.NET, and CSS.
• Created and implemented data objects, wrote complex SQL queries to retrieve and process the dynamic data through web clients.
• Installed and configured SQL Server 2005 database.
• Setup and configured database connection, maintained performance, create performance plan, backup and restore database and application objects.
• Configured SSIS data integration framework for resource data manipulation on transactional data (OLTP) for daily reports.
• Develop interface to integrate existing dataset as dump for historical reports.
• Designing and testing reports using Crystal Reports 9.0 used for daily reporting purposes.
• Transforming HTML reports into Crystal Reports and Classic ASP page into ASP.NET page.
• Develop and implement UAT test phases for multiple end-users functionalities.
• Migrate existing objects to .NET 2005 technology.
• Testing and deploying the Web Service as well as the MMTS application.