Sameena Shaik Email & Phone Number

Carrollton

•Handled different BI projects completely from collecting the requirements to the delivery of the solutions.•Analyzed the requirements, specifications provided by the users and created the specification documents.•Interacted with development and management teams of other I.T teams to understand and map the user requirements to technical requirements.•Analyzed the existing database schemas on Netezza, Oracle, Sql Server and mapped the business requirements to technical requirements.•Conducted Data Analysis and worked closely with DBAs to design new database objects, identify issues with existing objects and suggested enhancements.•Designed and Developed ETL code using Informatica to extract data from different sources, transform, cleanse and apply complex logic, load the data into BI data warehouse.•Created and published framework models using Cognos Framework Manager 10.1/10.2.1/10.2.2 including relationships, filters, aggregations, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer.•Developed different framework models to support different set of reporting requirements.•Created different drill through, drill down reports using report studio according to the requirements and are run by the users based on the demand.•Created complex dashboards with pie charts, bar graphs, cross tabs for the executives to visualize company growth metrics.•Handled deployments of the reports, ETL code and packages to QA, UAT and Production environments.•Performed data analysis and wrote complex sql queries using Toad on Oracle, Netezza, Sql Server at each level for data validation.•Developed SSRS reports from operational data sources and published them on production as per the business need.•Gained good working knowledge on Tableau to design different dashboards and graph charts.•After delivery of the solutions, performed the on-going support for the users and involved in training of the users.

Grapevine,Tx

•Experience in Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Transformer and Cognos Administration.•Experience in designing and developing the Framework Manager models using stored procedures, relational tables using different data sources. •Experience in creating List Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through, Repeater Reports using Report Studio.•Experience in creating dashboards and scorecards.•Experience in creating events using event management studio to run the reports based on the user needs.•Experience in creating scheduled burst reports.•Experience in distributing reports based on calendar, events and external triggers.•Developed and Designed standard templates for future reporting needs of the projects.•Experience in conducting data analysis on sql server, vertica and netezza databases and understand data warehouse schemas, relationships and objects.•Experience in gathering requirements to design and develop the reports.•Experience in creating dashboards and scorecards.•Experience with creating Power cubes using Cognos Transformer.•Experience in configuring cognos 10.2, migrating reports from cognos 10.1 to cognos 10.2 environment.•Experience in installing different database software on cognos servers.•Experience working with complex SQL Queries on sql server management studio to analyze and validate the data on cognos reports.•Experience in writing and understanding sql queries on Netezza database for validating the cognos reports.•Experience with performance tuning of sql queries on different databases.•Experience production support, troubleshooting the existing reports and optimizing them.•Experience with tracking tickets, incidents and resolved them in priority.•Experience in Recycling Cognos Services and monitoring scheduled reports in Cognos Administration Connection.•Experience in deploying the reports and models to QA, UAT environments.

Bentonville,Ar

• Wrote SQL Scripts using Microsoft SQL Server for optimizing data from Retail Link (Walmart’s data repository), Shiloh(Hershey’s data repository) and generated Crystal Reports for Hershey Walmart Category Advisor Team and Hershey Insights Team.• Designed, created databases on Microsoft SQL Server Platform including normalization techniques, writing Stored Procedures, Triggers etc.• Designed, created and monitored SQL SSIS Packages on Microsoft Business Intelligence Development Studio to transform data and to perform ETL process. Wrote Vb scripts to create SSIS script tasks.• Redesigned SSIS package to improve the efficiency of Sams Club Cube in support of the Hershey US Sams business/sales.• Performed ongoing project work leveraging T-SQL, PL/SQL in support of Hershey Walmart US, International and Sams Club business/sales.• Worked on documentation, process improvement, Modified and Monitored the existing applications to satisfy the end user requirements.• Anaylzed, monitored and redesigned the SSAS OLAP Microsoft BIDS cube using to support the reporting of multidimensional data for Sams Club business/sales.• Designed and created SAP Crystal Reports, published those Reports on Business Objects Enterprise for supporting Hershey Sales. • Analyzed business requirements, mapped them into software requirements and delivered solutions as per the business need.• Troubleshooting the tasks, Conducted Complex Technical Investigation and recommended the changes with minimal supervision.• Self-motivated, team oriented, ability for critical thinking, analysis, possess good interpersonal and communication skills.

Masters, Information Technology And Management

Activities and Societies: SAP Users Group

Master'S Degree, Management Information Systems