SUMMARY:

• Visionary and goal - oriented IT Team Lead with demonstrated experience in planning, developing, and implementing cutting edge information solutions to address business opportunities, Develop strategic plans for worldwide implementation and operation of Master Data Management. Initiate and enforce strict budget controls addressing company need and promotion of growth. Adept at crisis management, trouble-shooting, problem-solving and negotiation. Experienced in joint application development, benchmarking, capacity planning, project and resource management and cross-functional team training.
• Over 15 years of experience in Database Design, Development and maintenance of database applications on SQL Server 2000/2005/2008/2008 R2/2012 in OLTP/OLAP/BI environment.
• Implementing Master Data Management Solutions.
• Over 13 years of IT experience.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management .
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Experience in creating reports by using ProClarity Views and Dashboards strategy.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

• SSIS
• SSAS
• SSRS
• Epiphany Sales & Service(version 5.0 to 6.5)
• Epiphany Interaction Advisor(IA)
• MS SQL server
• Oracle
• JavaScript
• VBScript
• Pearl
• PHP
• HTML
• XML
• XSLT
• SOAP
• Webservices
• WSDL
• JAVA
• IBM MQ series
• Visual Basic 6.0
• COM
• ASP
• Visual Interdev

PROFESSIONAL EXPERIENCE:

Sr. BI Developer

Confidential

Responsibilities:

• Designed, Developed and Implemented Derived Hierarchy bases MDM model.
• Designed, Developed and Implemented MS BI using SSIS, SSRS, SSAS
• Working with Business users to gather requirements.
• Implemented strategy for Master Data.
• Developed Development, QA, Staging and Production environment.
• Educating and getting business team familiar with Master Data.
• Building Data Steward Group of users.
• Maintaining MDM Security.
• Integrating Java application with MDM by exposing Web Services.
• Building and Maintaining MDM views.

Sr. Consultant

Confidential

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS for MS MDS
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible to support SQL Servers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2008 R2 / 2012 Reporting Services.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Sr. Analyst

Confidential

• Involved in gathering the user requirements.
• Involved in physical and logical data modeling using Erwin.
• Created stored procedures, triggers, Joins, functions and views.
• Created SQL server Reports using SSRS 2008.
• Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL SERVER Reporting Services.
• Identified the data source and defining them to build the data source views.
• Debugging reports and deploying reports.
• Involved in SSRS report deployment and report server configuration.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Scheduled the reports to run automatically.
• Launching the report builder for adhoc reports.
• Configuring the report viewing security.
• Created schedules and subscriptions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Creating Stored Procedures for reports generation.
• Involved in database backup, recovery procedures.
• Planned back up strategy for disaster recovery.
• Responsible for log backups and restoration.
• Worked with Dynamic Management Views (DMV) for improving query performance.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Proficient with SQL server agent for scheduling jobs, SQL profiler for database tuning.
• Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Tested applications for performance, data integrity and validation issues.

Team Lead

Confidential

• Primary responsibilities includes: Requirements gathering, Documentation, Design, Development, Unit Test, Installation and maintenance of Epiphany Inbound Marketing.
• Worked on Epiphany’s business rules engine.
• Work with business users, to resolve problems with business rules implemented in the application by the business users.
• Responsible for evaluating Epiphany Interaction Advisor (Product Cross Sell).
• Primary responsibility is to generate efficient reporting for the Interaction Advisor.
• Main Goal was to increase click rate by 35% on troubled offers.
• Responsible for maintenance of Epiphany Interaction Advisor (Product Cross Sell).
• Support and resolve daily production issues and make changes to production environment as required.

Team Lead

Confidential

• Primary responsibilities include requirements gathering, documentation, design, development, unit test and support of new and existing Epiphany Sales & Service functionality.
• Responsible for upgrade of Epiphany 6.0 to Epiphany 6.5 systems.
• Playing role of a team lead, distributing tasks to offshore and onshore resources.
• Support and resolve daily production issues and make changes to production environment as required.

Technical Lead

Confidential

• Primary responsibilities include requirements gathering, documentation, design, development, unit test and support of new and existing Epiphany Sales & Service functionality.
• Developed and Maintained Perl script which masked secured data.
• Supported and participated in the ETL data process between Epiphany 6.5 and Epiphany 5.5 systems.
• Integrated Webstore, AS/400 and Epiphany 6.5 System.
• Support and resolve daily production issues and make changes to production environment as required.

Sr. Analyst

Confidential

• Worked on Epiphany’s business rules engine (similar to ILOG’s Business Rules Engine).
• Work with business users, to resolve problems with business rules implemented in the application by the business users.
• Responsible for automation of everyday marketing processes to save time and built robust application to integrate with Epiphany’s Real Time (RT) Application.
• Heavy customization in Epiphany environment using JavaScript and Oracle backend.
• Integration of RT with TeraData warehouse.
• Build Global Cache Mechanism, which can be accessible from different packages.
• Worked with end-users to define requirements for marketing new product to the call center application.

Sr. Consultant

Confidential

• Worked with the sales team to demonstrate Epiphany CRM platform.
• Supported Epiphany 5.5, Heavy customization using ASP, VB, Javascript, HTML, XML, XSLT and MS SQL Server.
• Primary responsibilities included Epiphany Interaction Platform (IP) upgrade, design, development and integration with Legacy Systems.
• Worked with the end-users to define requirements for Customer Service call center upgrade.