Sr Developer & Analyst

Srinivas Dronamraju

Tableau Developer

Professional Summary:

• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.

• Certified Tableau Developer.

• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau/Spotfire.

• Experienced in Business Intelligence (SSIS, SSAS and SSRS), Data Warehousing and Dashboards. Develop & deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).

• Expertise in generating reports using global variables, expressions and functions for the reports.

• Experience in using SQL Server 2005 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, Lotus notes and DTS (i.e. Import and Export) also worked to Automate the ETL operations.(Automate the SSIS Packages and Import, Export).

• Used Bulk Copy Program extensively for transferring data from Text to SQL Server.

• Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.

• Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau/Spotfire

• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML). Experience in Database modeling using data modeling tool.

• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).

Education:

MS in Computer science San Jose

CERTIFICATIONS:

Microsoft certified IT professional in Business Intelligence

Microsoft certified Technology Specialist in SQL 2005

TECHNICAL SKILLS:

RDBMS: MS SQL Server 7.0 / 2000 / 2005, Oracle 9i, MS Access.

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Crystal Reports 9.0 / 10.

Programming Languages: SQL, TSQL

ETL: Data Transformation Services (DTS), SQL Server Integration Services (SSIS),Talend

Reporting tools Tableau, Logi XML , Spotfire , Qlikview

Scripts: VBScript, HTML and XML.

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express.

Applications: Microsoft Office, Visio, and Visual SourceSafe.

Client: Fannie Mae

Position: BI Developer: Tableau/Spotfire Admin August 2011 ¬¬– Present

Responsibilities:

• Currently working as a Admin for Spotfire and Tableau

• In charge of all the support for the tools

• In charge of the team that built the shared Tableau Platform over the virtual environment.

• Working with User for requirements and part of the team developing the software.

• Training sessions to the employees on the tools

• Created Backup scripts to take periodic backups for the content on Tableau server.

• Defined group level security standards for Tableau

• Designed the strategy for Automated Software Delivery through Silent install for Tableau.

• JDK remediation project for Spotfire

• Folder structure Security and set up for defining the standards in Spotfire

Client: Team Detroit

Position: BI Developer-Tableau Admin June 2011 – August 2011

Responsibilities:

• Worked with Team Detroit an agency of Ford.

• Worked as a Tableau admin , in charge of the report development and maintenance

• Worked on the ad insight team and dealt with FORD GLOBAL,BEAT ,OMNITURE,CYMPHONY data

• Built and maintained many dashboards.

• Training classes to the employees on Tableau Software.

• Creating dataflow diagram and documenting the whole data movement process.

• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.

• Created Backup scripts to take periodic backups for the content on Tableau server

Client: Yale New Haven Hospitals January 2011- June 2011

Position: BI Developer-Tableau

Responsibilities:

• Currently finished the project with Yale New Haven Hospitals

• Worked on Tableau ,Dashboard and report development team under Performance management

• Worked closely with Oncology department reporting team and lead the HAIR Reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.

• Took part in the requirement gathering for the report development from the clients and created reports on par with the requirements.

• Took some sessions for the employees coaching them in Tableau development.

• Worked on the backend SSAS cube development which was the source data for the tableau.

• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.

Client: Datavibes October 2008- January 2010

Position: BI Developer

Responsibilities:

• Worked on Database design and reporting. Experience working with Tableau, development of dashboards and publishing the reports. Working on Data warehousing and reporting.

• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)

• Experience in using SQL Server 2005 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle, Lotus notes and Sybase and DTS (i.e. Import and Export) and Automate the ETL operations.(Automate SSIS Packages and Import, Export).

• Developing Ad hoc reports within SQL Server Reporting Service (SSRS).

• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.

• Working on Subversion and repositories.

• Working with Tableau, Spotfire, Qlikview, Logi XML tools for reporting.

• Creating dataflow diagram and documenting the whole data movement process.

• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.

• Migrating data based on the confirmed Customer's, Technician's and Service Provider's.

• Creating report models and deploying on report server.

• Creating standard report Subscriptions and Data Driven report Subscriptions

• Creating report snapshots and cache for better performance.

Citi Corp, Sioux falls SD April 2008 – September 2008

Sr. BI Developer / SSRS

• Work with application teams, developers and contractors to provide security reviews of new and existing applications. Worked with Tableau and evaluated the need for the tool in relation with the project for CFNA

• Mentoring skill set to multiple projects, including functionality, compatibility, reliability, load/stress, security and related testing of a wide variety of web-based, production, printer, multimedia, network, and educational and related software products on Windows. Creation and execution of test plans and test suites; exploratory/ad hoc testing; bug documentation and regression and summary writing.

• Working with SQL BI team in maintaining the Citi Database servers

• Working with the Security group in testing the venerable areas.

• Working on Citi Active directories and several applications like Recon, Reveal.

• Working with the transitioning team in designing the ISW reports and reviews.

• Working with the ISW team in developing the ISW work portal.

• Experienced in developing Start Schema and Snow flex Schema and Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, MDX Scripts and formulas, Refresh Strategy and Planning.

• Extensive experience in the automate tasks using active script and implement failure alerts using email.

• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).

• Working with the Software testing team in determining the workflow

• Monitor/Maintain network Servers (Domain Controllers, MS Exchange, etc).

• Multi-tasking with IT projects and support tickets.

• Assist in maintenance, support and reporting of the Citi Bank Security Vulnerability Management Program.

• Investigating on components of new tools and technologies

• Review technical security information as part of formal project SDLC stage gates.

Contact this candidate