Sql Server Data
Resume:
Srinivas Dronamraju
abhfzg@r.postjobfree.com
BI Developer
Summary:
• Worked with tools like SSRS, Tableau, Spotfire,Logi XML,Talend ETL tool.
• Have good exposure working on Tableau.
• Microsoft certified technology specialist in SQL 2005
• Generated Reports using Global Variables, Expressions and Functions for the reports using
SSRS 2005.
• Developed Query for generating drill down reports in SSRS 2005.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and
quarterly Reports including current status.
• Working with Tableau,Spotfire, Qlikview, Logi XML tools for reporting
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and
Parameterized and Linked reports. Experienced in Business Intelligence (SSIS, SSAS and SSRS),
Data Warehousing and Dashboards. Develop & 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 the SSIS
Packages and Import, Export).
• Used Bulk Copy Program extensively for transferring data from Text to SQL Server.
• Experienced in Dimensional Data modeling.
• 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.
• 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 SQL, TSQL,C++
Languages:
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:Yale New Haven Hospitals Jan 31 2011- April 8
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.
Client: Datavibes Oct-2010- Jan-2011
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.
• Experienced in Business Intelligence (SSIS, SSAS and SSRS), Data Warehousing and
Dashboards.
• 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.
Environment: SQL Server 2005/2008 (SQL Server Management Studio, Query Analyzer), SSIS,SSRS,
SPOTFIRE, QLIKVIEW.
Citi Corp, Sioux falls SD April 2009 – Sept 2010
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,
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