SUMMARY:

• Hands on BI Technical Architect with more than 12 years of innovation in the software and hardware development arena including 10 years experience leading business and technology strategy, directing, team leadership and mentoring. Architect and builder of solutions, skilled at innovating new business models and applying technological solutions in cost effective and timely manner. Intimate understanding of small and startup businesses and how to maximize effectiveness of teams and budget.
• Service Oriented Architecture - Expertise in the total application lifecycle management (ALM) perspective including technical understanding of relationships, dependences and requirements of hardware and software components, best practices, standards, and governance for complex integrated service oriented architectures (SOA). Experience utilizing BizTalk, Webmethods, Gentran, Altova, Cloverleaf, Iona, HP SOA, Big Data, Mule, Azure Service Bus and EAI toolsets.
• Project Management - Proven ability to lead project teams to deliver multiple, simultaneous projects that span across several business or technology areas. Effectively manages resources, schedule and quality of deliverables through the full project life cycle (discovery, analysis, design, construction, test and implementation).
• Development - A technically proficient proven team player/builder with an extensive technical skill set. Diverse experience developing collaborative solutions with internal teams, vendors, and outsourcers -- building enterprise-level solutions for Fortune 100, global commercial and Manufacturing clients. Recent successes include the use of Agile/SCRUM methodologies in a dispersed development environment, implementation of application lifecycle management (ALM) processes and the deployment of automated build solutions/processes in a global team development environment.
• Brings strong technical and multiple domain knowledge as well as consultation background to successfully drive software development, integration, infrastructure, architecture, and operations
• Master of Science Integrated with specialization in Software Science.
• Working as Project Leader in Agile project development team at MphasiS - an HP company providing IT Solutions across various domains.
• Involved in Gap Analysis, AS-IS studies and Business Requirement Gathering and has interfaced with business and technology teams for Projects and “Proof of Concepts”.
• Involved in SIT and UAT followed by implementation of Defects/CRs during production support.
• Expertise in Agile scrum development model.
• Received Best Performance of the year 2012 from client - Confidential .
• Received Best Project of the Year 2012 from Mphasis(Rewards &Recognition) .
• Received n for outstanding performance in handling a project - Insurance( Confidential ), BFSI.
• Received several informal appreciation mails from clients and management - Confidential, Confidential .
• Received spot several times from MphasiS an HP.
• Appreciated by AMGEN for overcoming significant challenges and delivering a project in a commendable manner.
• Excellent decision-making and problem solving skills developed while meeting the challenge of constantly fluctuating environments.

TECHNICAL SKILLS:

Technology and Tools: Data Stage, Cognos, and Informatica - Administrator, Developer on UNIX and LINUX Qlikview, Hadoop, Tableau - Technical Architect, Developer - Strategy, Analysis Linux SUSE, SUN SOLARIS, HP UNIX, WINDOWS SSH Tectia, SFTP, Putty, WINSCP, VMWare, VMM IT service Management, Citrix, IQMAX, Share point drive, Borland Star team, ECM, Golden driveTechnical Architect, Technical Project Manager - Qlikview, Data Stage, Cognos, Oracle and PL/SQL - Manufacturing, Insurance and BFSI

PROFESSIONAL EXPERIENCE:

Confidential

BI Technical Architect

Responsibilities:

• Gathering requirements from the client to offer a proper solution by understanding the total business logic
• Built strong relationships with clients and partnerships with team members.
• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.
• Created database layer by defining appropriate relationship between query subjects and Logical layer, DMR layer and business layer in Framework Manager.
• Created oracle packages and imported into Framework Manager as a stored procedure query subjects with multiple parameters.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed various Complex report types ranging from simple Lists, Cross-tabs, Charts by using different Functionalities like drill-through, Master-detail, conditional formatting, Multiple Prompts, Cascading Prompts, Conditional blocks Filters, multi-page, multi-query reports, Multi-tab reports using Java scripts, Dashboards, Drill up/Drill down, Report Bursting.
• Deployed Reports, Packages Folders and Cubes from DEV to UAT and from UAT to PROD Environments and Tested and Validated Reports for different test cases
• Involved in the integrating Cognos reports to Client website using Java Application.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection
• Good Experience with Customized Reports using HTML and JAVA SCRIPTS.
• Designed models by mapping business needs using Transformer and created multi-dimensional cubes, cube groups, Power Play reports..
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Expertise in Oracle 9i/10g/11g and in writing PL/SQL stored procedures, functions, packages triggers and materialized views using PL/SQL developer.

Confidential

BI Technical Solution Architect

Responsibilities:

• Confidential PC Administration will generate a report out of the IdM system every 2 weeks listing employees who transferred out of an Confidential PC US Co\Br\Dept code (CBD). Note - this includes transfers within shell code where only the CBD changes, as well as transfers from one Confidential PC US unit to another.
• The report will be sent by Confidential PC Administration to the operational owner or designated contact of the shell code that has the CBD in which the employee is transferring from
• To build the centralized Work Data Store(WDS), Enterprise Data Ware (EDW) house system using ETL, BI reporting, Data Mart, Cubes and web services. As a Architect, I am involved in the following activities in the project:
• Total application lifecycle management (ALM) perspective including technical understanding of relationships, Involved in-bound and out-bound dependences and requirements of hardware and software components
• Gathered system requirements and specifications build the plan for OS migration from Unix to Linux SUSE.
• Followed best practices, standards, and governance for complex integrated service oriented architectures (SOA).
• Requirements elicitation and gathering, Data Modeling and reviews, socializing the technical team with requirements, Production Support, Administration of Qlikview, Cognos and Data stage application server.
• SDLC - Waterfall, Interactive -Development of application for North America ( Client Portal Policy, Request, Program and Finance Modules ) to the KL user’s Dashboards
• Lead Cognos and QlikView Development engagements.
• Design and build Cognos and QlikView Solutions to meet customer specifications.
• Manage customer project expectations and deliverables.
• Deploy client solutions.
• Provide End-User/Customer in the Cognos and QlikView product and delivered solution(s).
• Support Cognos and QlikView client deployments.
• Mentor Jr. QlikView Consultants.
• Work on internal QlikView initiatives.
• Gather analytical requirements from Business Users and translate into technical requirements.
• Assist with developing estimates and describing solutions during the proposal process

Confidential

BI Technical Architect

Responsibilities:

• Total application lifecycle management (ALM) perspective including technical understanding of relationships, Involved in-bound and out-bound dependences and requirements of hardware and software components
• Gathered system requirements and specifications build the plan for OS migration from Unix to Linux SUSE.
• Followed best practices, standards, and governance for complex integrated service oriented architectures (SOA).
• Requirements elicitation and gathering, Data Modeling and reviews, socializing the technical team with requirements, Production Support, Administration of Qlikview, Cognos and Data stage application server.
• SDLC - Waterfall, Interactive -Development of application for North America ( Client Portal Policy, Request, Program and Finance Modules ) to the KL user’s Dashboards
• Manage customer project expectations and deliverables.
• Reconcile data from various systems to gain a complete view of customers
• Use snapshots of Salesforce(SFDC) data for time-period analysis.
• Provide End-User/Customer in the Cognos and Salesforce to view minute wise product and delivered solution(s).
• Gather analytical requirements from Business Users and translate into technical requirements.
• Assist with developing estimates and describing solutions during the proposal process

Confidential

BI Technical Architect

Responsibilities:

• Total application lifecycle management (ALM) perspective including technical understanding of relationships, Involved in-bound and out-bound dependences and requirements of hardware and software components
• Gathered system requirements and specifications build the plan for OS migration from Unix to Linux SUSE.
• Followed best practices, standards, and governance for complex integrated service oriented architectures (SOA).
• Requirements elicitation and gathering, Data Modeling and reviews, socializing the technical team with requirements, Production Support, Administration of Qlikview, Cognos and Data stage application server.
• SDLC - Waterfall, Interactive -Development of application for Confidential North America ( Marketing and Finance Modules ) and Confidential Europe Buyer Dashboards
• Agile- Scrum - Additional functionality to support to Confidential Europe Cluster Marketing and Local Marketing Teams and Other system improvements
• Upgraded the user access system from LDAP to SSO on Cognos application and Upgraded the secured http for application URL.
• Support Cognos and QlikView client deployments.
• Mentor Cognos and Jr. QlikView Consultants.
• Work on internal Cognos and QlikView initiatives.
• Gather analytical requirements from Business Users and translate into technical requirements.

Confidential

Technical Architect

Responsibilities:

• Managed server infrastructure and work flow functions with automated Unix scripts
• Built the Autosys jobs and cron scheduler managed the scheduler and controlled the scripts.
• Administrator for Cognos and Qlikview reporting application to maintain supplier and customer groups and roles.
• Administrator for Online application which is data extracted from staging tables
• Introduced API tools to upload the API files to feed the staging tables.
• Interacted with Confidential users and gathered user requirements.

Confidential

Sr. Cognos/Tableau Developer/Team Lead

Responsibilities:

• Installed and configured Cognos 8.4.1 on Solaris platform and implemented custom Java authentication.
• Created user roles and groups and assigned capabilities.
• Implemented Single Sign-On (SSO) between Cognos and third-party web portal.
• Design, develop, and support of the overall Cognos Framework report model.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed and Designed Chart reports, List reports, Crosstab reports, Master Detail reports, Drill through reports in report studio that are required for the business users.
• Developing the Dashboard reports using Cognos Report Studio and Tableau.
• Writing the SQL scripts and procedures to load the data into Reporting tables.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.

Confidential

Team Lead/Cognos Developer

Responsibilities:

• Gathered the Business Requirements from the end-users
• Built metadata models, modified, and published several packages using Framework Manager according to the business needs which can be used by Report Developers.
• Performed detailed documentation of design, development, testing and deployment activities
• Developed Standard Templates, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8
• Developed filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for users
• Worked with Relational Database - Oracle.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Administered installation, configuration, and software upgrades of Cognos applications and monitor Cognos servers
• Maintained Development/QA/Production Environments, including new installations, upgrades
• Provided technical support on day-to-day basis and troubleshoot installations

Confidential

Developer/Team Lead/Onsite coordinator

Responsibilities:

• Attended knowledge transfer sessions conducted by the client with the technical team and business users to understand their business requirements in detail.
• Coordinated with the Business Owners to outline Business Requirements and transferred the same to offshore team.
• Worked with System analyst to understand the flow of data.
• Created Detailed level specification Documents, Report Mockups and modified existing on the requirements.
• Reviewed requirements and understood technical recommendations and constraints, and develop comprehensive and accurate functional documents.
• DevelopedFramework ManagerModels againstSQL Server and OracleDatabase.
• Developed drill-through reports, charts in Report Studio and implemented data level security.
• Extensively used java scripts to meet some of the business requirements.
• Involved in effort estimation.