- 4+ years in analysis, development, testing and implementation of Business Intelligence applications using Cognos Suite products and AWS services
- Acquired Hands on experience in AWS services (EC2,S3,RDS,DynamoDB,IAM,AWS kinesis,Cloudwatch,VPC,Subnet, Lambda, AWS Auto Scaling, Load Balancer,SQS,SWF,SNS,CDN, Route53,Cloud formation using yaml)
- Good business knowledge for report requirements in Banking, And Retail Industries.
- Expertise in Cognos 10 BI Suite (Framework Manager, Cognos connection, workspace, workspace Advance, Report Studio, Analysis Studio, Event Studio, Transformer and Query Studio) and Cognos 10.1, 10.2 & 10.2.1Suite.
- Expert in creatingList, cross tab, drill through, master - detail, chart and complex reports which involvesMultiple Prompts in Report Studio, Bursting of Reports,using various forms of outputs..
- Developed and Published Packages using Framework Manager- Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
Tools: Cognos 8.4, 10.2.1, Transformer, Framework Manager, Query Studio, Report Studio, Analysis Studio
Databases: Oracle 11g,RDS, DynamoDB
Languages: SQL, HTML,JSON, YAML
Confidential, Irving, TX
AWS Infrastructure Engineer
- Launching Amazon EC2 Cloud Instances using Amazon Web Services (Linux/ Ubuntu) and Configuring launched instances with respect to specific applications.
- Perform S3 buckets creation, policies and the IAM role based policies.
- Implemented and maintained the monitoring and alerting of production and corporate servers/storage using AWS Cloud watch.
- Created monitors, alarms and notifications for EC2 hosts using Cloud Watch.
- Leverage AWS cloud services such as EC2, auto - scaling and VPC to build secure, highly scalable and flexible systems that handled expected and unexpected load bursts.
- Involved in designing and deploying multitude applications utilizing almost all of the AWS stack (Including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, and auto scaling in.
- Configured AWS IAM and Security Group in Public and Private Subnets in VPC.
- Created AWS Route53 to route traffic between different regions.
- Responsible for Security, including opening different ports on security groups and also Network ACL's.
- Configure different Notifications on AWS Services.
- Designing a backup solution and Disaster Recovery for the product and infrastructure in the cloud.
Confidential, Irving, TX
- Developed various complex and customized (Inserting tables and Blocks) reports using prompts
- Involved and performed unit testing (manual testing) for the reports that have been developed
- Created drill through definitions in the reports based on the cubes to drill down to detail level of the data.
- Modeled the metadata in the project by adding business rules such as filters and calculations
- Participated in Created Framework packages with various security settings and published onto Cognos connection.
- Participated in Building power cubes with package as source using Cognos transformer
- Developed complex reports like multipage reports with master detail relationships, Prompts, Calculations and Conditions using Cognos report studio In PDF and excel and adhoc reports using query studio
- Created List, Cross Tab, Repeater, Chart reports and drill through reports in report studio
- Created Dashboards in workspace and workspace advanced
- Worked with Analysis Studio to develop multi-dimensional reports and applied context filters for better analysis
- Involved in developing Drill up and Drill down reports using Analysis Studio
- Performed unit testing and documented test cases and detail design of the project
Environment: Cognos 10.2.1 (Report Studio, Query Studio, Analysis Studio, Event Studio, Transformer, Framework Manager), 10.1 Oracle 11g, Windows 7/XP.
Confidential, Atlanta, GA
- Worked with Business analyston Gathering and analyzed business requirements from users and business community.
- Created Drill Through reports and Conditional Formatting by using Report Studio.
- Created reports like List, Cross tab and Dashboards by using Report Studio.
- Extensively worked on complex reports drill through reports, master detail reports,. Developed Multi Page Reports..
- Managed Scheduling of Reports
- Involved in analyzing the cardinality between query subjects.
- Customized data by adding Calculations, Filters, Prompts and Governor Settings.
- Production Support which involves solving user problems.
Environment: Cognos 10.2.1(Framework Manager, Powerplay Transformer, Cognos Connection, Report Studio, Query Studio), SQL server.