SUMMARY:

• Strong analytical, problem solving, collaboration and technical skills with demonstrated experience delivering world - class, enterprise BI solutions using Microsoft SQL 2008R2/2012, Microsoft BI stack.
• Experienced with SSRS in Creating reports using MDX and Analysis Services as a data source, Passing Parameters (MDX and regular) to drill down reports, Working with Charts/Gages (Multi Column datasets), Deploying Reports, and Administering Security
• Testing Software by planning and executing functional tests. (Test Plan Documentation-Review-Update-Baseline-Testing Techniques)
• Ability to manage, adjust and negotiate a schedule throughout a project, ensuring delivery goals and quality goals are simultaneously achieved.
• Strong knowledge of Data Warehousing concepts and Dimensional Modeling.

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NYC

Business Intelligence Developer

Responsibilities:

• Strong analytical, problem solving, collaboration and technical skills with demonstrated experience delivering world-class, enterprise BI solutions using Microsoft SQL 2008R2, SQL 2012, Microsoft BI stack, iDashboard.
• Strong knowledge of Data Warehousing concepts and Dimensional Modeling.
• Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions and Semi-Additive measures
• Possess solid knowledge of writing, tuning and optimizing Confidential -SQL queries and SSIS Package.
• Experienced with SSRS in Creating reports using MDX and Analysis Services as a data source, Passing Parameters (MDX and regular) to drill down reports, Working with Charts/Gages (Multi Column datasets), Deploying Reports, and Administering Security.

BI Developer

Confidential, Newark, DE

Responsibilities:

• Participate in Business Intelligence solutions development according to business and technical requirements Develops, tests, documents, and implements SSRS and SSAS solutions based on design documentation provided by BI department Works within established development guidelines, standards, methodologies, and conventions
• Experienced in report and cube development with SSRS and SSAS using Business Intelligence Development Studio (BIDS) or Report Builder 3.0 against SQL Server Analysis Services or relational databases Proficient with Multi-Dimensional Expression (MDX) and SQL query .
• Experienced in with SQL Server 2005/2008 including client tools such as Microsoft's SQL Server Management Studio, using Microsoft SharePoint 2007/2010 and its Business Intelligence's components, in particular, deployment and hosting of SSRS reports.
• Knowledge of fundamental concepts and practices of Business Intelligence, OLAP, data warehouse design based on Ralph Kimball's architecture, and multidimensional and relational reporting and analysis .
• Designing and implementing data warehouse ETL using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views)
• Good understanding of data warehousing concepts (e.g., ETL, MDM, OLAP, MOLAP, ODS, metadata management, data marts, star schema, operational vs. analytical reporting, relational vs. dimensional modeling).
• Developed detail and summary reports, line and pie charts, trend analysis reports, sub-reports, and MDX queries according to business requirements using SSRS.

Confidential

Business Intelligence Master’s Program

Responsibilities:

• Implemented a Labor Analysis Business Intelligence solution for a national construction company.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2008 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role .
• Created score cards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a construction company extracting data from SQL Server 2008 OLAP data source and deployed to SharePoint sites. The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.
• Key product areas utilized also include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.
• Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions. Possess solid knowledge of writing, tuning and optimizing Confidential -SQL queries.
• Create and maintain documentation of processes, reports, applications, and procedures as per department policy.
• Support interfaces with users and third party vendors.
• Support the design, planning, implementation, administration and maintenance of the business intelligence platform.

QA Analyst

Confidential, Middletown, NJ

Responsibilities:

• Use SQL Script in a SQLPLUS utility to test data validation. Designed SQL Query using Join to perform Transaction Testing.
• Tracked Defects with Severity, resolved defects and change status in Quality Center 9.0.
• Interface with System Eng. And Dev. to obtain specific Testing Requirements and document Test Plans (Purpose, assumption, Hardware/Software Needs, Test Case, Entrance/Exit Criteria) detailing exposures, risks, and dates in accordance with testing methodologies.
• Testing Service Inventory EDB interface, which is the middleware that would provide a unified layer for accessing the existing iGEMS asset database and other subsystem of Confidential & Confidential business service.
• Perform System Testing in Circuit manager service and Facility manager service data through CORBA service interface between client and NCD. (Network Core Data), which is in Teradata.
• Participate in creation of QA Traceability Matrix by contributing daily project status, estimated Test execution competition.
• Automated testing using data Tables and loading dynamic Data Tables (preferably Excel) in QTP, managed object repository and shared object repository, dynamic data with parameters and passing that to functions and Reusable Actions frames (WEB), to utilize data driven and/or keyword driven framework.
• Developed UNIX script to automate process in back end testing and use UNIX utilities extensively.

Sr.QA Software Tester

Confidential, Horsham, PA

Responsibilities:

• Testing Web application with an integrated platform between BISYS products and other retirement solutions for both internal BISYS partners as well as external customers and partners in an SOA (Service Oriented Architecture) environment.
• Designing, developing and implementing complex test automation both Confidential the functional and system level.
• Work closely with the manual and automated QA teams to understand test cases that need to be automated, including convert regression test plans to automated test scripts, maintaining the scripts over time, and documenting the test results in QTP 9.1
• Successfully interacts and works with the end users, and vendors to determine testing milestones, while
• Interface with customers to obtain specific Testing Requirements and document Test Plans (Purpose, assumption, Hardware/Software Needs, Test Case, and Entrance/Exit Criteria) detailing exposures, risks, and dates in accordance with testing methodologies.
• Work with the customers and Project team to reconfigure equipment to meet all testing specifications.
• Document test results and obtain QA sign off where required with review of Test Results, defect Reports and Regression Test lists.
• Schedule and coordinate functional, compatibility, stress and/or regression tests.
• Maintain accurate and up to date project status by release by release.

Software Tester

Confidential, Manalapan, NJ

Responsibilities:

• Develop and maintain test plans, Test Cases, Test Data, Test scenarios, and other test documentation like User Guide, Local Procedure with release by release.
• Performed functional, system, integration, and performance testing in accordance with company standards and processes across diverse platforms.
• Participate in creation of QA Traceability Matrix by contributing daily project status, estimated Test execution competition.
• Work closely with both the business (User/Marketing/Analyst) and development teams to resolve issues like Requirement Gap, Design Documents, System Demo, Defect Resolution, etc.
• Manage test cycles around defects and test cases in Test Director with severity of defects.
• Ensure compliance with configuration management and change control procedures.
• Developed SQL script to validate Front End Testing (GUI defect resolutions across the various processing components/applications.) with use of SQL join, Oracle function, mathematical function and updated based on release requirements.
• Developed UNIX shell script to automate process in back end testing and use UNIX utilities extensively.

QA Tester

Confidential, Somerset, NJ

Responsibilities:

• Preparation and execution of software Test plans and Test Cases. Reviewed test Plan in cross-functional Team (Requirement Team, Design Team, Installation Team, Database Administration Team) and updated Test Plan with comment from stack holders and baseline Documents.
• Execute Test Cases using Testing Methodology like Positive, Negative, Stress Testing, Object Testing, Error Testing, etc.
• Tracked all MR with Severity and assigned to Developers and retested MR after rebuilt.
• Focuses on eliminating and documenting Defects as early in the systems’ development life cycle as possible.
• Back End Testing involved, Testing of Data file created based on requirement includes file detailer testing
• Participate in software release planning, estimating needed tests, identifying needed test configurations, and estimating the overall software validation scheduled for minor software releases.
• Involved in Regression Testing in each release by updating test Plan with Feature functionality.
• Tested User Guide as an External Technical Document.
• Ability to manage, adjust and negotiate a schedule throughout a project, ensuring delivery goals and quality goals are simultaneously achieved.