SUMMARY:

• Solutions - focused, self-motivated leader with a comprehensive background in technology, specializing in the Publication, financial, Insurance and Security industries.
• Effective communicator and liaison, known for handling multiple tasks and meeting deadlines while maintaining high standards and client satisfaction.
• 16 years of experience in IT that involves gathering, analysis, design, development and testing Publishing, Banking, Gift Card, Insurance, Security and CRM systems.
• Highly versatile; quickly masters new roles, responsibilities, technologies and environments.
• Reputation for integrity, problem solving abilities, work ethic and analytical skills.

AREAS OF EXPERTISE INCLUDE:

• Relational, Dimensional Data Modeling SQL Server/Oracle Microsoft Office
• ODS (ACORD Model) Quality Control ETL, Staging Technologies
• Client / Server Architecture Reporting Security (PKI, SSL, OCSP)
• Technical Troubleshooting Enterprise Architecture Cross - Functional Team Leadership
• Agile Methodology Sharepoint Big Data (AWS)

TECHNICAL PROFICIENCIES:

Project Management/Flowcharting/Data Modeling: Microsoft Project, Visio, Erwin DM

ETL/BI Tools: SSIS 2012, SSIS/SSRS 2005, WSS 3.2, SharePoint 2010, Business Objects 4.0/XI, QlikView

Reporting Tools: Crystal Reports, Microsoft SQL Reporting Services

Databases - Database Tools: IBM DB2, Microsoft SQLServer 2000/ 2005/2008/2012 , Transact-SQL, Oracle 8i/9/10g, PL-SQL, TOAD, SAP HANA 1.0

Software: C, C++, Java, Java Script, HTML, PHP, Servlets, Perl, Dreamweaver, Flash, Visual Basic

Testing Tools: Test Director, Win runner

Operating Systems/Networks: Windows XP, Windows 7, UNIX, UNIX shell scripting

Version Control - Testing Tools: Microsoft TFS, PVCS Version Control Manager, SQA Suite Manager, SQA Suite

Hardware: HP UNIX Servers, Sun UNIX Servers, Windows 2003 Server

Web Servers: Apache Server 2.x., Tomcat 5.x/6.x

PROFESSIONAL EXPERIENCE:

Confidential

BI Architect

Responsibilities:

• Work closely with product owners to understand business analysis functions to be supported
• Lead and participate in design walkthroughs
• Develop Dashboards, Scorecards and Self Service Environments
• Develop Detail Reports utilizing Reporting Services reports against Analysis Services cubes
• Conduct code walkthroughs
• Develop SSIS ETL code
• Create standardize templates using python and transfer data from various sources using Data Pipeline via S3
• Create Views and generating reports in Tableau using Amazon RedShift.
• Conduct unit tests of ETL processes, cubes, and reports
• Follow established SQL Server standards for design, development and migrations
• Follow established standards for change management between Dev, QA/UAT, and Production environments and source code version control

Environment: SSIS/SSRS/SSAS 2008/2012, HRPyramid, Microsoft SharePoint 2010, SQL Server 2005/2008/2012 , Erwin, AS/400, MS Office Word/Excel, SQL Agent, ANSI SQL, Amazon RedShift, DynamoDB, EC2, S3, Source Tree, Jenkins, Agile

Confidential

BI Architect

Responsibilities:

• Research existing and new features of BI tools to develop implementation strategies to provide BI reporting and self-service BI to business users
• Provide functional Subject Matter Expertise in Business Intelligence platforms and other related Microsoft Technologies and leading complex scoping efforts involving these platforms
• Collaborate with business users and Enterprise Data Warehouse (EDW) team members to define the future strategy and direction for data warehousing, business intelligence, and analytic reporting for the enterprise (DW modeling)
• Develop business cases, proof of concept and ROI for department to get buy-in from senior management.
• Analyzing all information obtained during the requirements gathering phase to translate customer vision into a detailed functional and technical implementation plan
• Work with various stakeholders to:
• Define Information Architecture road maps
• Design Enterprise Data models
• Design Master Data Management strategy
• Work with Business Intelligence Team to design Enterprise Data Warehouse models
• Manage customer expectations regarding scope of items, timelines, and deliverables.
• Define physical architecture, server, and storage for DW
• Design and implement multi-dimensional models, including the construction of Data marts, Dimensions, Facts, Reports and Cubes while adhering to enforced development methodologies.
• Participation in internal and customer status calls and providing thought leadership and guidance for project delivery
• Data processing automation.

Environment: SSIS/SSRS/SSAS 2008/2012, HRPyramid, Microsoft SharePoint 2010, SQL Server 2005/2008/2012 , Erwin, AS/400, MS Office Word/Excel, SQL Agent, ANSI SQL

Confidential

Sr Application Developer - Tech Lead Business Intelligence

Responsibilities:

• Manage customer expectations regarding scope of items, timelines, and deliverables.
• Reviewed the existing landscape (Data, Technical and Infrastructure) Architecture and provided both long term and short term solutions using Microsoft technologies.
• Created Master system of record for product and customer entity by integrating data from multiple data sources using Microsoft MDM.
• Define requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool
• Integration of sharepoint with SQL Server Business Intelligence Platform
• Designed, developed and implemented enterprise operational data store (ACORD model) and enterprise data warehouse (DW modeling)
• Coordinate with onshore/offshore team members and partners and provided technical leadership and direction for the successful implementation of DW projects
• Develop Data Mapping and data handling behavior for integration of data from Source Systems.
• Designed, developed and implemented Change Data Capture (CDC) within the ETL environment. This ETL architecture was responsible in the loading of clean data into the redesign ODS Staging environment
• Reconcile discrepancies in current logical and physical data models, and collaborate with other team members to model additional entities and relationships
• Involved in efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master list for policy’s.
• Did enterprise wide upgrade to SSIS 2012 from SSIS 2005
• Designed and developed SSAS cube to support datamart design
• Involved in extracting data using MDX from cubes for end users
• Resolved issues and provided on-call support regarding production system
• Assisted users with acceptance testing and supervised system and unit test
• Facilitate communications between the business and IT support team for enhancements and change requests
• Strong SQL Skills and have create adhoc reports based on user needs
• Create stored procedures, views, triggers, indexes and partitions
• Automation of data processing

Environment: SSIS/SSRS/SSAS 2005/2008/2012 , Crystal Reports, BO Webi 3.x/4.0, Business Objects 4.0, Microsoft SharePoint 2010, SQL Server 2005/2008/2012 , IBM CDC 6.5 (Change Data Capture), AS/400, SAP HANA 1.0, MS Office Word/Excel, SQL Agent, Autosys, ANSI SQL, Microsoft MDS, Microsoft MDM, SDLC, Agile

Confidential

Programmer Analyst Lead

Responsibilities:

• Played a key role in the selection of new and innovative technologies in accordance with company goals and aligned with organizational objectives which involved Microsoft and other competitive BI products.
• Created Enterprise data warehouse from various application systems to provide a single truth of data to Customers
• Migrate SQL Server Reports to Crystal Reports
• Maintain computing environment by identifying Business Objects and Crystal Reports system requirements; installing upgrades; monitoring system performance.
• Utilize advance queues to process batch records with multiple instances
• Implement PL/SQL advance features like Advance Queuing, Bulk Collect and Autonomous transactions
• Spearheaded all aspects of the SDLC from project initiation through delivery.
• Support and fix reports, batch jobs in timely manner as and when issues arise and automate data processing jobs.
• Design and develop dimension and fact tables (DW Modeling)

Environment: SSIS/SSRS 2005, Crystal Reports, Business Objects XI, Windows SharePoint Services 3.0, SQL Server 2000/2005/2008 , Oracle 8i/9i/10g/11g, Java, JSP, PL/SQL, T-SQL, SQR, Perl, Visual Source Safe, Autosys, Unix, Solaris 5.8, MS Office Word/Excel, SQL Agent, Autosys, ANSI SQL

Analyst Quality Assurance

Confidential

Responsibilities:

• Designed test plans, test cases and test procedures for testing through Test Director.
• Involved in testing and automating the batch jobs, like executing the shell scripts, running the SQR reports and PERL programs to load and generate feeds.
• Create test cases and test procedures for various testing stages like Integration Testing, User acceptance Testing, Regression Testing and IVR Testing.
• Create SQL Statements to test data integrity.
• Perform data migration testing from old system to new system.
• Involved in entering defects into Mercury Quality center and verifying fixes to defects, working with other testers and developers.
• Involved in final QA testing and maintenance of bug logs and documentation.

Environment: Win Runner, Test Director, Oracle 8.i, HTML, JAVA, SQL Loader, PERL, Visual Source safe, SQR, Crystal Reports, Autosys, Win NT and UNIX, MS Office Word/Excel, SQL Agent, Autosys, ANSI SQL

Confidential

Project Lead/Developer

Responsibilities:

• Developed and integrated mapping concepts documents from source to target systems that includes data cleansing/data enrichment and transformation routines.
• Performed a diverse range of build vs. buy analysis for the data model.
• Planned, designed and developed manual, automated test scripts to meet the business requirements of the different modules
• Wrote and performed User Acceptance Testing (UAT).
• Involved in preparing Xls test data for testing Billing system
• Reviewed Product Requirements Documents (*PRDs*) to determine coding requirements and worked with the appropriate business groups to ensure all issues relating to technical implementation are understood prior to proceeding to the design phase
• Developed Technical Requirements Documents (*TRDs*) and SDDs and ensured their delivery with proper requirements traceability matrix, use cases, and sequence diagrams prior to code development
• Coded complex/reusable stored procedures using SQL/PL-SQL for use in reports as well as web-based intranet applications.
• Data processing Automation in Windows

Environment: Citrix Terminal Software, Solaris, AIX, C, C++, SQL, TOAD 8, Perl, Shell scripts, ANSI SQL, MS Office Word/Excel, Autosys, SQL Agent

Confidential

Associate Engineer E-Security

Responsibilities:

• Responsible for the study and implementation for Snorkel administration module
• Involved in implementation of Snorkel server at SHCIL (Stock Holding Corporation of India Ltd) and HDFC bank
• Low level design of the system
• Wrote daemon concurrent server
• Wrote HTTP and HTML parsers
• Enhanced functionality of SSL library
• Wrote the session management component for the administration module
• Developed and deployment in Linux and Solaris
• Involved in preparing test plan and test cases based on the functional requirements and the business rules

Environment: Linux Red Hat, Solaris, C, C++, SQL Server, Shell Scripts, Perl, Win Runner, Windows 98, VC++, Apache, PHP, Java scripts, Dream Weaver, MS Office Word/Excel, Autosys, ANSI SQL