Senior Programmer Analyst Resume

SUMMARY

Data warehousing BI specialist with 10 years of experience in implementing various data warehousing solutions
Significant experience in translating business requirements to technical requirements, designing & estimation of BI solutions
Expertise in using SQL for analyzing and profiling data. Experience in various databases - Oracle, SQL Server, Netezza and Teradata
Experience developing BI dashboards using Tibco Spotfire and Microstrategy
Good in Unix shell scripting & Windows Scripting
Experience working in agile scrum framework using Azure DevOps
Self-motivated with proven analytical, technical, and communication skills.
Quick learner, adaptable and process-oriented with strong customer focus
Strong team player; collaborates well with others to solve problems and actively incorporates input from various sources

TECHNICAL SKILLS

BI Tools: Tibco Spotfire, Microstrategy, Business Objects

QC Tools: HP ALM

ETL Tools: Informatica Powercenter (Certified), Abinitio, Tibco BW

Database: Oracle10g, Oracle 12c, IBM Netezza, Teradata, SQL Server

Incident Management Tools: Service now, Jira

Scripting: Unix Shell & Windows Scripting

PROFESSIONAL EXPERIENCE

Confidential

Senior Programmer Analyst

Responsibilities:

Responsible for gathering and translating business requirements into systems design and specifications
Develop BI dashboards using TIBCO Spotfire. (Using direct DB connection, Information Links, TDV, SBDF etc)
Administer tibco spotfire environment (Server, webplayer, automation service & TSSS).
Taking care of access, permission, installation, upgrades & hotfixes of spotfire environment
Perform data profiling and validation using SQL.
Enhancing relational data models and improving data query efficiency.
Building real-time data capture from Rest API’s and transformation functionality using Tibco BW
Integrate systems using various data warehouse technology stacks like Informatica, Abinitio & Shell Scripting.
Research and training on improving current systems using Big data and Machine learning

Confidential

Application Development Specialist

Responsibilities:

Leading 4 member ETL team for Informatica upgrade from 9.5.1 to 10.0, redesigning and rewriting of Unix scripts, Windows scripts and PL/SQL
Worked on developing and recoding ETL jobs, unix shell scripts, windows scripts and oracle pl/sql code
As part of analysis phase, performed analysis of existing system and identified the gaps which needs to be re-designed and developed
Provided estimates and new design as per new architecture and security model
Driving the project by interacting with client on regular basis and providing regular status updates
Coordinated with different vendors involved, especially with infrastructure vendor to get relevant accesses and other issues faced on infrastructure side