Data Developer

SUMMARY

Seeking a challenging opportunity to utilize my expertise in Big Data and Analytics using Business Intelligence Development Tools to assist companies to integrate the systems and optimize the business processes.

Experienced in designing, developing and deploying enterprise wide analytical and Business intelligence integrated dashboards with a strong focus on statistical analytics, Geo-analytics, systems integration, data warehousing, optimizing user experience, cross-platform application development and complex interactive visualizations to meet the business trends. 5+ year’s hands on experience using TIBCO Spotfire Enterprise.

Experienced in writing SQL’s Codes (MS SQL, DB2 SQL, Netezza SQL, Hive QL, Big SQL and PL/SQL) to analyze the data for analytics. Created stored procedures for the custom functions in Spotfire along with python scripting for big data predictions and analysis. Hands on experience in administering, Deploying and maintaining models analyzing big data using Power BI, Cognos, Qlik View, Spotfire, Tableau, Business Objects, Alteryx. Worked on Qlik Tech Enterprise for Qlik View and Qlik Sense and BO dashboards developments as part of transition projects from one environment to the other. Enhanced the existing tableau and BO dashboards to meet the latest updated trends and visuals is the key expertise.

Customized security and data connectivity hierarchical structure for the users to work on uniform permission and roles for the projects. Created complex python codes to read Active directory LDAP and windows roles for row level security implementation at the dashboard and the data level along with personalized dashboards for the business. Created complex statistical and financial analytical models, trend over time statistical visuals, ranking and forecast reports, Executive Dashboards using Tibco and Qlik Tech line of enterprise products.

Hands on experience in SDLC documentation, End User training, installation and configuring the server for the Spotfire users and as well as the load balancers. Experienced in 24/7-production support and troubleshooting. Authored system-build guides for the resources to enable configurations, SSO, Safe Synchronization, Additional domains, Deployment of third-party tool in collaboration with TIBCO as well as Qlik Tech.

Experienced in creating data lineages for enterprise Datawarehouse. Developed AI powered data catalog and data lineages using various EDC tools such as Steer wise Data Symantec Analyzer and AXON for enterprise. Analyze various data systems and flow pushed and pulled into Data lake using various databases and scripting. Documented and supported MFT Jobs for various applications like AXCIOM, CROWE, Wallstreet Suite, Segent and other data sources

EDUCATION

MS, Industrial Management, University of Central Missouri, Warrensburg, MO. 2011 - 2013

BS, Electronics and Communications Engineering, JNTU University, Hyderabad, India. 2007 - 2011

TECHNICAL SKILLS

BI Analytical Tools: TIBCO Spotfire Enterprise 6.0 until 7.7,SQL Management Studio (SSIS, SSRS, SSAS), Qlik Tech – Qlik View, Qlik Sense, Tableau, Power BI Professional, Business Objects Analysis, Power BI, Datameer, IBM Aginity H, IBM Aginity workbench, MicroStrategy Reporting, Steer wise Data Symantec Analyzer, AXON.

Web Technologies: HTML/HTML5, CSS/CSS3, JavaScript, TypeScript, jQuery, Angular, React JS, Node.js and Bootstrap.

Database: MongoDB, Oracle, SQL Server 2012, DB2, SAS Data sets, Teradata and Flat files, Netezza, Hadoop, BigSQL, HIVE, HIVE2, Presto, Hortonworks

Languages: SQL, PL/SQL, Hive QL, DB2 SQL, Big SQL, Netezza SQL, Iron-Python.

IDE/Text Editors: Eclipse, Visual Studio Code, SQL Developer and WebStorm.

Version Control Systems: GIT, Bitbucket and SVN.

Operating Systems: Windows, Linux, and Mac OS.

PROFESSIONAL EXPERIENCE

Toyota Financial Services, Plano, TX Dec 2019-Present

Consultant (Technical Specialist – Enterprise Data Catalog)

Consultant for Enterprise Data Catalog, Meta X C Factory

Responsibilities (but not limited to):

Developed AI powered data catalog and data lineages using various EDC tools such as Steer wise Data Symantec Analyzer and AXON for enterprise.

Analyze various data systems and flow pushed and pulled into Data lake using various databases and scripting.

Documented and supported MFT Jobs for various applications like AXCIOM, CROWE, Wallstreet Suite and other data sources.

Bank of Montreal, Chicago, IL Aug 2014 – Dec 2019

Sr. Consultant (Technical Specialist – Data and Analytics)

Business Intelligence Developer (Spotfire / Qlik view) for P & C US Data and Analytics at BMO Harris.

Projects (but not limited to):

AML HRA Phase-1 (August 2014 - December 2015).

AML SCV 360-Degree Report (Single Customer View).

AML Suspects Analytical Assessment.

OSFI Intraday Liquidity Monitoring Project: US Liquidity Flow OF Funds/Intraday Analysis.

Tableau Reports to Spotfire Reporting Migration.

AML HRA Phase-2 (August 2015- December 2015).

IDP – TPBI (+ TPSS) 2015 – 2017

BO Reports to Spotfire Reporting implementation.

Trade Finance Reporting and Analytics - Jupiter (GE Transition) – 2016-2017

oSpotfire Analytics

oQlik View Dashboards and Reports

DAO Application – (Digital Account Openings) - 2017 – Present

Tele Consumer Protection Act - TCPA - 2017 – Present

Spotfire Upgrade & Migration 6.0- to 7.0 and Current 7.0 - 7.7 - 2017 & 2018

SSO Configuration - 2017

IDP 2.0- TPBI /TPRS Touch Point Reporting Services (Netezza to Hadoop Conversion)

IDP 2.0- TPBI/TPRS Touch Point Reporting Services (Netezza to Big SQL Conversion)

Role Player - Beneficial Ownership

BHOB - BMO Harris Online Banking

Install and Configure Audit & Monitoring Tools – Spotfire Action Logs

24/7 Production Support

Responsibilities (but not limited to):

Responsibilities are identifying, sourcing, normalizing, aggregating and running a series of analytics against bank data, including client demographic, geographic and transactional data.

Created Data Sources/ Universe by using Information Designer to connect various data marts by mashing up the data from SQL Server/SQL Server Data Direct, SAS/Share functions, Hadoop, Netezza and DB2.Ran enterprise level scale of statistical and analytical models to explore the data for the business needs. Worked as an Admin for (SQL server, Netezza, Hadoop, Datameer)/Spotfire/Qlik View/ BO/ Tableau. Converted all the dashboards hosted on different BI Environments like tableau and BO to Spotfire compatible. Enhanced existing Tableau dashboards to meet the advanced logics and business requirements.

Customized security and data connectivity hierarchical structure for the users and group level security standards for Spotfire at the bank for P & C US Data and Analytics Owned environment. Created Information links across projects for combination of most common elements and used in various reports to minimize development effort using Python IDE. Involved in developing new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

1.Setting up the servers for the Spotfire professional client and Web player. Configuring the databases and users to login and access Spotfire analysis.

2.LDAP Configuration for Single Sign On. Configured Active Directory users to use their default domain credentials to use the technology to full extent. Enabling and configuring action log data base in tie with the spotfire database to monitor and report the Spotfire tool user and library activities for auditing at the bank.

3.Designed hierarchy for the library structure and roles for the users such as permissions for developers and web viewers. Administration, assigning users, troubleshooting server issues related to all BI environment is the main key responsibility at the bank.

4.Created complex customized SQL’s for TPSS Projects which involved row level as well as the hierarchy level permissions to access the reports and as well as the data for the TPBI project which is a transition of 35 dashboards from Business Objects to Spotfire for over a period of 16 months.

5.Experience in Hadoop Hive, BigSQL, Hortonworks Kerberos and non-Kerberos set up configuration.

Scripting: Python, R and JS

Query Languages: SQL, NZ SQL (Netezza), Hadoop QL (Big-SQL, HIVE QL)

Environments: TIBCO Spotfire Enterprise 6.0 until X, SQL Management Studio (SSIS, SSRS, SSAS), Qlik Tech – Qlik View, Qlik Sense, Tableau, Power BI, Business Objects Analysis, Datameer, IBM Aginity H, IBM Aginity workbench, Looker, MicroStrategy Reporting, DB Visualizer, Aginity H and Aginity Nz.

McGraw-Hill Financial, Hightstown, NJ

Developer Aug 2013 - Jun 2014

Responsibilities (but not limited to):

Designed and developed Sales dashboards with different visualizations for marketing team like Bar Charts, Combination charts, Cross Table and line charts.

Created information links, data elements using information designer and used custom SQL in complex information links.

Used property control, Action control within the score cards and scheduled through automation services for embedding the data

Dashboards are accessing data from various sources Excel file son share point, CSV on share drives and SAS data sets from SAS data source.

Applied calculated columns and custom expressions within report to get informative data according to business requirements.

Extensively used Library Administrator to create folders for all developers and assign proper security within spot fire

Created performance scorecards using combination charts, summery table and parallel coordinate plot.

Created hyper link reports to make drill down reports for end users

Part of Spot fire version upgrade from 3.2.1 to 4.0.2, evaluated and resolved all impacted report issues

Provided 24/7 supports as part of on call support for production.

Environment: Spotfire professionals 6.0, Spotfire web player, Spotfire enterprise player, SQL Server 2008, SQL.

Professional References: Available upon requests.

Contact this candidate