Manager Sql Server
Resume:
Sridhar Anuganti
*****@*******-***.***
SUMMARY:
* ***** ** ** ********** in design, analysis, development, documentation, coding and implementation on client/server environment using Cognos providing solutions Finance, Banking, Insurance, Pharmaceuticals and Retail.
Experience in Business Intelligence Tools like Cognos 8 BI (8.3/8.4 /10.2.1), SQL Server Reporting Services.
Involved in building Data Models using Framework Manager
Experience on OLAP cubes, relational and multi-dimensional Datamodels.
Good understanding of data warehousing and ETL (Extraction, Transformation and Loading) tools like SQL Server Integration Services 2010, including good knowledge of dimensional modeling.
Expert in creating List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts, Macros, filters, calculations using Cognos.
Involved in creating Cognos Business Insight in Cognos 10.2.1
Converted existing reports to an Active Report in Cognos 10.2.1
Responsible for managing the Cognos security strategy for users/groups and provide BI publishing and Monitoring reports and transformers.
Created models in framework manager from various data sources such as Oracle10g/9i, SQL Server and published package to Cognos Connection.
Excellent understanding of RDBMS and OLAP, OLTP concepts.
Extensively worked SQL Analyzer, SQL Plus, Oracle SQL Developer and TOAD.
Good knowledge in Database development and proficient in writing database Stored Procedures, Triggers, cursors and Complex queries in MS SQL Server, and Oracle.
Hands-on experience in implementing Data warehousing methodologies including STAR SCHEMAS and SNOW-FLAKE SCHEMAS for huge data warehouses.
Oversaw planning for the technology lifecycle for all infrastructure components and development methodologies, policies and procedures.
Involved in migration and installation of distributed environment.
Efficiently can use Life Cycle Manager for testing.
Excellent analytical, logical, interpersonal, communication and organizational skills.
Interaction with the Users and Business Analysts for better understanding of the reporting requirements.
Technical Skills:
Reporting Tools: Cognos 8BI, (Cognos ReportNet 1.0/1.1, Framework Manager, ReportStudio, Query Studio, Metric Studio, Analysis Studio, Event Studio), Cognos Access Manager, Architecture, Cognos Configuration, Scheduler, Cognos connection, Tableau, SQL Server Reporting Services (SSRS).
ETL Tools: SQL Server Integration Services 2010 (SSIS)
Databases: Oracle8i/9i/10g, MS SQL Server
Languages: SQL, C, C++, Java and SQL
Operating Systems: Windows 98/XP, Windows 2000 and 2003,Unix/linux 2.6
Other Tools: MS Word, MS Excel, MS Outlook, MS FrontPage, PowerPoint
Education:
●Bachelor of Technology from Jawaharlal Nehru Technological University, Hyderabad in 2007.
Certifications:
o Cognos 10 BI Multidimensional Author
o Cognos 10 BI Certified Administrator
o Cognos 8 BI Metadata Model Developer
PROFESSIONAL EXPERIENCE:
Thermo Fisher Scientific Inc., Carlsbad, CA Sep 16 to Dec 16
Description: Worked as Cognos consultant for Thermo Fisher Scientific Inc. (NYSE: TMO) is the world leader in serving science and helps customers accelerate life sciences research, solve complex analytical challenges, improve patient diagnostics and increase laboratory productivity. Premier brands – Thermos Scientific, Applied Biosystems, Invitrogen, Fisher Scientific and Unity Lab Services and also unmatched combination of innovative technologies, purchasing convenience and comprehensive support.
Responsibilities:
Gathered requirements from business end users.
Created Data Models using Framework Manager on top of the APXcelerator system for creating Adhoc Reporting.
Published packages with appropriate security settings to Cognos connection
Created List Reports, Crosstab Reports, Chart reports with cascading prompts using Cognos Report Studio
Developed complex reports using drill-through, book mark options and Master-detail relationships.
Extensively worked Oracle SQL Developer.
Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional Formatting of measures using variables.
Implemented security for package and reports based on user Group.
Scheduled & refresh the reports and bursted reports according to user requirements in Cognos connection and sent the reports through E-mail feature for Easy-to-use high level information while in the office or remote.
Tested and validated the report output against the database to measure performance of the Report.
Connect and test the data source, created database layer, physical layer and presentation layer by defining appropriate relationships between query subjects.
Prepared User documentation to train users and functionality of each report.
Communicating with Client on regular basis to ensure the report modifications are correct.
Environment: Windows 2007, Oracle 10g, Cognos 10.1.1
TPG (Texas Pacific Group), Fort Worth, TX Jan’14 to Jul'16
Role: Sr. Cognos Developer
Description: Worked as Cognos consultant for TPG.TPG Capital (formerly Texas Pacific Group) is one of the largest private equity investment firms globally, focused on leveraged buyout, growth capital and leveraged recapitalization investments in distressed companies and turnaround situations. TPG also manages investment funds specializing in growth capital, venture capital, property and casualty, public equity, and debt investments. The firm invests in a broad range of industries including consumer/retail, media and telecommunications, industrial, technology, travel/leisure and health care.
TPG Real Estate Partners (TREP) focuses primarily on investments in real estate-rich companies, property portfolios, and select single assets located in North America and Europe. Employing a value-add approach to investing, we leverage the full resources of TPG's global network to optimize property performance and enhance platform capabilities. TREP has approximately $5 billion of assets under management.
Responsibilities:
Gathered requirements from business end users.
Participated in the daily stand up SCRUM AGILE meetings as part of AGILE process for reporting the day to day developments of the work done
Installed and Configured Cognos 10.2.1 on a Distributed Environment.
Involved in the migration of the Metadata Model using Framework Manager & created query subjects, filters and packages from the framework manager in Cognos 8.4 to 10.2.1.
The Meta data was standardized for easy writing of the reports by the users.
Published packages with appropriate security settings to Cognos connection
Created List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts using Cognos Report Studio.
Administered the Reporting Environment Cognos8 BI.
Developed Scorecard, and Dashboard reports using created using cognos Business Insight in cognos 10.2.1
Created Active reports in Cognos 10.2.1
Developed complex reports using drill-through options and Master-detail relationships.
Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional Formatting of measures using variables.
Created adhoc reports Using Query studio
Administered tasks such as Scheduling, Deployment, Dispatchers
Created cubes in the transformer.
Experience using IBM Cognos 10.2.1 Cube Designer and Integrated Dynamic Cubes to develop Virtual Cubes.
Scheduled & refresh the reports and bursted reports according to user requirements in Cognos connection and sent the reports through E-mail feature and mobile Apps for Easy-to-use high level information while in the office or remote.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Responsible for loading flat files into stage tables by using Bulk Copy Program BCP & DTS/ SSIS packages.
Created packages to import Flat File and CSV file Data into SQL SERVER using SSIS.
Created SSIS package and scheduled them as SQL job to run at periodic intervals.
Involved in statistical data migrations from flat files to SQL Server database using SSIS.
Tested and validated the report output against the database to measure performance of the Report.
Involved in training sessions and demonstrated Cognos 8 tools to end-users.
Involved in installation, up gradation and migration.
Used UNIX shell scripting.
Involved in Production Support which involves solving user problems.
Environment: Windows 2008, Unix/Linux, Oracle 11g/10g, SQL Server 2012, Tableau 8.2, Cognos 8.4/10.2.1, SSIS
Eresumex.com Job Portal and Resume Management System, Alpharetta, GA Aug’11 to Dec’13
Role: Cognos Report Developer
Focused on the recruiting market EresumeX provides tools and resources that aid in the job placement process. Recruiters have access to a powerful SaaS solution that presents a collaborative resource which can be integrated with their recruiting assets via the EresumeX resume portal. No cost services include job postings, resume downloading, mass emailing & other valuable data management tools. In turn the job portal & resume management system gives a job seeker a central hub of profile information and social media networking tools with current job opportunities and mass emailing processes that creates a roadmap to employment with minimal obstacles and gives an employer faster access to the right candidates.
Responsibilities:
Developed Framework Manager Models with physical layer and presentation layer to support various business needs.
Participated in the daily stand up SCRUM AGILE meetings as part of AGILE process for reporting the day to day developments of the work done
Created hierarchies to provide drill-down options for end users.
Created List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts using Cognos 8.4 Report Studio
Interact constantly with users to get feedback and requirements on existing and upcoming reports.
Developed Complex Reports, Drill-down, Drill-through reports using Report Studio that provides various departments and levels in the organization to have an aggregated view of their respective areas and enable management to view the company’s performance based on key performance indicators.
Handled object level security in FM, security applied to various levels of hierarchy in the model including packages, folders, query subjects and query items.
Developed Complex Reports, Drill-down, Drill-through reports using Report Studio
Responsible for loading flat files into stage tables by using Bulk Copy Program BCP & DTS/ SSIS packages.
Created packages to import Flat File and CSV file Data into SQL SERVER using SSIS.
Created reports that help managers to analyze/understand specific departments that are critical to business success using multiple hierarchies in the reports.
Automated the report delivery by scheduling the reports to run during off hours & deliver to the respective department managers as needed.
Performed BI administration tasks using Cognos Configuration and Cognos Connection.
Analyzing specifications provided by the clients and developing specification documents for reports as per the requirements.
Connect and test the data source, created database layer, physical layer and presentation layer by defining appropriate relationships between query subjects.
Environment: Windows 2008, Oracle 10g, SQL Server 2008, Cognos 8.4, SSIS.
Cubist Pharmaceuticals, Lexington, MA June’09 to July’11
Role: Cognos Report Developer
Description: Cubist Pharmaceuticals is a U.S. biopharmaceutical company with activities spanning from research and development to commercialization of pharmaceutical products. Its main products target pathogens like MRSA. Cubist is one of the few firms that have continued to research in antibiotics while larger pharmaceutical companies have abandoned such research. As the history of Cubist Pharmaceuticals data for existing products Data analysis was made on the pharma data marts. Cognos can unlock the Clinical business intelligence embedded in the metrics of the data mart. And build data cubes to support ad hoc analysis of the Clinical metrics and show correlations between performances for a given metric. Used Cognos to deliver drug portfolio management to the desktops of decision-makers.
Responsibilities:
Understanding existing business model and customer requirements.
Involved in designing schema (star and snow flake) for the business processes.
Involved in design and creation of dimension tables, fact tables and cubes.
Involved in writing SQL & PL/SQL Procedures.
Administered the Reporting Environment.
Designed, developed, maintained and tested Catalogs and Cubes for supporting adhoc queries and reports in BI.
Used transformations to create the filters, lookups and aggregations used to create target tables.
Used shell scripting to schedule the jobs.
Created and executed sessions and batches using server manager.
Prepared User documentation to train users and functionality of each report.
Production Support which involves solving user problems
Environment: Oracle 8i/9i, SQL Server, WINDOWS 2000/XP.
Deutsche Bank Cary, NC Jan’08 to May’09
Role: Cognos Report Developer
Description: Deutsche Bank provides services to individuals, companies, governmental entities, and institutions in every state of United States. It offers variety of services like pay bills, Investments and Mutual Funds, Transfer funds through SWIFT, Automatic Bill payment, Alerts, Monthly Statements and lot many services in online banking. It also provides Interest Calculator, Monthly Payment Calculator and many other tools online. The Purpose of the project was to track the growth, performance and online utilization of the company’s website with its competitors in the U.S. Market.
Responsibilities:
Understanding the existing report complexities and accordingly modifying the reports based on the ongoing requirements.
Involved in enhancements of existing Reports using IBM Cognos 8.3.
Effectively changing and modifying the Framework Manager level data items.
Communicating with Client on regular basis to ensure the report modifications are correct.
Testing the Reports properly before delivering to the Client.
Environment: Oracle 9i, Windows XP, Cognos 8.3
Contact this candidate