SUMMARY

• Well versed with the concepts of Database, Information Security, Cloud Computing, E - Commerce, IT Infrastructure and Mobile Application Development.
• Database knowledge on SQL Server, Oracle, MySQL, DB2.
• Strong experience in analysis and design of relational databases (RDBMS).
• Working experience in Cognos BI tools using Cognos Framework Manager, Report studio, Query studio, Analysis studio and PowerPlay Transformer.
• Strong experience in creating and publishing packages in Framework Manager.
• Strong complex reporting skills - Active reports, complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
• Involved in a data migration process between different versions of Cognos.
• Created Active Reports which made offline analytics easy in order to get truly portable business intelligence.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Excellent technical and analytical problem solving skills, strict attention to detail and have the ability to work independently as well as in a team environment.
• Effective communicator with excellent relationship building and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Databases: MS SQL Server, MySQL, Oracle 8i/9i/10g, MS Access, DB2

Software: MS Project, MS Visio, MS Office

Languages: C, C++, C#, Java, SQL, PL/SQL, XML

Business Intelligence Tools: IBM Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), Framework Manager, Tableau

ETL Tools: Pentaho

PROFESSIONAL EXPERIENCE

Android Application Developer

Confidential

Roles & Responsibilities:

• To create a user interface and add functionalities such as add, delete or modify tasks to the list view.
• Add a dynamic adapter to the list view.
• Store the user data in the database and able to retrieve it when necessary.
• Change the background of the application.

Environment: Android Studio

Confidential

Project was designed

Roles & Responsibilities:

• SDLC was used for the development.
• Involved in creation of software requirement specification document.
• Had an active role in front end development using ASP.NET and the business logic in C# and ADO.NET with SQL server 2012.
• Developed administration tools using C#, ASP.NET and ADO. NET with SQL server 2012.
• Used ADO.NET entity framework for creating data classes.
• Developed test cases and had an active role in unit testing and manual testing of the application.

Environment: ASP.NET, ADO.NET, SQL server 2012, C#.NET, XML

Confidential

CognosDeveloper

Responsibilities:

• Participated in the workshops for gathering requirements. Analyzed the Business Requirements Document based and performed ambiguity reviews of business requirements and functional specification documents.
• Involved in the Design discussions of the Mappings for data loading
• Imported Metadata from different data sources, Developed Framework Manager Model to meet reporting requirements.
• Created database layer, business layer and Presentation Layer, defining appropriate relationship between query subjects based on the user requirements.
• Developed complex prompt pages using multiple styles of prompt functionality
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query reports, Conditional formatting, Conditional Blocking, Burst Reports against database.
• Developed Product, Manufacturing, After sales and Distribution, Quality related Reports
• Involved with Scheduling and Distributing Reports through Schedule Management
• Designed and developed the reports as per the requirements in IBM Cognos 10.
• Developed active reports using Cognos 10.
• Developed PowerPlay Cubes for better analysis of the data.
• Implemented the security setup for reporting and User setup for BI reporting Access Manager and Sun one Directory server.
• Created Complex reports using Multiple Drill through, Conditional Layout.
• Developed Technical Specification documents for all newly developed and modified processes.
• Added Package level security to the packages and Object, Data level security to the Query Subjects
• Published the Cubes to IBM Cognos 10 Analysis Studio using Framework Manager.
• Modified existing reports to incorporate the changes in the Source System.
• Responsible for documenting the code changes as per the User change requests.
• Developed SQL queries to test the Database values for data Integrity.

Environment: Oracle 10G Database, IBM Cognos 10, Cognos Framework Manager, CognosPowerPlay Transformer, Active reports, Windows 2000 Server.

Confidential

Cognos Consultant

Responsibilities:

• Created multiple models to meet the need of adhoc and canned reports. Modified the existed model of Phase 1 and took care of all business needs for phase 2.
• Back-end Development: Developed multiple SQL statements/files for exceptions management to exclude accounts based on complex business logic.
• Developed FM model for report studio developers
• Created Project files and Published projects from the FM Models
• Created Query subjects, query items, Filters, Namespaces
• Handled Complex Queries as separate Query Subjects.
• Setup report bursting and scheduled it to run on the specific day of every month.
• Cognos Administration: Defined roles and permission and matched them across all environments for multiple applications (linked the reports to dashboards
• Performed data quality checks in the reports
• Worked on report performance Improvement project - found issues and fixed them.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio), Oracle 10 G, Windows