SUMMARY

• Over 16 Years of experience as a Software Professional designing and developing Enterprise Applications in various industry verticals like Healthcare, Retail, Manufacturing, Digital Media and Entertainment, e - commerce, Telecommunications, Education, Work Force Management, Web Analytics etc
• Consistent accolades and Employee Recognition awards for performance at almost all the workplaces
• Employee Recognition Award at Confidential
• Performance review of “Exceeding Expectations” for 4 years in a row at Confidential
• Accolades in the NOSG News Letter of Bellsouth as the best employee of the ESM-POTS development team
• Experience of managing BI environment including Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools
• Proficient in Data warehouse dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification, Kimball strategies and OLAP
• Expertise Database Developer in designing database solutions, planning deployments, designing backup strategies, optimizing and performance tuning databases
• Excellent interpersonal skills with proven written and communication skills. Ability to learn quickly and proactive

TECHNICAL SKILLS

Databases: Oracle 10g, SQL Server

Business Intelligence: SSIS, SSAS, SSRS, T-SQL, Talend, Microstrategy, Tableau, MDM, Power BI

PROFESSIONAL EXPERIENCE

Confidential

Data/BI/ETL Architect

Responsibilities:

• Designed and developed the ETL for reconciling the financial data from multiple suppliers and the in-house billing platforms.
• Served as liaison between Application team, Finance Team and DBA team to drive the Analytics project.
• Developed reporting tools that helps accounting department to track anomalies with invoicing quickly.
• Identify the patterns and outliers in the order management and billing databases proactively and programmatically.
• Responsible for strategy, assessments, analysis, data management and solution design of BI projects.

Confidential

BI Architect

Responsibilities:

• Designed and developed a BI platform for Web Analytics with Confidential MySQL as the source and a flexible reporting layer.
• Used Web Analytics to enhance the search relevancy index for users search keywords. This resulted in increased customer satisfaction for finding the products of their interest.

Confidential

BI Architect

Responsibilities:

• Designed and developed the Business Intelligence platform for Confidential ' order processing and redemption Analytics.
• Helped the marketing and relationship management teams with compelling visuals and metrics from the warehouse to add credibility to their sales pitch.

Confidential

Solutions Architect

Responsibilities:

• Responsible for meeting very aggressive SLAs and targets of 99.95% up time.
• Re-architected the AmazonShopWithPoints application in Talend and brought down the SLA problems from 100 issues a year to less than 5 per year.

Confidential

ETL Architect

Responsibilities:

• Reverse engineered the ETL process and helped the team migrate 16 merchants' catalog processing ETLS from Talend to Groovy.
• Helped the team with performance tuning aspects to not carry forward the unnecessary processing overheads into the new process.

Environment: SQL Server 2014, SQL Server 2012, SSDT, BIDS, SSRS, SSAS, SSIS, DevExpress, PowerBI, MongoDB, Talend, Solr, Groovy, JIRA, Confidential, Google Analytics, Power BI

Sr. BI Consultant

Confidential

Responsibilities:

• Performance-tuned the ETL, SSAS and SSRS solutions with Databases in Terabytes to meet the performance requirements
• Mentoring software engineers in architectural issues and best practices in Data warehouse design and BI solutions.
• Responsible for strategy, assessments, analysis, data management and solution design of BI projects.
• Involved in MDM initiatives for revamping and cleaning the Datawarehouse.
• Served on the advisory board to partially remodel the DW and minimize the maintenance costs.
• Followed Lean Principles for Solution Delivery.
• Team Lead for supporting “Troubleshooting” requests from the Business and fellow-engineers.

Environment: SQL Server 2008 R2, SQL Server 2012, SSDT, BIDS, SSRS, SSAS, SSIS, TeamTrack,, SQL Profiler, VersionOne

ETL Architect & MDM Consultant

Confidential

Responsibilities:

• Migrated information from legacy system to Salesforce cloud using Talend ETL Tool.
• Performed Data Profiling using Talend Data Quality Tool.
• Generated operational reports using Talend.
• Migrated existing reports from Business Objects and customized spreadsheets to SSRS
• Performance-tuned the Talend ETL for Hadoop Data with billions of records
• Involved extensively in the Data Governance Lead at TWC
• Involved in the MDM (Master Data Management) initiative to converge the digital and cable media information for Customer and Product dimensions.

Environment: Talend TIS, Talend Data Quality, Talend MDM, JIRA, MySQL, SQL Server 2008, SalesForce, Solbright, Operative, Google DFP

Sr. ETL Architect

Confidential, Atlanta GA

Responsibilities:

• Technical Lead for the Continue Engineering Team to prioritize and resolve escalated customer issues and was appreciated by the KGS and ACs for quick turnaround time
• Architect of “Quality Initiative Predictive Analytics” project for predicting the software quality in a release candidate at Confidential . Used various Data Mining algorithms to understand the factors affecting quality. This project helped the release engineering team to make a decision on the product release date, which was critical for the success of the product release.
• Developed complete Business Intelligence solutions (ETL, Data marts, reports, cubes) supporting both SQL Server and Oracle
• Developed ETL solutions using SSIS packages for implementing data extract, load and transform mechanisms incorporating business policies and procedures; Experience in deploying, executing and troubleshooting SSIS packages
• Experience with Performance Tuning the ETL stored procedures, SSAS cubes, SSRS reports to meet the PRDs of Confidential
• Designed an automation strategy using SILK to smoke test the service pack saving 2 months of testing efforts for every release
• Designed Proof-of-Concepts and prototypes using the Talend ETL tool for converting our ETL solution to Talend
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements
• Expert in creating Cubes and Implementation of perspectives, partitions, aggregations, roles, calculated members, calculated measures using SSAS
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings to analyze performance
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Expertise in generating reports using SQL Server Reporting Services (SSRS) and Excel spreadsheet, scheduling and deploying reports on report manager using SharePoint integration services
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008
• Good communication skills made me the liaison between Confidential and Sonata for the SSRS reports project and we delivered more than thirty complex reports in a short span of time
• Designed and developed the Globalization strategy for all the Analytics - SSRS reports
• Responsible for the Performance tuning the SQL Commands using SQL Profiler and Database Engine Tuning Wizard
• Project Lead for the “Time Summary” project and “ETL Porting to Oracle” project using Agile and Scrum Methodologies
• Team management with technical assistance to ensure successful delivery of the projects
• Was responsible for Weekly Status tracking, Milestone reporting, Work Order and Change Requests processing
• Interaction with Vice President, Directors, Program Managers and Subject Matter Experts
• Adhered to strict timelines, coding guidelines, deliverables and quality
• Mentored and coached team members. Held many Lunch and Learn sessions to distribute the domain and technical knowledge in the area of SSAS, SSRS, Sql Server Database Engine, Analytics, Accurev, DevTrack
• Demonstrated willingness to ‘pitch in’ where necessary to help the team achieve its goal. This required collaboration with others on design, development, testing, documentation and/or production support tasks

Environment: SQL Server 2005, 2008, Oracle 10g, Business Intelligent Studio, ASP .NET 2.0, BI Portal, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, AccuRev, DevTrack, Talend, MS Project, Talend, VersionOne, Microstrategy

Sr.Software Engineer

Confidential, Chelmsford, MA

Responsibilities:

• Worked on Single-Sign-On configuration of WebSphere Portal Server.
• Integrated the Computer Associates - SiteMinder’s authentication with Work Force Central’s authentication mechanism.
• Worked on localization of Retail and Healthcare Portals on Share Point and WebSphere Portal Server.
• Worked on J2EE Web Services / Authentication Filters for Confidential Dashboard.

Environment: Visual Studio .NET, Microsoft SharePoint, WebSphere Application Server, WebSphere Portal Server, Eclipse, Web Services, Computer Associate’s SiteMinder 5.0, 6.0, SunOne LDAP, AccuRev, DevTrack

Sr.J2EE Developer & Database Developer

Confidential, Atlanta, GA

Responsibilities:

• Technical lead for the POTS team consisting of 7 developers and 5 Quality Assurance Engineers. Our team was consistently known for quick turnaround time under my leadership
• Worked on making ESM-POTS application Single-Sign-On capable, fault tolerant and scalable
• Awarded as the best employee by the Test-engineers at Bell-South appreciating my expertise to troubleshoot the defects and providing fixes quickly
• Good communication skills made me the liaison between Bellsouth and Cap-Gemini for the POTS optimization project
• Saved $100000 for Bellsouth by optimizing a module in the Daily Process which reduced the processing time by 1 hour

Environment: Java, Servlets, JSP, STRUTS, UNIX, Oracle 9i, Weblogic, JBuilder, Harvest, Test Director, TCL-TK, ERWin

J2EE Developer

Confidential, Birmingham, AL

Responsibilities:

• Designed and modeled the database for Change Control Process.
• Developed a web interface for the change control process (CCP), a change-request reporting process using JSP and Java Servlets.
• Developed the Change Management Process (CM) for the BellSouth Technology Group (BTG) of Bellsouth to track all of the changes that occur for each release
• Built reports using the JExcel API, which could be downloaded and saved on the local machine.

Environment: Erwin, Java, Servlets, JSP, JDBC, J2EE, NetBeans, CVS, HTML, Oracle 9i, UNIX, ERWIN